Automate Range Right Partition Management with PowerShell

This script automatically splits a partitioned table, merges the partition function and then drops the associated file group for the partition.

Cube Storage: Planning Partitions from a SQL Server Management Studio Perspective

BI Architect Bill Pearson continues his discussion of Partition planning for Analysis Services, this time focusing on the settings and properties involved from a SQL Server Management Studio perspective.

Partition SWITCH

Partitioning in SQL Server 2008

This article discusses about 'Partitioning'. In this detailed article, a particular emphasis is placed on the implementation of Partitioning in SQL Server.

usp_PartitionDatabase

Given some input parameters, it generates the filegroups, files, partition function and partition scheme sql statements.

Table Partitioning in SQL Server 2005

Sample script for Table Partition

RE: Obtaining error message information in alerts and jobs

This is great! Just what I was looking for! Thanks guys. It worked like a charm.

RE: Data Driven Architecture

Actually the first .ZIP file you posted was created correctly.  However, either your virus scanning software or a firewall is stripping out the .VB files (from 6_WARNING.HTM) ----------------------------------------------------------------------------- BLOCKED FILE ALERT A file has been blocked due to the 'Dangerous Attachment Block' rule. See your system administrator for further information. Context: 'ASSEMBLYINFO.VB' Disallowed due to filenameOUHSC PostmasterCopyright © […]

Scrolling thru a large table to latest entry

Is there a simple way of going directly to the last line of a table, other than using the right hand scroll bar?yes   there is   two waysright click on any line and select 'last'  or..ctrl + end  

RE: Get Previous Date

If you read closer, you'll notice that the conversion is on the parameter side, not the column itself - so indices will likely get used. It's the other way around that's the 'bad' way. And, any function may have the effect to invalidate index usage - it's not limited to convert only in any way.For […]