Category Archives: SQLServerPedia Syndication
-
“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 -
The default instance has a name
11August 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 -
The 30 minute rule
9August 26, 2015 by Kenneth Fisher
In one of my first IT jobs (back in the dark ages) we had something called the thirty minute rule. …
Continue reading -
The tail of the log
Leave a commentAugust 24, 2015 by Kenneth Fisher
A little while back I was feeling overwhelmed by the number of blog posts ideas that I had so I …
Continue reading
SQL Studies 