This weekend was SQL Saturday #33 in Charlotte NC and also the first one I attended. It's been a long weekend, but I wanted to get my thoughts down while they're still fresh. Be warned, it's been a long weekend, so my grammar and attempts to reign in my propensity for verbosity have both gone out the window.

Background

Sorry SQL Saturday? Tarwn and SQL? We have questions and we know how painful it is for you to write short blog posts...

SQL What?

SQL Saturday is...

Sometimes you want to know what the percentage is of null values in a table for a Column

Or you might want to know what the percentage of all values in a Column is grouped by value

You can get these answers by running the code below

First create this table

You have only $50 left and you can buy two DVDs or one SQL book, what do you do? I would buy the book but not every person has the same idea of a fun time. This is the reason why I present you with a bunch of links to articles which will give you very good info. Some of this you won’t be able to find in a book anyway.

The curse and blessings of dynamic SQL. How you use dynamic SQL, when you should - and when you should not.

Arrays and Lists in SQL Server. ...

The selectivity of an index is extremely important. If your index is not selective enough then the optimizer will simply have to do a scan. This is also a reason why creating an index on a gender column does not make a lot of sense.

First create this table