767 reputation
26
bio website
location Arkansas
age 34
visits member for 2 years, 10 months
seen Oct 9 at 19:45

Data Warehouse Specialist / Database Developer / Database Administrator


Dec
11
answered Why is this key lookup required?
Dec
11
comment Why is this key lookup required?
Have you updated statistics lately? Estimated Number Of Rows is 1 while Actual Number Of Rows is 10,259,536... Dated stats can lead to bad query plans (insufficient memory allocated for joins and sorts, bad join algorithm choices...).
Dec
5
answered error in Execute SQL Task with parameter
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.