Monthly Archives: August 2014

  1. Finding a job!

    3

    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!

    7

    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

    8

    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

    4

    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

    23

    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

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 2,134 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013