Category Archives: Problem Resolution

  1. db_ddladmin and the SSMS table designer

    Leave a comment

    July 10, 2014 by Kenneth Fisher

    If you want to grant a user the ability to create/alter/delete any table, SP, function etc in a database you …
    Continue reading

  2. T-SQL Tuesday #56: Assumptions

    6

    July 8, 2014 by Kenneth Fisher

    I assume that since it’s the second Tuesday of the month that it’s time for T-SQL Tuesday. And you can …
    Continue reading

  3. Who has the DAC open?

    Leave a comment

    May 28, 2014 by Kenneth Fisher

    The other day I started seeing the following error in my SQL log. Error: 17810, Severity: 20, State: 2. Could …
    Continue reading

  4. Start with stupid

    1

    March 17, 2014 by Kenneth Fisher

    True story: I worked in a computer lab many years ago and one day this guy (a grad student) checked …
    Continue reading

  5. Check your SQL Agent history settings before it’s too late!

    3

    February 10, 2014 by Kenneth Fisher

    A little while back I was doing some research into a failed job and ran into a slight problem. The …
    Continue reading

  6. Negative session_ids

    2

    January 27, 2014 by Kenneth Fisher

    I probably had the most fun all week when a query I was running came up blocked. Sounds strange right? …
    Continue reading

  7. Transactions: Who, What and Where

    Leave a comment

    January 20, 2014 by Kenneth Fisher

    Recently we had a scenario where we had a handful of queries being blocked. Nothing unusual there but when I …
    Continue reading

  8. A pattern to do beginning of period calculations.

    Leave a comment

    November 20, 2013 by Kenneth Fisher

    Beginning of period calculations are common things. Rolling month reports, queries to pull everything from last month etc require beginning …
    Continue reading

  9. Query to compare indexes between two tables

    Leave a comment

    October 16, 2013 by Kenneth Fisher

    We have a set of databases at my office that use the load and swap method of loading data with …
    Continue reading

  10. Why you should know how to script as well as use the GUI

    Leave a comment

    October 14, 2013 by Kenneth Fisher

    Personally I’ve always enjoyed learning the T-SQL for any given task. The GUI is usually pretty easy to figure out …
    Continue reading

Follow

Get every new post delivered to your Inbox.

Join 290 other followers