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

3.11 (111)

2011-02-18 (first published: )

52,593 reads

Calculating Age

T-SQL calculations can get tricky at times, and since you often work with multiple rows, it's good to be exact in your data manipulation. New author Lynn Pettis brings us an article about calculating ages.

2.8 (84)

2009-03-13 (first published: )

25,290 reads

Blogs

Book Review: Lights Out

By

I have always been interested in GE since I was a kid. My best...

A Successful Blogger on Making the Switch

By

For Kyla Marie Charles, switching to WordPress.com opened up possibilities for her website and...

Login Timeouts

By

I was recently approached at work about a company that was seeing tons of...

Read the latest Blogs

Forums

Please recommend me some documents about SQL ?

By LloydRice

I am working with a new field, which is SQL, do you know about...

The metadata could not be determined because statement

By rohitkocharda

Hi everyone, I am running into a \n issue and it seems like none...

would like to know SQL server 2017 Reporting Services Log File Location

By mandavli

would like to know SQL server 2017 Reporting Services Log File Location. I really...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers