2012-06-06
3,081 reads
Lynn Pettis
- Interests: Sci Fi, Fantasy, Swords and Sorcery, Computers, Soccer (coach and ref)
Deleting Large Number of Records
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)
54,488 reads
Entering the Dark Side
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,687 reads
Sins of a Recursive CTE?
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,579 reads
2010-04-30
3,428 reads
Getting Scared
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,556 reads
The Dynamic Tally or Numbers Table
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
11,116 reads
My next republished article is now available
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,252 reads
Republished Article
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,499 reads
Welcome Home !!
I realize I have been relatively quiet for a while, but summer is actually a fairly busy time for us...
2009-08-22
1,208 reads
Blogs
The fundamental requirements of a reporting system
By ChrisJenkins
There are some fundamental boxes that your reporting system must tick. ✅ The figures...
Seeing the Bigger Picture: How A Monitoring Tool Changed My Approach to Estate Management
By Chris Yates
When it comes to managing complex database environments, having the right monitoring solution is...
A New Word: Foilsick
By Steve Jones
foilsick – adj. feeling ashamed after revealing a little too much of yourself to...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
The Last Good DBCC Run
Comments posted to this topic are about the item The Last Good DBCC Run
count the number of NULLs in a row
Hi everyone I have a SP that finds the average based on 3 tables. ...
Question of the Day
The Last Good DBCC Run
I want to check when DBCC CHECKDB was last run on my Baseball database. What code should I use?
See possible answers