Monthly Archives: September 2015

  1. Updating a view

    2

    September 30, 2015 by Kenneth Fisher

    I was recently asked how to update views. Specifically the question was about using triggers to update a view. So …
    Continue reading

  2. SSMS Connection Information

    Leave a comment

    September 28, 2015 by Kenneth Fisher

    If you work with a number of different instances and have lots of connections open in Management Studio (SSMS) it …
    Continue reading

  3. “sql_handle” is not a recognized table hints option.

    Leave a comment

    September 23, 2015 by Kenneth Fisher

    I’ve you’ve run a query similar to the following: And gotten an error similar to: Msg 321, Level 15, State …
    Continue reading

  4. Zombie AD Groups

    4

    September 21, 2015 by Kenneth Fisher

    I spent something like 2 hours today trying to figure out how a particular user had access to one of …
    Continue reading

  5. Using @@ROWCOUNT can be a bit tricky

    2

    September 16, 2015 by Kenneth Fisher

    @@ROWCOUNT is a very useful system variable that returns the number of rows read/affected by the previous statement. It’s frequently …
    Continue reading

  6. What SQL Server components are installed on this machine?

    2

    September 14, 2015 by Kenneth Fisher

    Figuring out what components of SQL Server are installed on a particular machine has always been a task that has …
    Continue reading

  7. Finding the worst running query in a stored procedure

    14

    September 10, 2015 by Kenneth Fisher

    The other day I was asked to tune a stored procedure. Not exactly an uncommon task, but I worked something …
    Continue reading

  8. Where you should start when managing an enterprise

    Leave a comment

    September 8, 2015 by Kenneth Fisher

    This T-SQL Tuesday we are hosted by one of the DBA’s of the night: Jen McCown (b/t). She want’s us …
    Continue reading

  9. Learning Regular Expressions

    7

    September 2, 2015 by Kenneth Fisher

    I’m a regular watcher of the Midnight DBA Webshow and one day they mentioned regular expressions. Not a new term …
    Continue reading

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

Join 1,655 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013