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


Jul
12
answered What is a good way to replicate code across multiple databases?
May
24
comment Updating a table with millions of records, its been 4 days
"a function on a WHERE predicate" means indexes won't be used". This is not always true. Granted, it's true for this case but sometimes you can get a seek. See Rob Farley's article: msmvps.com/blogs/robfarley/archive/2010/01/22/…
May
4
answered Database stuck in restoring and snapshot unavailable
Jan
10
revised Remote queries and linked servers
deleted 11 characters in body
Jan
10
comment How do I add minutes to a time data type?
+1 @Aaron Alternatively you can convert StartTime and TimeToAdd to datetime and then add. Converting TimeToAdd will be very messy when the minutes are > 59. DATEADD is the best solution.
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.