Left outer join vs NOT EXISTS

And to wrap up the miniseries on IN, EXISTS and JOIN, a look at NOT EXISTS and LEFT OUTER JOIN...

A little restriction that prevent changing tables in SQL Server 2008

In SQL Server 2008, by default, the option to prevent tables changes is "on". We can have some issues and...

Minimizing Fragmentation when Moving data using a Switch

Yesterday was the first day of the SQL Server 2008 R2 airlift.I attended a great session on Implementing a Fast...

Microsoft SQL Server identify I/O bottlenecks

You can also identify I/O bottlenecks by examining the latch waits. These latch waits account for the physical I/O waits...

Thoughts on SQL Server Certification

This is probably part 1 of a series, but no guarantees.

Why Certify?
I've been working with SQL Server for 10 years...

Scripting database objects in SQL Server 2008

In this article, we would go through the
steps to script the objects in a database using SQL Server 2008....

Finding Date Ranges for Calculating Statistics

Finding Date Ranges for Calculating StatisticsI received the following question from a fellow DBA:
I need your input to derive the...

Solving All Versus (Select All) SSRS End User Confusion

 
When developing reports that use Analysis Services as a data source end user can sometimes be confused about some of...

Breaking Down TempDB Contention

Breaking Down TempDB Contention 
What is tempDB contention? From the outside looking in, tempDB contention may look like any other blocking. There...

SSRS – KPIs without Analysis Services

During a recent project I was asked if it was possible to simulate Key Performance Indicator (KPI) images in SQL...