Store Procedure Output in a Table

This script show a demonstration of how to interst tore Procedure Output in a Table.

Back to front

Temp Tables

Find weak login passwords in your server

Use this script to search for SQL Server logins who use weak password

Fun with Decimals

INT and SMALLINT

SELECT @local_variable

How long is a NULL?

Comparing cursor vs. WHILE loop performance in SQL Server 2008

There are situations in which you need to individually handle each row in a result set. SQL Server 2008 provides a minimal set of tools — cursors and WHILE loops — to accomplish this task. I'll take a closer look at each option and explain why it's difficult to pinpoint which is better in terms of performance.

Query Active Directory Data from SQL Server using T-SQL

Learn how to use SQL Server Transact SQL with OPENROWSET and OPENQUERY commands to access and retrieve data from Active Directory.