I just tried to completely remove partitioning from one of my very large tables and it wasn’t as easy as I thought it would. You just don’t simply drop the partitioning scheme/function. The linked article describes howto do it right.
Indexes and Constraints on a Partitioned Table
In a partitioned table, the partition column must be a part of:
- The clustered index key.
- The primary key.
- Unique index and uniqueness constraint keys.
Fill Factor 101
Did you ever wonder what the term “fill factor” in conjunction with SQL Server means and were eager to understand it better? The following two part article series explains what the fill factor is and how to choose the right fill factor for your database.
Interesting little trick to avoid table locks when updating a complete large table in SQL Server 2005 and higher.
SSIS 2008 Logging
I’m just trying to configure a custom logging mechanism for my SSIS packages and had some problems with the location and structure of the dbo.sysssislog table which is automagically created by the Integration Services (if you happen to use a integrated security database connection; else you need to grant CREATE rights to the corresponding database user). While googling I found some helpful tips by Joe The Business Intelligence Guy:
