Monthly Archives: March 2018

  1. What’s the difference between Files and Filegroups?

    Leave a comment

    March 28, 2018 by Kenneth Fisher

    tl;dr; Filegroups are a logical construct used to separate tables and indexes from each other, files are the physical construct …
    Continue reading

  2. Introducing The Blame Game

    4

    March 26, 2018 by Kenneth Fisher

    Introducing the Blame Game! Someone has messed up the new anatomy application’s (Mr. Body) performance and no one is willing …
    Continue reading

  3. Moving a table using BCP and native format

    7

    March 21, 2018 by Kenneth Fisher

    You need to move a table from one instance to another with the following requirements: The instances are on separate …
    Continue reading

  4. GDPR – After the restore

    1

    March 19, 2018 by Kenneth Fisher

    I joined in on an interesting conversation the other day on twitter. It was about some unusual ramifications of GDPR …
    Continue reading

  5. DB_NAME() vs ORIGINAL_DB_NAME()

    1

    March 15, 2018 by Kenneth Fisher

    I’d never seen ORIGINAL_DB_NAME until recently and I thought it would be interesting to highlight it out, and in particular …
    Continue reading

  6. A look back from the future. – TSQL Tuesday #100

    3

    March 13, 2018 by Kenneth Fisher

    The date is July 14th, 2026 and it’s TSQL Tuesday #200. We are still using SQL Server, and in fact …
    Continue reading

  7. Simply Debugging

    3

    March 7, 2018 by Kenneth Fisher

    Debugging is a life skill. Yes, the term comes from IT (literally removing a bug from a computer believe it …
    Continue reading

  8. SQL Homework – March 2018 – Recovery Objectives

    Leave a comment

    March 5, 2018 by Kenneth Fisher

    My very first SQL Homework post was about taking a backup. The vast majority of people who work with databases …
    Continue reading

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

Join 2,469 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013