Virtual Presentation : Index Statistics

I just gave a virtual presentation, courtesy of Pass and the appdev group.  The recorded presentation is available here:
Recorded Presentation
 
A...

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...

Inserting into an XML document

I was reading through the latest XML Workshop article that I have from Jacob Sebastian. It’s a fantastic series for...

An Un-CATCHable Error?

I've been using the scripting tools in SSIS for some time, but I came across something today that I can't...

Plagiarism Again

Update: The problem posts have been removed from the SQLTechConsulting site.

I ran across a note from Brent Ozar (blog | Twitter)...

Critiquing Free Events

Yesterday I wrote about expectations at free events, basically saying they don’t differ a lot from paid events. The next...

Access Analysis Services via T-SQL?

It occurred to me the other day that it might be interesting to manage aggregates in an SQL Server database...

Why UniqueIdentifier is a Bad Choice for a Clustered Index in SQL Server

I had a question today about why it was “bad” to use a UniqueIdentifier as the data type for a...

SSWUG Ultimate vConference Discount Code

The SSWUG Ultimate Virtual Conference is coming up on April 7, 8, and 9th.  This is three days of very...

SP_SPACEUSED & SP_MSTABLESPACE

Take a look two SP inside the sys Procedure in SQL Server 2008 (included also in the SQL Server 2005),...