Monthly Archives: June 2016

  1. Finding, disabling and enabling foreign keys

    3

    June 29, 2016 by Kenneth Fisher

    Foreign keys are a classic method of enforcing RI (Referential Integrity). Unfortunately though, they can get in the way if …
    Continue reading

  2. Perfectly Placed Parentheses

    14

    June 27, 2016 by Kenneth Fisher

    Like many other programming languages T-SQL uses parentheses () for a number of tasks. To help determine precedence, function calls …
    Continue reading

  3. Database snapshots

    4

    June 22, 2016 by Kenneth Fisher

    This feature is Enterprise only which can limit who it is useful to, but I find the whole concept fascinating. …
    Continue reading

  4. Minimizing Cloud cost

    9

    June 20, 2016 by Kenneth Fisher

    The cloud can be expensive. I had this hammered home the other day by a simple mistake. I’m currently working …
    Continue reading

  5. Help! My backup file has doubled in size.

    2

    June 16, 2016 by Kenneth Fisher

    Help! I backed up my database yesterday and the backup file was about 200MB but today it’s closer to 400! …
    Continue reading

  6. Comparing two query plans

    3

    June 14, 2016 by Kenneth Fisher

    This month my friend Michael J Swart(b/t) would like us to talk about the new 2016 version of SQL Server. …
    Continue reading

  7. Comparing the contents of two tables Redux

    Leave a comment

    June 8, 2016 by Kenneth Fisher

    I did a post the other day on comparing two tables. It was meant as a general overview but I …
    Continue reading

  8. I need help with DBCC

    2

    June 6, 2016 by Kenneth Fisher

    Many years ago during an interview I was asked to “Name the top 7 DBCC commands that you use.” I …
    Continue reading

  9. Using LEN wrong.

    4

    June 2, 2016 by Kenneth Fisher

    I was reading someone’s question the other day on StackExchange and while the existing comments/questions solved the OP’s (original poster) …
    Continue reading

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

Join 6,758 other subscribers

Follow me on Twitter

Archives

ToadWorld Pro of the Month November 2013