SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: October 2012

Find Duplicate (and covered) Indexes

A while back, I wrote a simple little query that lets you Get Index Included Column Info (because sp_help and sp_helpindex only show non-included index columns).  More recently, I’ve been wanting not only a better way to look at index information, but a way to compare indexes…for example, to find… Read more

0 comments, 1,631 reads

Posted in SQL Awesomesauce on 11 October 2012

Lose #5 Before #sqlpass

Win Valuable Prizes!
Impress Your Friends!

This week we’re starting up a health and weight loss competition that I hereby dub #PASSGameOn, because it ends right before PASS Summit (no, you don’t have to attend PASS to participate). Tom LaRock (Twitter, blog)  and I are hosting!

Here’s what… Read more

0 comments, 949 reads

Posted in SQL Awesomesauce on 10 October 2012

Interview with a #SQLPASS Candidate – @NTSSUG’s Sri Sridharan!

Last week, Sri Sridharan (Twitter, blog) and I sat down on the Internet to talk about his run for the PASS Board of Directors. Due to various difficulties*, the resulting video is a ridiculous-looking hack bit cobbled together, but the audio’s just fine.  And really, isn’t it… Read more

0 comments, 695 reads

Posted in SQL Awesomesauce on 9 October 2012

PASS Summit: What’s all the hype?

Last week I received this comment/question from one of my fabulous First Timers:

I have a good natured question coming from an jaded old bitter DBA, what’s all the hype? I’ve been to a few conferences and I usually just show up, find the interesting or necessary presentations and go…

Read more

0 comments, 722 reads

Posted in SQL Awesomesauce on 8 October 2012

PASS First Timers Guide and Schedule – 2012 edition

Hi there ho there everybody! It’s less than five (FIVE!) three (THREE!) one (ONE!!) week until the 2012 PASS Summit in Seattle, I am now the Fearless Leader for a group of PASS Summit First-Timers!  Again! This is the page wherein I record all of my sage advice and… Read more

6 comments, 1,200 reads

Posted in SQL Awesomesauce on 3 October 2012