Microsoft SQL Server ARTICLES

ASP Faq - How to Get the number of rows in a table, or all tables

ASP Faq - How to Return row numbers with my query

ASP Faq - How to Separate DATE and TIME

ASP Faq - How to Time T-SQL code

ASP Faq - How to Write SQL query that turns rows into columns

Database Journal - Case Statement in Updates

Database Journal - Case Statement Tricks

Dinesh.T.K, SQL Server MVP - How to Find the execution time of a Stored Procedure

Dinesh.T.K, SQL Server MVP - How to Check if a temp table exists already

Dinesh.T.K, SQL Server MVP - How to Manually insert a IDENTITY value

Dinesh.T.K, SQL Server MVP - How to Separate the current DATE without the TIME

Dinesh.T.K, SQL Server MVP - How to Reset-clear a IDENTITY value

Dinesh.T.K, SQL Server MVP - How to Do a SELECTS inside a CASE expression

Erland Sommarskog, SQL Server MVP - Article - Arrays and Lists in SQL Server

Erland Sommarskog, SQL Server MVP - Dynamic Search Conditions in T-SQL

Erland Sommarskog, SQL Server MVP - Dynamic SQL Course

Erland Sommarskog, SQL Server MVP - Handling Errors in SQL Server - Background

Erland Sommarskog, SQL Server MVP - Handling Errors in SQL Server - Implementing in SP

Erland Sommarskog, SQL Server MVP - How to Share data between Stored Procedures

Microsoft - Brief Tutorial on Text, Ntext, and Image

Microsoft - How to Dynamically number rows in a SELECT

Microsoft - How to Remove Duplicate Rows From a Table

Microsoft - How to Using BLOBs

Microsoft - Tips and Tricks Center (MS)

Microsoft - Automating Administrative Tasks

Microsoft - DBCC CHECKDB Recommendations (Troubleshooting SQL Server)

Microsoft - Discover resources to help you administer SQL Server.

Microsoft - Fundamentals of SQL Server 2000 Architecture

Microsoft - HOW TO: Determine Proper SQL Server Configuration Settings

Microsoft - Identifying Common Administrative Issues for Microsoft SQL Server 2000 (Microsoft SQL Server 2000 Technical Articles)

Microsoft - Integrating Word, Excel, and InfoPath with SQL Server 2000

Microsoft - SQL Server 2000 Administration Guide

Microsoft - Upgrading from Earlier Versions

MS SQL City - Article - Optimization tips for designing tables

MS SQL City - Tips and Tricks (SQL City)

MS SQL City - Undocumented eXtended Stored Procedures

MS SQL City - Undocumented Stored Procedures

MS SQL City - Useful UDF for SQL Server 2000

MS SQL City - User-Defined DateTime Functions

MS SQL City - User-Defined Mathematical Functions

MS SQL City - User-Defined String Functions

Narayana Vyas Kondreddi, SQL Server MVP - How to Search and Replace data in all columns of all tables

SQL Magazine - Top 11 Backup Tips

SQL Server Central - How to Use Xp_cmdshell

SQL Team - Handling Errors in Stored Procedures

SQL XML - How to Create a tree view type of menu in XML