1. Exploring system tables, views, SPs etc

    Leave a comment

    April 18, 2018 by Kenneth Fisher

    I wanted to spend a few minutes highlighting a couple of important tools for figuring out what information you have …
    Continue reading

  2. I’ve gotten a transaction log full error but when I look it’s not full??

    2

    April 16, 2018 by Kenneth Fisher

    Every now and again I’ll get an error telling me a transaction log is full. This can be for any …
    Continue reading

  3. Deleting a lot of data

    5

    April 12, 2018 by Kenneth Fisher

    I recently had the task of deleting a bit over a billion rows from a table. Now I could have …
    Continue reading

  4. Exploring permissions with sp_DBPermissions and sp_SrvPermissions : TSQL Tuesday 101

    1

    April 10, 2018 by Kenneth Fisher

    Our host for T-SQL Tuesday this month is Jens Vestergaard (b/t) and he has asked about our favorite SSMS tool. …
    Continue reading

  5. SSMS’s Dark Theme

    3

    April 4, 2018 by Kenneth Fisher

    There has been talk of a dark theme for SSMS for years. Does it exist, will it exist? Well, the …
    Continue reading

  6. SQL Homework – April 2018 – Indexes

    Leave a comment

    April 2, 2018 by Kenneth Fisher

    This month we are going to look at a topic near and dear to both database developers and database administrators …
    Continue reading

  7. 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

  8. 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

  9. Moving a table using BCP and native format

    3

    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

  10. 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

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

Join 2,176 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013