Efficiency of Subqueries and OR conditions in SQL

A discussion of how joins significantly outperform subqueries and how this is more evident when OR conditions are involved.
SQL queries...

Looking Back at SQLRally Orlando

It’s been almost two weeks since we wrapped up our first SQLRally, and in some ways it hasn’t quite sunk...

Monitor your SQL Server Agent Proxies Using PowerShell

Over time it's easy to lose track of the things you set up to get work done. As a consultant,...

New Whitepaper: Performance Evaluation of Hosting TempDB on FusionIO

New Whitepaper: Performance Evaluation of Hosting TempDB on FusionIO

A colleague I work with on the PQO* Operations SQL V-Team, Jonathan...

Nominations are Open for the Fourth Annual Exceptional DBA Awards

SQLServerCentral.com, along with Red Gate Software, are glad to announce that nominations for the fourth annual Exceptional DBA Awards are...

Oh ****!

Did you ever accidentally close SQL Server Management Studio? And, in closing SSMS, did you get the prompt that says...

Recovery Model for Every Database

One thing that is enjoyable about my position is working with people who have no idea what SQL is besides...

SQL Server Migration Assistant v5.0

I bloog about mysql to sql server migration lastly here Today found very good migration tool Free Downloads: 1. SSMA...

SQL Treeo – Create custom folders in SSMS

SQL Treeo is free add-in to SQL Server Management Studio (SSMS) which enables user to create own folder structures within...

SSRS 2008 R2: How to dynamically size your INDICATORS

The indicators that are available in SQL 2008R2 adds great visualizations to your reports. I was recently building an SSRS...