2012-06-06
3,063 reads
2012-06-06
3,063 reads
Often someone will try to perform a delete on a large number of records and run into a number of problems. Slow performance, log growth, and more. Lynn Pettis shows us how to better handle this situation in SQL Server 2000 and SQL Server 2005
2011-02-18 (first published: 2009-09-15)
53,694 reads
If any of you follow me on SQLServerCentral.com, then you know I recently started a new job. Well, after two...
2010-08-26
1,679 reads
On June 1, 2010, Steve Gray had an article, Sins of SQL: The Time Table, published on sqlservercentral.com. I’m not...
2010-06-03
2,559 reads
2010-04-30
3,420 reads
This is not a technical post, it’s personal, but I need to express my fears. It isn’t about our economy,...
2010-04-01
1,552 reads
Building a tally table is a common T-SQL problem that many new developers struggle with. Lynn Pettis brings us an article that shows how to use CTEs to accomplish this.
2009-09-22
10,657 reads
Okay, my second article which was originally published on sswug.org, is now available on SQLServerCentral.com. This article compares two methods...
2009-09-21
1,249 reads
Well, the first of two articles I originally had published on sswug.org will be published on ssc tomorrow. I'm looking...
2009-09-14
1,490 reads
I realize I have been relatively quiet for a while, but summer is actually a fairly busy time for us...
2009-08-22
1,202 reads
By SQLPals
Get Configuration Change History From the SQL Server Error Logs There...
By SQLPals
How To Gain Access To SQL Server When No DBA ...
Comments posted to this topic are about the item Gentlest of Reminders, Don't Stop...
Gurus, there is a table which is very slow to query , it has...
Hi. I have a query that returns few rows (out of 7 table join,...