Category Archives: SQLServerPedia Syndication

  1. Updating a view

    Leave a comment

    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


    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


    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?


    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


    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


    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

  10. The default instance has a name


    August 31, 2015 by Kenneth Fisher

    The default instance actually has an instance name. It’s MSSQLSERVER. This is probably familiar to a lot of you but …
    Continue reading


Get every new post delivered to your Inbox.

Join 806 other followers