4,804 reputation
1820
bio website lobsterpot.com.au
location Adelaide, Australia
age 40
visits member for 3 years, 2 months
seen 37 mins ago

Owner / Principal at LobsterPot Solutions

Adelaide (Australia) based SQL MVP

On twitter @rob_farley

Blog at http://sqlblog.com/blogs/rob_farley
(Old blog at http://msmvps.com/blogs/robfarley)


34m
comment Shrink logs in between user transaction in SQL Server
It could be that you're checkpointing a different database to the log that's filling up.
34m
comment Shrink logs in between user transaction in SQL Server
Like... If you get rid of "DatabaseName." from your query, does it still run?
35m
comment Shrink logs in between user transaction in SQL Server
Oh - hang on... Are you using the same database as the one that contains the table?
36m
comment Shrink logs in between user transaction in SQL Server
Try running checkpoints in a separate session, over and over while your deletes are going on.
1h
comment Shrink logs in between user transaction in SQL Server
Make your number a lot smaller. Try something tiny, like 500. Put a print statement in there and check that it's going okay. It'll take ages, but 2M rows at a time might be blocking too many other transactions.
1h
answered Shrink logs in between user transaction in SQL Server
1d
awarded  Mortarboard
2d
revised Retrieving n rows per group
added 1355 characters in body
2d
awarded  Nice Answer
Dec
25
answered how to Write a SQL Statement to display EmployeeID from Table1 and EmployeeName from Table2 a
Dec
23
revised Retrieving n rows per group
added 1507 characters in body
Dec
23
revised SQL Mirroring Down between Principal / Mirror
added 2 characters in body; edited title
Dec
22
revised Retrieving n rows per group
added 23 characters in body
Dec
22
answered Retrieving n rows per group
Dec
22
awarded  Revival
Dec
22
revised Improving the performance of STIntersects
Dec
22
answered Improving the performance of STIntersects
Dec
22
answered How do I determine if a SSIS transform is non-blocking, partially blocking, or fully blocking?
Dec
21
answered Deleting duplicate rows with condition(Using SQL and LINQ)
Dec
21
comment Why doesn't a delete increase unused space in a table?
...because the heap is still using it.