Performing Fast Searches of Query Plans

Performing Fast Searches of Query Plans
XML: Fast as a Turtle

I've made blog posts in the past on using the exist()...

Stress Testing Stored Procedures with Free Tools

I currently have a presentation named Performance Tuning for Pirates. This presentation goes over using several free tools to help...

Understanding the CDC State Value

If you are using Change Data Capture (CDC) it can be very useful to look at the CDC State table...

Link List for July 12, 2012

Here are a few things I’ve found/had sent to me recently you may find interesting:
Most Common GRE Words. 400 words...

Denali – Memory: “any size” page allocations

I blog introduction to Memory here. Considering you already know memory concept, till sql server 2008 R2, memory management is divided...

SQL Server DBA Tool Kit

Right next to my batarang and bat-zip-line-hook-shooter-gun on my utility belt is my SQL Server DBA Tool Kit, full of...

SQLSaturday #158 Event Update & Hotels - Where are you staying?

 Well, we're just a few weeks away from the return of SQLSaturday to NYC as SQLSaturday#158, and it is sure...

SQL SERVER : SQL Server Scheduler

While troubleshooting the performance issues of SQL server, you might have seen the sessions are in different state like SUSPENDED,RUNNING,RUNNABLE etc....

SQL SERVER - CTRL+SHIFT+] Shortcut to Select Code Between Two Parenthesis

Reblogged from Journey to SQL Authority with Pinal Dave:
Every weekend brings creative ideas and accidents brings best unknown secrets in...

Parallel Data Warehouse (PDW) Basics: CREATE TABLE and CTAS Syntax

After forgetting the syntax for temp tables a couple of times, I decided to write a brief overview of the...