Monthly Archives: March 2016

  1. When should I test?

    1

    March 30, 2016 by Kenneth Fisher

    To test or not to test. That is the question. Or is it? Shouldn’t we always test? That was the …
    Continue reading

  2. Why you shouldn’t use SELECT *

    1

    March 28, 2016 by Kenneth Fisher

    I answered an interesting question on SE today (ever notice how many posts come from stuff I read on forums?) …
    Continue reading

  3. I’m presenting for the Pass Security Virtual Chapter!

    1

    March 23, 2016 by Kenneth Fisher

    Tomorrow (3/24/2016) at noon CT I’ll be presenting my SQL Server Security Basics session for the Pass Security Virtual Chapter. …
    Continue reading

  4. TOP 1 killed my performance; Rob Farley helped me resurrect it.

    15

    March 21, 2016 by Kenneth Fisher

    tl;dr; There is no short version of this. It’s LONG. It’s interesting but you might want to skip it if …
    Continue reading

  5. What permissions do I need?

    Leave a comment

    March 16, 2016 by Kenneth Fisher

    Ever wondered how to tell what permissions are required to run a statement or perform a task? Well, sometimes it …
    Continue reading

  6. Pulling data from a non-clustered index

    1

    March 14, 2016 by Kenneth Fisher

    This is one of those things that I found very interesting but figured I’d probably never really use. Of course …
    Continue reading

  7. You don’t need to be a sysadmin

    18

    March 10, 2016 by Kenneth Fisher

    Hey, I need sysadmin access to ServerA. Ok. Why do you need sysadmin? Well I need to be able to …
    Continue reading

  8. Ever wonder what that goofy query in the header means?

    4

    March 8, 2016 by Kenneth Fisher

    It’s T-SQL Tuesday time again (Number 76!) and this month we are hosted by Bob Pusateri (b/t) who has invited …
    Continue reading

  9. How do I grant someone the ability to create a stored procedure?

    1

    March 2, 2016 by Kenneth Fisher

    The question of How to grant the ability to create/alter stored procedures and views came up today on dba.stackexchange.com. It’s …
    Continue reading

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

Join 2,151 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013