Data Needed to Recover SQL server from a Host Crash

Am sure every DBA has once in his/her career  come across a situation of recovering a database or an instance...

What happens when you execute a query

When a query is submitted to SQL server it goes through several processing steps. A proper understanding of these steps...

SQL Join Algorithms

SQL queries implement various joins when datasets are to be retrieved from one/multiple tables and merged on a certain criteria...

Outlier Detection with SQL Server, part 8: A T-SQL Hack for Mahalanobis Distance

By Steve Bolton
…………Longer code and substantial performance limitations were the prices we paid in return for greater sophistication with Cook’s...

Argenis and Ryan

It’s the time of the year when PASS holds its annual elections for the board of directors. This year we...

Fall Means Election Season

While it’s not officially Fall yet, it is definitely Election Season. Elections for the PASS Board of Directors opens up...

Extended Events – Event Anatomy

As a follow-up to the introduction to what an Event is, it makes sense to discuss the components of an event. What makes up an event? What is the...

Extended Events – Event Anatomy

So far in these brief discussions about Extended Events, I have covered several core concepts including a basic introduction into...

Work of art – the intra query parallelism deadlock graphs

Look at some of the graphs produced by the intra query parallelism deadlocks, below.

Bart Duncan explains this “phenomenon” (bug, rather)...

A look on the CXPACKET wait type

I was given a task to optimize a black-box application. I wasn’t able to see its code, but the database was open for analysis. I caught the queries from...