meta user
network profile
| bio | website | |
|---|---|---|
| location | Arkansas | |
| age | 32 | |
| visits | member for | 1 year, 5 months |
| seen | 16 hours ago | |
| stats | profile views | 21 |
Data Warehouse Specialist / Database Developer / Database Administrator
|
20h |
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. |
|
Dec 11 |
answered | Why is this key lookup required? |
