Key Discovery III

In Part I and Part II of the series, I discussed documenting and discovering Primary Keys and Clustered Indexes.  In...

Key Discovery III

Recursively traverse system views to build a Hierarchical Perspective into the database.
Related Posts:

T-SQL Tuesday Participation Over the Years December 19, 2018

T-SQL Tuesday #104: Just Can't Cut That Cord...

PASS Acquires SQLSaturday

I’ll write more about this tomorrow, but for now I’m reposting the release from Rushabh Mehta, President, PASS:
It gives me...

Providing Online Help for Powershell Modules

As a finishing touch for the SQL Server Powershell Extensions 2.0 Release I wanted to provide an online version of...

RedGate Releases SQLSearch - FREE!

RedGate Releases SQLSearch - FREE!
SQL Search - Released
My friends at RedGate have released a new FREE Tool. Please read on to learn...

Reflections on ‘Visibility, the Art of Being Noticed’ by Phil Factor

If you have not read the Master of Phrenetic Phoughts’ article, please do so here. I enjoyed very much the...

SQLSaturday Bequeathed to PASS

I guess you could look at this one of two ways. Either PASS acquired SQL Saturday, or we (Andy, Brian,...

Three Engine Improvements in SQL Server 2008 R2

The upcoming (by May 2010) of SQL Server 2008 R2 has been primarily focused on enhancements in the BI area...

Three Engine Improvements in SQL Server 2008 R2 (Updated)

The upcoming release (by May 2010) of SQL Server 2008 R2 has been primarily focused on enhancements in the BI...

Find Efficiencies or Add Horsepower?

In our world sometimes it’s worth the time and effort for in depth tuning to get the machine to run...