Non use of persisted data – Part deux

In my last blog I showed how persisted data may not be used if you have used the base data...

Difference between Checkpoint and LazyWriter

Was thinking about to write this blog for quite some time. CheckPoint Lazy Writer 1. Flush dirty pages to Disk...

Difference between Checkpoint and LazyWritter

Was thinking about to write this blog for quite some time. CheckPoint Lazy Writer 1. Flush dirty pages to Disk...

Code Snippet for an SSIS DataFlow Performance Wiretap

I was recently tweaking a few Data Flows, and settled on a very small, but very useful script to help...

Table Backups and the TableArchive Database

A discussion of how a separate database is used for storing table backups.
In a recent article, one of the things...

Presenting Two Sessions at PASS Summit 2011

I found out earlier this week that I was fortunate enough to have my half day session on “Scaling SQL...

Ice Cubes and Top SQL Rally Speakers

That title may evoke thoughts of inappropriate SQL Karaoke or perhaps not but It is so nice to know I’m...

SSAS Maestro - Redmond Recap

Well today was the last day for a while I would be greeted by this sign:

It was a pretty exciting...

Prevent SQL Logins from using SSMS … or any other app

In a continuation of my previous LOGON TRIGGER post.
A downside to SQL logins is that anyone with the username / password...

Altering Table structure - SSMS - Timeout Expired

Altering a table using SQL Server Management Studio ( SSMS ) can be done by right clicking on the table and by...