The 'smart' delete

Deleting rows from SQL Server database table is not as simple as it sounds.

The ‘straight forward’ delete – go delete, no matter what!

Yes, there is the DELETE statement:

?View Code TSQLDELETE table_1 WHERE ColumnName = ‘some_value’

What is the problem with that?

There are several problems:

transactions and logging
disk space
time consuming
locking and concurrency
IO throughput
parallelism, if present

So, it depends how

Continue reading […] The ‘smart’ delete […]

 

Changing the default trace settings

Recently I emailed a few great DBA stars with a question:

 

I have a question for you: do you know if there is a way to alter the properties of the default trace in SQL Server 2005 and 2008? More specifically, I am curious if we can change the number of rolled over files and their

Continue reading […] Changing the default trace settings […]