Lynn Pettis

  • Interests: Sci Fi, Fantasy, Swords and Sorcery, Computers, Soccer (coach and ref)

SQLServerCentral Article

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)

You rated this post out of 5. Change rating

2011-02-18 (first published: )

53,499 reads

SQLServerCentral Article

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)

You rated this post out of 5. Change rating

2009-03-13 (first published: )

25,626 reads

Blogs

Using a tnsnames.ora file with the Microsoft Connector for Oracle in SSIS

By

One of the nice things about the Microsoft Connector for Oracle is that it...

ChatGpt Experiments–Getting Documentation

By

I get asked questions by salespeople all the time. Usually this is because a...

A New Word: Jouska

By

jouska – a hypothetical conversation that you compulsively play out in your head –...

Read the latest Blogs

Forums

How Can I Speed This Query Up?

By water490

Hi everyone My SQL query is close to 1000 lines with 17 separate calcs...

partitioning a huge table

By anoop.mig29

Hi folks I would like to get your views about  partitioning  a huge table...

SQL Website Development: A Comprehensive Guide to Building Dynamic Web Applicati

By JosephTalor1

Introduction to SQL Website Development What is SQL? Importance of SQL in web development...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers