Tags » Microsoft SQL Server

Playing with the log - VLF order while growing the log

The log file is one of those parts of SQL Server I find fascinating. For instance it is composed of VLFs (virtual log files). These VLFs are a logical way for SQL to break the physical file down into smaller pieces. 536 more words

Microsoft SQL Server

'Twas 4:45 Friday

‘Twas 4:45 Friday, and all through the office
not a creature was stirring, not even the bosses.
The code was checked in, into Tortoise with care, 395 more words

Microsoft SQL Server

Does a clustered index sort the rows within a page

This is just something I was curious about. I ran my tests and got an answer and now I thought I would share.

Before I start I want to point out a few things about my tests. 1,290 more words

Microsoft SQL Server

Starting a new blog

In the last months, I made a decision to launch a new blog in my own domain and hosted WordPress. I needed more flexibility over installed plugins and more content control. 31 more words

Microsoft SQL Server

DROP INDEX and CREATE INDEX vs ALTER INDEX REBUILD

I saw someone ask a few weeks ago if it was faster to drop and re-create an index or do an ALTER INDEX REBUILD. I’m not sure, although I suspect they will take about the same amount of time. 1,081 more words

Microsoft SQL Server

SQL Saturday #354 - Charleston, SC is almost here!

If you are relatively near to Charleston, SC, there’s a SQL Saturday there this weekend, December 13th!

SQL Saturday #354 – Charleston, SC

Looking at the… 83 more words

Syndicated

TSQL Tuesday #61: Giving Back, you gain more than you give.

Almost four months ago I posted my goals for the next year in my two year anniversary post. I pretty much decided I was going to continue on the same way I’d been going. 606 more words

Microsoft SQL Server