Monthly Archives: May 2017

  1. SQL Crossword

    7

    May 31, 2017 by Kenneth Fisher

    I thought I’d do another crossword. Enjoy! If you need any help with it feel free to let me know …
    Continue reading

  2. Running multiple queries at the same time.

    8

    May 24, 2017 by Kenneth Fisher

    I read an interesting question today. Someone wanted to be able to run the same stored procedure multiple times, at …
    Continue reading

  3. What’s in a partition?

    Leave a comment

    May 22, 2017 by Kenneth Fisher

    In my last post on partitioning I used the $Partition command in passing. I’ve been thinking it deserves a bit …
    Continue reading

  4. T-SQL FizzBuzz

    15

    May 17, 2017 by Kenneth Fisher

    I was looking around for something to write about this evening and came across one of Russ Thomas’ (b/t) old …
    Continue reading

  5. Why shouldn’t I shrink my database log file?

    1

    May 15, 2017 by Kenneth Fisher

    TL;DR: It’s pretty pointless and can cause performance issues. Let’s start by asking why you might want to shrink your …
    Continue reading

  6. Dynamic SQL and the joys of QUOTENAME

    5

    May 11, 2017 by Kenneth Fisher

    I’m a big fan of dynamic SQL. In the past I’ve written a How to, a Best Practices and even …
    Continue reading

  7. Continuous Integration

    Leave a comment

    May 9, 2017 by Kenneth Fisher

    It’s T-SQL Tuesday again! This month we are being hosted by James Anderson (b/t). Thanks James! He has asked us …
    Continue reading

  8. Partitioning on a nullable column

    3

    May 3, 2017 by Kenneth Fisher

    tl;dr; If you are SWITCHing data into a table and the partitioning column is nullable you will need to add …
    Continue reading

  9. Simple Security Report

    2

    May 1, 2017 by Kenneth Fisher

    Quite a while ago I created a couple of little security scripts to help me out with permissions research. Over …
    Continue reading

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

Join 1,664 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013