732 reputation
25
bio website
location Arkansas
age 33
visits member for 2 years, 4 months
seen Apr 17 at 18:43

Data Warehouse Specialist / Database Developer / Database Administrator


Jan
10
comment Remote queries and linked servers
So you're suggesting a RBAR update? Using OLE DB command for UPDATE = RBAR
Jan
9
answered Remote queries and linked servers
Dec
19
comment Bulk Data Loading and Transaction Log
Good deal. While the Checkpoint will get the table loaded, getting a minimally logged bulk insert should be a significant performance boost. The TABLOCK should get it done.
Dec
19
comment Bulk Data Loading and Transaction Log
I believe I see the issue. Not sure how I looked this over. The bulk insert isn't using the tablock option. msdn.microsoft.com/en-us/library/ms190422.aspx TABLOCK is the second bullet of the pre-requisites.
Dec
19
comment Bulk Data Loading and Transaction Log
Did you split the procedures up? Which one is popping the log? The bulk insert or the merge?
Dec
19
revised Bulk Data Loading and Transaction Log
deleted 92 characters in body
Dec
19
answered Bulk Data Loading and Transaction Log
Dec
13
revised Expanding a partitioned table
added 152 characters in body
Dec
13
answered Expanding a partitioned table
Dec
13
revised How to prevent SQL Server service account from registering / deregistering SPN?
Added msdn reference
Dec
13
answered Performance benefit of taking unused databases offline
Dec
13
revised How to prevent SQL Server service account from registering / deregistering SPN?
added 64 characters in body
Dec
13
answered How to prevent SQL Server service account from registering / deregistering SPN?
Dec
12
comment Why is my database stuck in the Restoring state?
Just an fyi, you can check the status of a database restore and get an estimated amount of time for it to complete. Not sure what's actually going on, but would be interested to see what the query results are. The query can be found here: sqldbadiaries.com/2010/09/07/… Just change the where clause from B.COMMAND LIKE '%BACKUP%' to B.COMMAND LIKE '%RESTORE%'
Dec
12
comment Why is this key lookup required?
+1 Good catch @Roji I looked right over that. Still 1216 is well below 10 million so there is still a statistics mismatch. Also, OP stated in the comment that updating stats resolved the issue.
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?