Common Solutions for T-SQL Problems

Information presented in this WIKI represents the suggestions, ideas, and opinions of Volunteer Moderators and Answerers who support the Microsoft MSDN SQL Server Forums. (Unless specifically stated otherwise, nothing should be construed to represent the official positions or opinions of Microsoft and/or its Employees.)

Please direct any additional Questions to the MSDN SQL Server Related Forums
-----------------------------------------------------------------------------------------------------------------------------------------------------------------
How can I Prepare My Question to Increase the Possibility of Getting a Good Solution?
What are the Rules of Conduct expected on the Forums?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------

How To Examples of Selected T-SQL Programming Constructs

Data Related Queries
Alternatives To SQL Server Cursors
Audit or Bypass Trigger Execution
Control Return Results by Range
Create a Comma Delimited List from a Column in a Table
Create and Use A Numbers Table
Delete All Data From All User Tables In A Database
Exploring Recursive Common Table Expressions (CTE)
Find and/or Delete Duplicate Rows in a Table
Find First Available Timeslot for Scheduling
Find Rows of Data Between Two Dates
Find the Missing Parts of a List of Requirements
Implementation of DDL Trigger in SQL Server 2005
Increment an AlphaNumeric Value
ISNULL() vs. COALESCE()
Lock a Stored Procedure for Single Use Only
Pass and Handle a Delimited String similar to handling an Array() of Values
PIVOT Data Using T-SQL
Queries Based Upon The Absence of Data
Rank Values in Groups
Search all or partial columns without Dynamic SQL while avoiding SQL Injection
Search all or partial columns with Dynamic SQL while avoiding SQL Injection
SELECT TOP n by Group
UNPIVOT Data Using T-SQL

Maintenance Queries
Automate Backups in SQL Express
Detach All User Databases
Find Last BackUp Date Of All Databases On Your Server
Find Long Running Agent Jobs
Find the TOP n Longest Running Procedures (or Queries), Ordered by Total Impact on Server
Performing Common Maintenance Tasks in SQL Express
Transfer Logins to Another Server
Last Ran clean DBCC CHECKDB for all databases

Best Practices and Guidelines
Best practices , Design and Development guidelines for Microsoft SQL Server

SQL Server Maintenance
Automating Common DBA Tasks
Configuring SQL Server 2000 Notification with CDOSys
Configuring SQL Server 2005/2008 Database Mail
Log file growth in SQL Server
Monitor free space in the database files
Monitor free space on the server hard disks
Monitor the SQL Server Error Log
Monitor long running SQL Agent Jobs
Monitor failed SQL Agent Jobs
Monitor Service Status
Monitor System Event Logs
Monitor Running Process Information
Transfer Jobs and Logins using SSIS
Upgrading Steps to SQL Server 2005

SQL Server 2008
Manage unstructured data using FILESTREAM Feature in SQL Server 2008

-----------------------------------------------------------------------------------------------------------------------------------------------------------------

How To Troubleshoot and Debug T-SQL Code

Troubleshoot Deadlocking in SQL Server.
Troubleshoot Deadlocking in SQL Server 2005 using Profiler.
Understanding the Anatomy of a Deadlock.
Using the SQL Server Profiler.

-----------------------------------------------------------------------------------------------------------------------------------------------------------------

Writing Transact-SQL Statements Tutorial

http://msdn2.microsoft.com/en-us/library/ms365303.aspx
___________________________________________________________________________________________________________________
Page Created By: Arnie Rowland, Mar 12, 2008