Monthly Archives: July 2014
-
The clustered index columns are in all of the non clustered indexes.
13July 30, 2014 by Kenneth Fisher
Did you know that whatever columns you pick as your clustered index will be included in any non clustered indexes …
Continue reading -
What is ANSI_NULLS and why will I be glad when it finally goes away?
13July 28, 2014 by Kenneth Fisher
Recently I wrote about what it means that a value is NULL. Right at the beginning I mentioned ANSI_NULLS and …
Continue reading -
Why am I getting a primary/unique key violation?
3July 23, 2014 by Kenneth Fisher
This may seem like a question with a simple answer but there is a bit more to it than you …
Continue reading -
Add them to ALL the roles!
3July 21, 2014 by Kenneth Fisher
I seem to get a lot of permissions questions these days and one of the more frequent ones goes along …
Continue reading -
Yes, Virginia, you can have too much white space.
22July 16, 2014 by Kenneth Fisher
When I was in college and taking programming classes (back in the days when “a T-Rex ate my 5.25 inch …
Continue reading -
What does it mean that a value is NULL?
11July 14, 2014 by Kenneth Fisher
Let’s start by assuming that ANSI_NULLS are ON. If you aren’t sure what ANSI_NULLS are exactly, don’t worry, I’ll be …
Continue reading -
T-SQL Tuesday #56: Assumptions
6July 8, 2014 by Kenneth Fisher
I assume that since it’s the second Tuesday of the month that it’s time for T-SQL Tuesday. And you can …
Continue reading -
Argenis and the unicorn hoodie
1July 2, 2014 by Kenneth Fisher
Early yesterday Kirsten Benzel(b/t) announced something very exciting, at least exciting to me. Argenis Fernandez(b/t) has agreed to wear a …
Continue reading
SQL Studies 