Eliminate table scans. An alternative to SELECT COUNT(*) FROM...

New post under SQL - Query Tuning on the right.  Use DMV's to return rowcounts without giving away too many permissions.





Upgrading to SQL 2008 ServicePack 3 - problems

I tried to apply the SP3 update to SQL 2008 and now none of my users can connect.  They're greeted with "Server is in script upgrade mode".

I've done the Googling for you.  Check out my "Upgrade Issues" link under the SQL heading on the right.


Analyzing SQL Server Performance:  MDW

I recently discovered a tool that gives me a heads-up into performance across my SQL boxes:  MDW.  MDW provides graphical reports that allow me to quickly delve into the top waits in my system and what's causing them.  Rather than rehash what's already been said about getting MDW configured in your environment I'll hit some of the things that came up in my configuration that haven't been exhaustively covered in other areas of the web.  Check out my MDW link under the SQL heading to the right.


Reporting on Exchange NDR/Undeliverable E-mails

Recently I was asked to report on the non-deliverable (bounceback) e-mails we were sending from an internal mailbox.  I put together a Powershell script that grabbed the information from Exchange (version 2007 or above) then imported it into a SQL Server database using SSIS.

In my first post of this series I'll be going over the Powershell script to get e-mails out of the Exchange system then will be posting one of my first (and more exciting) attempts at an ETL solution using SSIS.

Check out the Bounceback Project heading under SQL on the right.

Stay tuned!


Optimize Oracle with CLUSTER's and Index Organized Tables

We have a few nightly processes and day-end reports that are causing contention in the database and all around performing badly.  Look at my latest post under the Oracle heading to the right, under "Oracle - performance tuning" for how I solved these issues using Oracle CLUSTER's.