Don Peterson


Is XML the Answer?

New Author! Don Peterson writes his first article for us and explores why he considers XML to be...bad! There are some interesting points made here and if you've haven't thought about what XML means to you as a DBA, it's a subject worth spending some time on.

4.77 (79)

2008-05-02 (first published: )

64,326 reads

Beware of Search Argument (SARG) Data Types

Performance tuning often seems like it can be more of an art than a science. However there are a number of fundamentals that can help you tune most of the queries that you will write or have issues with their performance. Don Peterson brings us a look at how he tuned a query in the real world to avoid a conversion that can cause a query to run slower.

5 (6)

2006-07-13

11,549 reads

Lookup Table Madness

Are you mad? Not angry, more like crazy when it comes to designing databases in SQL Server? Don Peterson has met a few people he thinks are just that when it comes to building lookup tables. Does it stem from poor understanding of database design? Or do you disagree? Read Don's case against this particular design practice.

4.46 (26)

2006-03-24 (first published: )

48,428 reads

All About Transactions - Part 3

Transactions in SQL Server are probably no more complicated than those in other RDBMS products, which is to say they are fairly complex. Don Peterson continues with part 3 of his series and takes a look at transaction isolation levels and how they interact with multiple connections and their impact on locking.

4.33 (9)

2004-12-02

15,085 reads

All About Transactions - Part 1

The heart of an RDBMS is the transaction system that it employs. SQL Server has a great one that can easily be misunderstood or misused by those that haven't spent time delving into the details of how it works. Don Peterson has done that and brings us the start of a new series on the details of how transactions work in SQL Server.

4.62 (13)

2004-11-15

23,561 reads

Blogs

Daily Coping 21 Jan 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

It’s 2021, so why are you reading this?

By

If you’re reading this, there’s a good chance you’re straight, white, male, and English-speaking....

Daily Coping 20 Jan 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Save results from Stored procedure to a CSV file.

By lee.hopkins

I have a SqlAgentJob calling a stored proc. that loops through a list of...

Search Report definitions

By dan-572483

I know that there is a query you can run in SQL to search...

Lookup and insert into column without dynamic SQL?

By kramaswamy

Hi all, 99% sure the answer to this question is "it is not possible",...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers