January 2008 - Posts
Finishing up the posts on table partitioning here, we will be looking at maintenance activities today. Two of the main areas of maintenance for your database have to do with indexes and backups. Partitioning helps shorten potential maintenance
Read More...
Last time we looked at the building blocks for a partitioned table in SQL Server 2005. I decided to break out maintenance activities for the next post. Today we will be discussing the various functions and management views available
Read More...
I'm going to spend the next few posts discussing how you can implement partitioning in SQL Server 2005 to improve the performance and maintenance time of very large tables. In previous versions of SQL Server it was possible to partition data by physically
Read More...
I've had a couple conversations about this subject this week so I thought I would post on this topic. There are occasions where we need the output of a dynamic query placed into a variable for later use. Today we will look at the stored procedure
Read More...