Monthly Archives: December 2014
-
2014 in review
Leave a commentDecember 30, 2014 by Kenneth Fisher
The WordPress.com stats helper monkeys prepared a 2014 annual report for this blog. Here’s an excerpt: The Louvre Museum has …
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 -
INSERT INTO SELECT vs SELECT INTO
5December 3, 2014 by Kenneth Fisher
INSERT INTO SELECT and SELECT INTO may be very similar commands but they have some important differences. Every now and …
Continue reading -
Using a date or int column as the clustered index.
13December 1, 2014 by Kenneth Fisher
The other day I was answering a question about clustered indexes and it lead indirectly to a twitter conversation on …
Continue reading
SQL Studies 