Little info about Resouce DB (SQL Server 2008-2005)

Little info about System Resource Database in (SQL Server 2008/2005)

The fifth system database in both versions (SQL Server 2008 - 2005)...

SSIS - Single Package Deployment from BIDs

I have read several articles about deploying SSIS packages.Most focus on using the deployment wizard or simply copying the files...

MySpace Using SSDs

Glenn Barry (blog, twitter) posted a note about MySpace using Fusion-IO PCi-E cards to replace hard drives in their systems....

String Manipulation - CHARINDEX()

I see charindex used quite commonly in string manipulation.  What I rarely see used is the optional third parameter.  Here...

Holidays and Parties, Gift, Expectations, and Wishes

Most companies do something at the holidays, although it seems to be less with each year, and certainly this holiday...

Yes, Table Variables and Temp Tables both use the tempdb

Pinal Dave recently wrote a blog post called SQL SERVER – Difference TempTable and Table Variable – TempTable in Memory a Myth...

Tally Table - Character Date Validation

Tally (or numbers) tables are one of my favorite query writing tools.  Such a simple premise that can be applied...

Perform a Striped Backup

The size of databases have been growing in such a way, it sometimes is hard to have a single drive / tape to...

Fundamentals of Storage Systems – RAID, An Introduction

In previous articles, we have covered the system bus, host bus adapters, and disk drives. Now we will move up...

Fundamentals of Storage Systems – Disk Controllers, Host Bus Adapters, and Interfaces

We have covered the Hard Disk and the System Bus. This time around we will cover disk controllers and host...