2012-06-06
3,089 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,557 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,694 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,591 reads
2010-04-30
3,435 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,561 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,195 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,257 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,503 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,215 reads
Blogs
The end of an era – why I chose not to renew my MVP
By DataOnWheels
Two years ago, two things happened within a few days of each other. I...
PowerShell Strikes Back: A New Script
By gbargsley
This is it. The final chapter of PowerShell Strikes Back. Over the past four...
Claude Desktop
By Arun Sirpal
Claude is more than a chat window. The desktop experience includes structured workspaces, generated...
Forums
Unraveling the Mysteries of the Ephemeral Model: The Fabric Modern Data Platform
Comments posted to this topic are about the item Unraveling the Mysteries of the...
QUOTENAME Behavior
Comments posted to this topic are about the item QUOTENAME Behavior
Running script without having permission to Function
Good Morning. I have a T-SQL Script which has been developed to execute a...
Question of the Day
QUOTENAME Behavior
I use QUOTENAME() like this in code?
DECLARE @s VARCHAR(20) = 'Steve Jones' SELECT QUOTENAME(@s, '>')What is returned? See possible answers