-
More than sp_help
6August 14, 2014 by Kenneth Fisher
If you have worked with SQL Server for very long you have probably run across the extremely useful system function …
Continue reading -
T-SQL Tuesday #57: SQL Family
1August 12, 2014 by Kenneth Fisher
This month’s T-SQL Tuesday topic is SQL Family and is brought to us by Jeffrey Verheul (b/t). It’s an amazing …
Continue reading -
SchemaBinding – What & Why
29August 6, 2014 by Kenneth Fisher
What When you use the SchemaBinding keyword while creating a view or function you bind the structure of any underlying …
Continue reading -
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
SQL Studies
Live, Learn, Share
SQL Studies 