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 […]

Last_Date_Of_Month

Get the Last date of the month for the given month and year

Return the Count of Weekday in a period

Two Method for Return the Count of Weekday between two date!

SQL Server: Blocking Problems

This article focuses on a common problem associated with conflicting locks: blocking. When blocking occurs, a single connection blocks all other connections from reading or modifying a particular piece of data. Learn here how to resolve these issues.