Tag Archives: microsoft sql server
-
TSQL Tuesday #62: Invitation to Healthy SQL – Why Page Verify?
1January 13, 2015 by Kenneth Fisher
I don’t think anyone’s ever been happy to get a support call at 11pm on a Saturday night. However this …
Continue reading -
SQL Judo’s Monthly Challenge – January 2014 – Restore the Master
5January 5, 2015 by Kenneth Fisher
Every month SQL Judo (Russ Thomas) (b/t) challenges us to do his Monthly DBA Challenge. I’ve decided it would be …
Continue reading -
Finding a common AD group for a set of users.
9December 29, 2014 by Kenneth Fisher
I work for a large organization that over the last few years has been doing a LOT of reorgs. And …
Continue reading -
Do you want to build an Audit?
1December 29, 2014 by Kenneth Fisher
So I’ve written my second article for SQL Shack. This time instead of an overview of auditing options in sql …
Continue reading -
Playing with the log – VLF order while growing the log
1December 17, 2014 by Kenneth Fisher
The log file is one of those parts of SQL Server I find fascinating. For instance it is composed of …
Continue reading -
‘Twas 4:45 Friday
3December 16, 2014 by Kenneth Fisher
‘Twas 4:45 Friday, and all through the office not a creature was stirring, not even the bosses. The code was …
Continue reading -
Does a clustered index sort the rows within a page
Leave a commentDecember 15, 2014 by Kenneth Fisher
This is just something I was curious about. I ran my tests and got an answer and now I thought …
Continue reading -
DROP INDEX and CREATE INDEX vs ALTER INDEX REBUILD
6December 11, 2014 by Kenneth Fisher
I saw someone ask a few weeks ago if it was faster to drop and re-create an index or do …
Continue reading -
TSQL Tuesday #61: Giving Back, you gain more than you give.
Leave a commentDecember 9, 2014 by Kenneth Fisher
Almost four months ago I posted my goals for the next year in my two year anniversary post. I pretty …
Continue reading
SQL Studies 