Monthly Archives: September 2015
-
Updating a view
2September 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 -
SSMS Connection Information
Leave a commentSeptember 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 -
“sql_handle” is not a recognized table hints option.
Leave a commentSeptember 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 -
Using @@ROWCOUNT can be a bit tricky
3September 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 -
What SQL Server components are installed on this machine?
2September 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 -
Finding the worst running query in a stored procedure
14September 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 -
Where you should start when managing an enterprise
Leave a commentSeptember 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 -
Learning Regular Expressions
7September 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