1. The clustered index columns are in all of the non clustered indexes.

    2

    July 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

  2. What is ANSI_NULLS and why will I be glad when it finally goes away?

    Leave a comment

    July 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

  3. Why am I getting a primary/unique key violation?

    3

    July 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

  4. Add them to ALL the roles!

    3

    July 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

  5. Yes, Virginia, you can have too much white space.

    20

    July 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

  6. What does it mean that a value is NULL?

    9

    July 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

  7. db_ddladmin and the SSMS table designer

    Leave a comment

    July 10, 2014 by Kenneth Fisher

    If you want to grant a user the ability to create/alter/delete any table, SP, function etc in a database you …
    Continue reading

  8. T-SQL Tuesday #56: Assumptions

    6

    July 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

  9. Argenis and the unicorn hoodie

    Leave a comment

    July 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

  10. Make BOL your friend

    Leave a comment

    June 30, 2014 by Kenneth Fisher

    One of the most powerful tools we have as users of SQL Server is Books Online (BOL).  Whether you work …
    Continue reading

Follow

Get every new post delivered to your Inbox.

Join 305 other followers