757 reputation
25
bio website
location Arkansas
age 33
visits member for 2 years, 8 months
seen 5 hours ago

Data Warehouse Specialist / Database Developer / Database Administrator


Dec
5
comment error in Execute SQL Task with parameter
What type of connection manager is the database connection defined as? OLEDB? ADO.Net?...
Dec
3
comment Is the SQL Server Express memory and CPU limit per instance?
Not following either. This seems somewhat ambiguous. The document says 1 GB per database engine. I believe each service/instance would count as a separate engine, so they'd each get 1 GB. Roy, do you have any other references on this?
Dec
2
awarded  Yearling
Nov
24
comment What is the fastest way to export a table to a text file
I see the links and fully agree. But most of the optimization points are for loading data into sql server. I've yet to see any facts related to bcp being faster than a streamwriter or filestream CLR solution when writing sql data to a flat file.
Nov
24
answered What is the fastest way to export a table to a text file
Nov
21
answered Sql Server memory issue
Nov
17
comment Average Time to Load 1.2 million records from Oracle INTO SQL SERVER 2008R2
What recovery model is the destination database in? This seems unreasonably slow. Post the table definition for the destination table. It sounds like either your table is really wide, you're in the full recovery model, you have some heavy transformations in the data flow task, the destination table has a clustered index which is forcing the data to be sorted before insert, or a mixture of the above. Additionally, disk speed or network throughput could be part of the issue. Alot of unknowns here.
Nov
2
comment Why is my CPU usage increase after setting database to read-only on SQL Server 2008 R2
What are you doing to copy the database? Are you doing a full refresh of each table? Are you doing any index maintenance or updating stats before setting the database to read-only? Does your denormalized design contain the appropriate covering indexes?
Nov
1
comment TempDB size issue after applying Indexes
+1 SSMS actually has a built in report which will show when the data file(s) grew and by how much. In SSMS, Right click tempdb->Reports->Disk Usage . Any autogrowth since the last service start should show up in the report.
Oct
31
comment PAGE compression in SQL Server effect on running queries
Is the table partitioned?
Oct
31
comment Partitions and Indexes, in which cases should be used
+1 @Remus Partitioning should only be used after careful evaluation. See Kendra Little's blog on whether to partition: brentozar.com/archive/2012/03/… If you don't know what you're doing with partitioning, performance will go south quickly.
Oct
31
comment UDF performance suddenly degraded
Just curious. Have you tried "SELECT from @TableVar OPTION(RECOMPILE)"? Table variables are known to get an estimated row count of 1 due to not having statistics. Using OPTION(RECOMPILE) may help with the estimated row count on the select statement. sqlservercentral.com/blogs/dave_ballantynes_blog/2011/12/02/…
Oct
2
awarded  Critic
Sep
14
revised Does dropping a Primary Key constraint from a Partitioned Table break the partition?
added 3 characters in body
Sep
14
answered Does dropping a Primary Key constraint from a Partitioned Table break the partition?
Sep
13
comment Why does a VIEW with a CLUSTERED index not use the index?
+1 Good catch @Damien_The_Unbeliever
Aug
25
comment Is it possible to get SQL Server 2008 to download a file from a URL
+1 Remus. Great advice. I just wish that you'd suggested an appropriate way to do this. Seems more like a comment than an answer.
Aug
25
answered Is it possible to get SQL Server 2008 to download a file from a URL
Aug
24
comment How do you roll up header-level values on a fact table with line-item granularity?
+1 This will work. You can even get rid of the Shipping Amount column.
Aug
21
comment SQL Server data partitioning
+1 Denny.The Update is certainly the easiest to implement. The top clause will maximize concurrency and minimize the chance of filling the log (putting the db in recovery). It may run for hours/days though. If the record count is fairly low and you have a decent maintenance window, it may actually be the best option. However (you're the IO guru so correct me here), if the entire partition is affected and the record count is high millions/billions, would partition switching, mixed in with a few other minimally logged executions, not be significantly faster and require less IOPS than the Update?