SQL Server Data Mining: Plug-In Algorithms

Describes how SQL Server 2005 Data Mining allows aggregation directly at the algorithm level. Although this restricts what the third-party algorithm developer can support in terms of language and data types, it frees the developer from having to implement data handling, parsing, meta data management, session, and rowset production code on top of the core data mining algorithm implementation.

usp_PartitionDatabase

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

Search SQL Error Log

Easiest way for searching inside one or all SQL Server Error Logs

Importing settings from one SQL Server 2005 instance to another

Custom Pagination in SQL Server 2005

Building paging routines in SQL Server can be challenging since SQL wants to deal with full result sets. Adam Haines brings us a technique that you can use in SQL Server 2005 with the new Row_Number function.

SQL Server 2005 SP3 Has Been Released

SP3 is released

Default trace - A Beginner's Guide

This article is the beginner's guide to Default Trace. The article outlines how to query the default trace for key trace events, with a focus on DDL history.

Finding all data types in user tables

A quick way to get a snapshot of what data types are being used in all user tables.

Reindex all indexes online or offline depending on day of week.

This script will reindex (online) any index eligible to be reindexed online. Accepts a day of week parameter for full offline reindexing.

Getting schemas for your tables

A short script you can incorporate into any 2005/2008 code to get the full schema.table.