Automating "Save DTS package"

MAK examines how to save all of the DTS packages from SQL Server to a structured storage file automatically.

Delete All

Delete all rows from all user tables. Create stored procedure and execute the procedure to get rid of all rows from all tables. This will not drop your tables. Be very careful what you wish for!

Tables With Identity Column

This script displays all tables in a database that has identity columns.

Optimized ADO.NET

This article contains guidelines compiled by examining the .NET implementations of shipping .NET applications and analyzing the common performance mistakes that we found. The guidelines discuss selecting .NET objects and methods, designing .NET applications, retrieving data, and updating data.

Lock Monitoring Script to summarize active locks

A simple script created to summarize locking by spid, by database, by type with more user friendly descriptions.  You can also run for a specific spid.  Hope it's useful. 

SQL Server 2000 Report Pack for Microsoft CRM

The SQL Server 2000 Report Pack for Microsoft CRM is a set of six Microsoft SQL Server 2000 Reporting Services reports that work with the Microsoft CRM 1.2 sample database.

With the Report Pack, you have the choice of using the sample reports either as-is or as templates for designing new reports using the SQL Server Reporting Services Report Designer.

Get Table Count without using COUNT

Returns the number of records within a table without having to perform COUNT.

Extending Microsoft SQL Server 2000 Reporting Services with Custom Cod

In this article, I will show you how to leverage the Reporting Services unique extensible architecture to supercharge your report capabilities. First, I will explain how embedded and custom code options work. Next, I will show you how you can leverage custom code to author an advanced report with sales forecasting features.

GetWeekNo

This will return the weekno of the given date

Count elapsed business days between two dates

This is a UDF that counts the days between two dates ignoring weekends and corporate holidays (as supplied in a lookup table). This ignores the time component but could be adjusted should you need to. If both days are on the same work day then the elapsed days is considered 1. If started Monday and […]