Category Archives: Microsoft SQL Server

  1. Finding a job!

    Leave a comment

    August 27, 2014 by Kenneth Fisher

    I’ve been told over the years that I’m pretty good at finding jobs. I mean in the last 25 years …
    Continue reading

  2. The amazing never shrinking heap

    Leave a comment

    August 25, 2014 by Kenneth Fisher

    This is a quick demo of a little “trick” with heaps I’ve known about for a couple of years. However …
    Continue reading

  3. Two years!

    6

    August 20, 2014 by Kenneth Fisher

    Two years ago today I began my blog with a post about the DEFAULT keyword. I set out with the …
    Continue reading

  4. Generating a restore script

    3

    August 18, 2014 by Kenneth Fisher

    In order to speed up our backups on a large database our team decided to stripe the backup files. In …
    Continue reading

  5. More than sp_help

    1

    August 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

  6. T-SQL Tuesday #57: SQL Family

    1

    August 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

  7. SchemaBinding – What & Why

    5

    August 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

  8. Deny vs Revoke

    1

    August 4, 2014 by Kenneth Fisher

    Quick quiz. Which of these two commands is the opposite of GRANT? DENY REVOKE   Well lets start with some …
    Continue reading

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

    9

    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

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

    9

    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

Follow

Get every new post delivered to your Inbox.

Join 338 other followers