Bill Graziano

Bill Graziano is a Kansas City-based SQL Server consultant. He provides performance tuning and part-time DBA services. Bill is a SQL Server MVP and serves on the Board of Directors of The Professional Association for SQL Server (PASS). He is a regular presenter on SQL Server topics at conferences and user groups. He is a founder of SQLTeam.com, a web site for SQL Server professionals and has taught classes in SQL Server, Visual Basic, MSF and Windows Server. Bill also maintains a SQL Server blog.

Articles

Fast CSV Import in PowerShell to SQL Server (18 March 2014)

Using Dynamic SQL in Stored Procedures (7 March 2011)

Handling SQL Server Errors (5 April 2010)

Using REPLACE in an UPDATE statement (31 March 2010)

SQL Server Version (29 January 2009)

SQLTeam.com Reader Survey (6 August 2008)

PASS Summit 2008 Speaker List (25 June 2008)

ApexSQL Giving Away 25 Copies of Enforce (7 May 2008)

Using the TIME data type in SQL Server 2008 (6 March 2008)

See Kalen Delaney's SQL Server Seminar in Kansas City (9 January 2008)

Using the DATE data type in SQL Server 2008 (6 December 2007)

SQL Server Connection Strings (14 November 2007)

Moving the tempdb database (5 November 2007)

Win Free Software in our Forum Contest (31 October 2007)

What I Wish Developers Knew About SQL Server (Presentation) (11 October 2007)

Speaking in Jacksonville and Orlando on October 8th & 9th, 2007 (4 October 2007)

Top 10 SQL Server Blogs at Microsoft (26 September 2007)

Avoid enclosing Indexed Columns in a Function in the WHERE clause (12 September 2007)

Introduction to Parameterization in SQL Server (7 August 2007)

How to Insert Values into an Identity Column in SQL Server (6 August 2007)

SQL Server 2008 July CTP (1 August 2007)

What Query Plans are in SQL Server's Memory? (25 July 2007)

SQL Saturday 2007 - Free Orlando SQL Server Event in November (25 July 2007)

What Data is in SQL Server's Memory? (23 July 2007)

PASS Board Elections for 2007 (18 July 2007)

PASS Schedule is Available (10 July 2007)

SQL Server 2008 to Launch February 27th, 2008 (10 July 2007)

Welcome to the new SQLTeam.com (11 June 2007)

Microsoft announces SQL Server 2008 (4 June 2007)

Register for PASS 2007 (29 May 2007)

Passing an array of values to SQL Server (Stored Procedure) without parsing/string manipulation (26 March 2007)

Use SQLIOSIM to simulate SQL Server disk activity (8 March 2007)

SQL Server Express 2005 Tips and Tricks Presentation (6 March 2007)

Microsoft Releases Updated SQL Server 2005 SP2 (6 March 2007)

How to prepare SQL Server 2005 and SQL Server 2000 for changes to daylight saving time in 2007 (5 March 2007)

Notes from an Upgrade to SQL Server 2005 (26 February 2007)

SQL Server 2005 Express Tips and Tricks Web Cast (26 February 2007)

SQL Server 2005 SP2 Available (19 February 2007)

BACKUP and RESTORE in SQL Server -- Full Backups (12 February 2007)

PASS 2007 Call for Speakers Open (5 February 2007)

Using Indexed Computed Columns to Improve Performance (16 January 2007)

Server Side Paging using SQL Server 2005 (4 January 2007)

PASS 2006 Presentation: What I Wish Developers Knew About SQL Server 2005 (15 December 2006)

SQL Server 2005 Best Practices on TechNet (4 December 2006)

SQL Server 2005 Service Pack 2 CTP is Available (8 November 2006)

How SQL Server 2005 Enables Service-Oriented Database Architectures (8 September 2006)

Common Table Expressions (15 August 2006)

Using the OUTPUT Clause to Capture Identity Values on Multi-Row Inserts (14 August 2006)

MSDN Webcast: What I Wish Developers Knew About Writing Applications for SQL Server 2005 (14 July 2006)

MSDN Webcast: What I Wish Developers Knew About Writing Queries in SQL Server 2005 (July 2006) (10 July 2006)

SQL Server Storage Engine Team Blog (7 June 2006)

Visual Studio 2005 Team Edition for Database Professionals (5 June 2006)

Examining SQL Server Trace Files (15 May 2006)

Using XQuery, New Large DataTypes, and More (9 May 2006)

SQL Server 2005 SP1 (19 April 2006)

Summarizing SQL Server Trace Files (or Read80Trace for SQL Server 2005) (10 April 2006)

Free online SQL Formatter (5 April 2006)

UPDATED: SQL Server 2005 Query Plan Webcast (20 March 2006)

PASS 2006 Call for Speakers is Open (7 March 2006)

Free tools for SQL Server (2 March 2006)

SQL Server 2000 I/O Basics (16 January 2006)

Scripting Database Objects using SMO (Updated) (29 November 2005)

Presentation: What I Wish Developers Knew About SQL Server (17 November 2005)

Troubleshooting Performance Problems in SQL Server 2005 (3 November 2005)

Dynamic Management Views (30 October 2005)

Improving Data Security by Using SQL Server 2005 (28 October 2005)

SQL Server 2005 RTM Code Available (27 October 2005)

GeoCoding with SQL Server and Google (8 August 2005)

Using SHERLOCK to Monitor Blocking (2 August 2005)

Inside SQLOS (20 July 2005)

SQLTeam.com: Five Fabulous Years (10 July 2005)

Featured Interview with Bob Ward, Microsoft PSS (30 June 2005)

Writing CLR Stored Procedures in C# - Returning Data (Part 2) (23 June 2005)

SQL Server 2005 Release Date - November 7th, 2005 (7 June 2005)

Writing CLR Stored Procedures in C# - Introduction to C# (Part 1) (6 June 2005)

Microsoft SQL Server TechCenter (1 June 2005)

Statistics Used by the Query Optimizer in Microsoft SQL Server 2005 (1 June 2005)

Managed Data Access Inside SQL Server with ADO.NET and SQLCLR (31 May 2005)

SQL Server/Visual Studio/BizTalk Connected Systems Developer Competition (30 May 2005)

Using CROSS APPLY in SQL Server 2005 (4 May 2005)

April CTP (aka Beta 3) Available Today (18 April 2005)

SQL Server 2005 Developer Webcasts (4 April 2005)

SQL Server 2005 Beta 2 Transact-SQL Enhancements (13 January 2005)

The Cost of GUIDs as Primary Keys (8 January 2005)

PASS 2005 Call for Presentations Closed (5 January 2005)

Site Updates (19 December 2004)

Microsoft Developer Survey (9 December 2004)

SQL Server 2005 December CTP's released (3 December 2004)

Using CLR Integration in SQL Server 2005 (29 November 2004)

2004 PASS Community Summit CD-ROM (1 November 2004)

Microsoft sets summer delivery of SQL Server (25 October 2004)

SQL Server 2005 Webcasts (25 October 2004)

Reading a Trace File using C# in SQL Server 2005 (25 October 2004)

PASS 2004 Presentation: Profiler and Trace in SQL Server 2005 (3 October 2004)

Are you a DBA? (27 September 2004)

Automatically Process SQL Server Trace Files (15 September 2004)

XP SP2 and SQL Server (31 August 2004)

The Daily Database Build (23 August 2004)

Microsoft SQL Server Health and History Tool (16 August 2004)

Sending SQL notifications with CDOSYS (4 August 2004)

SQL Server 2005 Beta 2 Available to MSDN Subscribers (26 July 2004)

SQL Server 2005 Express Technical Preview (30 June 2004)

Dealing with a large transaction log file (19 June 2004)

MS Best Practices Analyzer Released (26 May 2004)

Programmatically Save DTS Packages to Files (24 May 2004)

Yukon Management Tools: No Secrets (10 May 2004)

Microsoft SQL Server 2000 Index Defragmentation Best Practices (2 May 2004)

Improving .NET Application Performance and Scalability (29 April 2004)

Software Review: SQLCompare (27 April 2004)

Leveraging the .NET Framework in SQL Server 2005 (1 April 2004)

An Evaluation of Stored Procedures for the .NET Developer (22 March 2004)

SQL Server 2005 in the First Half of 2005 (10 March 2004)

MSDN: Inside the SQL Server 2000 User Mode Scheduler (8 March 2004)

ANSI/ISO SQL 99 standard downloads (5 March 2004)

Yaks, Yak, Yakmeat, Gourmet Exotic Yak meat, Delyaks, Montrose, Colorado, USA (22 February 2004)

What is the difference between SET and SELECT? (15 February 2004)

Microsoft SQL Server MVPs at SQLTeam.com (13 February 2004)

sql manivesa (12 February 2004)

A Practical Guide to SQL Server Yukon Beta 1 DTS (4 February 2004)

MSDN: Powerful New T-SQL Syntax Gives SQL Server a Programmability Boost (3 February 2004)

MSDN: Data Access and Storage Home (29 January 2004)

SQL Server Books Online (January 2004 Update) (29 January 2004)

Inside SQL Server 2000's Memory Management Facilities (29 January 2004)

Introduction to Transactions (25 January 2004)

SQL Server 2000 Wait Types (19 January 2004)

Search and Replace in a TEXT column (18 January 2004)

TechNet Support WebCast: How to cluster Microsoft SQL Server 2005 by using Microsoft Virtual Server (4 January 2004)

Getting Started with ObjectSpaces (31 December 2003)

A Long Road (23 December 2003)

MSDN: Yukon Basics: XML, T-SQL, and the CLR Create a New World of Database Programming (22 December 2003)

HOW TO: Move a Database Diagram (12 December 2003)

INF: Frequently Asked Questions - SQL Server 2000 - Table Variables (7 December 2003)

Parsing XML from a text column using sp_xml_preparedocument (5 December 2003)

Importing Large XML Documents using TEXTCOPY.EXE (3 December 2003)

Server side tracing in SQL Server using system stored procedures (1 December 2003)

Microsoft SQL Server 2000 Best Practices Analyzer 1.0 Beta (20 November 2003)

A little RSS goodness (18 November 2003)

New Poll Up (14 November 2003)

Bill Graziano's Advanced Profiler PASS Presentation (13 November 2003)

Fill out a survey on SQL Mail (Closed) (30 October 2003)

Sample Chapter: The Guru's Guide to SQL Server Architecture (30 October 2003)

Microsoft's SQL Server "Yukon" Website (29 October 2003)

Yukon Details on Technet (28 October 2003)

Database Design Thoughts for Packaged Applications (26 October 2003)

SQLTeam.com Weblogs (20 October 2003)

Microsoft SQL Server Reporting Services Homepage (18 October 2003)

How to use the new function fn_get_sql() (16 October 2003)

SQL Server 2000 Reporting Services Beta Signup (16 October 2003)

Yukon Beta 2 slated for May 2004 (14 October 2003)

Run CLR code from a stored procedure (14 October 2003)

Using EXISTS (12 October 2003)

A Conversation with Jim Gray (17 September 2003)

PASS Chat on SQL Server Administration (10AM PT on 9/24/2003) (16 September 2003)

The current state of database research (16 September 2003)

10 Steps to Help Secure SQL Server 2000 (16 September 2003)

MS Security Vulnerability (11 September 2003)

SQL Server Developer price reduced to $49 (1 August 2003)

What's new in SQL Server Yukon (28 July 2003)

NH SQL Server Users Group (22 July 2003)

SQL Server DTS Best Practices (27 May 2003)

Compare SQL Server databases (2 May 2003)

How to search for date and time values (2 May 2003)

MSDN: OLAP Distinct Counts and Performance Analysis (9 April 2003)

Top Six FAQs on Windows 2000 Disk Performance (24 March 2003)

Using Metadata (24 March 2003)

MS Response to the Slammer Worm (26 January 2003)

SQL Server 2000 SP3 Available (20 January 2003)

Book: SQL Server System Administration (6 January 2003)

Book: Code Centric: T-SQL Programming with Stored Procedures and Triggers (6 January 2003)

Book: Inside Microsoft SQL Server 2000 (6 January 2003)

Book: The Guru's Guide to SQL Server Stored Procedures, XML, and HTML (5 January 2003)

Microsoft SQL Server 2000 High Availability Series (31 December 2002)

Building and Configuring More Secure Web Sites (21 December 2002)

Performing case sensitive searches in SQL Server (21 December 2002)

SQL2000 SP3 Preview Webcast (21 December 2002)

Handling database file growth (18 December 2002)

Connecting With Perl - Using Win32::ODBC (18 December 2002)

Database Journal - SQL Server section (18 December 2002)

Implementing Encrypting File System (EFS) with SQL Server (9 December 2002)

SQL Server Audit (4 December 2002)

Yukon Demo at PASS (22 November 2002)

SQLXML 3.0 SP1 (21 November 2002)

Transactions in Sql Server 2000 (11 November 2002)

Server Side Cursors and ADO Cursor Types (11 November 2002)

Book review: Writing Secure Code (9 November 2002)

INF: Common SQL Mail Problems (22 October 2002)

Yukon Ho! SQL Server v.Next (21 October 2002)

Microsoft Security Bulletin MS02-061 : Elevation of Privilege in SQL Server Web Tasks (Q316333) (21 October 2002)

PASS 2002 North America (18 October 2002)

Using a CSV with an IN sub-select (13 October 2002)

Appropriate Uses of MSDE (11 October 2002)

New SQL Server Cumulative Security Patch (3 October 2002)

Migrating from Oracle to SQL Server (29 September 2002)

SQL Server CE 2.0 Released (17 September 2002)

Threat Profiling SQL Server (5 September 2002)

What's best for DBAs? GUI or T-SQL commands? (4 September 2002)

SQL Server 2000 Notification Services (31 August 2002)

SQL Server 2000 Cumulative Security Update ... Again. (16 August 2002)

The Case for the Surrogate Key (9 August 2002)

Foam - FOR XML EXPLICIT Tool (9 August 2002)

Getting the Most Out of SQL Server 2000's Query Analyzer, Part III (7 August 2002)

How to troubleshoot orphan users in SQL Server databases? (6 August 2002)

How to search all columns of all tables for a keyword? (31 July 2002)

Analyzing and Optimizing T-SQL Query Performance on Microsoft SQL Server using SET and DBCC (PDF) (25 July 2002)

Working with email addresses in SQL Server! (21 July 2002)

Another German Yak ... with a suprise (RC #3) (16 July 2002)

Spotting breaks in data sequences (16 July 2002)

Das Yak ist Deutsch (RC #3) (14 July 2002)

Book Review: Microsoft Sql Server 2000 Performance Tuning Technical Reference (12 July 2002)

Cumulative Patch for SQL Server 2000 (11 July 2002)

Pwdencrypt() Weakness (10 July 2002)

Book review: Transact-SQL Cookbook (29 June 2002)

Five Ways to Rev up Your SQL Performance (27 June 2002)

The FROM Clause (24 June 2002)

Case sensitive queries (21 June 2002)

Easy-SQL-Server.com (20 June 2002)

HOW TO: Configure Memory for More Than 2 GB in SQL Server (Q274750) (10 June 2002)

INF: SQL Server 2000 Full-Text Search Deployment White Paper (Q323739) (10 June 2002)

SQLXML 3.0 SP1 (10 June 2002)

Query Recompilation in SQL Server 2000 (10 June 2002)

Fun with numbers in T-SQL queries (9 June 2002)

Using TABLE Variables (7 June 2002)

Retrieving the GUID value of an inserted row (3 June 2002)

.NET Data Access Architecture Guide for SQL Server (2 June 2002)

Statistics in SQL (Sample Chapter) (27 May 2002)

MSDN Developer Communites (24 May 2002)

MSDN SQL Server related communities (24 May 2002)

SQL Server related communities (24 May 2002)

Microsoft's SQL Server Support Page (24 May 2002)

Worm squirming through SQL servers (21 May 2002)

The Wild Yak (19 May 2002)

Audit Triggers for SQL Server (8 May 2002)

Archiving data from production databases (7 May 2002)

MSSQLCity.com (7 May 2002)

Texas SQL Users (21 April 2002)

SQL Server Notification Services Beta Program (18 April 2002)

Using NEWID to Randomly Sort Records (16 April 2002)

Code to find out the statement that caused the trigger to fire! (16 April 2002)

What will C# Look Like in SQL Server? (15 April 2002)

Send E-Mail Without Using SQL Mail in SQL Server (SMTP) (11 April 2002)

Configure Memory for More Than 2 GB in SQL Server (8 April 2002)

SQL Injection White Paper (2 April 2002)

MSDE Information and Requirements (25 March 2002)

SQL In Simple English (18 March 2002)

Updated SQL Server 2000 Books Online Now Available (17 March 2002)

Microsoft overhauling files for next Windows (Yukon) (13 March 2002)

Understanding Identity Columns (9 March 2002)

SQL Server 2000 120 Day Trial Version (1 March 2002)

Validate your SQL query against SQL-92, -99 or -200x (draft) (23 February 2002)

MS: SQL Server Remote Data Source Function Contain Unchecked Buffers (20 February 2002)

Microsoft SQL Server 2000 Web Services Toolkit (19 February 2002)

Microsoft Data Analyzer - Review (18 February 2002)

The sql_variant Datatype (18 February 2002)

A Talk With Database Guru Jim Gray (7 February 2002)

Yukon Destined as Microsoft's Common Data Store (6 February 2002)

Yukon's CLR integration will have full parity with T-SQL (6 February 2002)

Comparing Tables (7 January 2002)

Another Random Record Selection Method (6 January 2002)

SQLXML 3.0 Beta available for download (31 December 2001)

MS: SQL Server Text Formatting Functions Contain Unchecked Buffers (20 December 2001)

Implementing row level security in SQL Server databases (15 December 2001)

DevGuru Transact-SQL Syntax Charts (9 December 2001)

MSDN: Microsoft SQL Server 2000 Security (7 December 2001)

Stored procedure to track database file growth (7 December 2001)

Yukon's Broad Beta Slated for Second Half of 2002 (6 December 2001)

Performance Tuning the Forums (3 December 2001)

SQL 2000 SP2 Available for download (30 November 2001)

Download Books Online (26 November 2001)

SQLXML.ORG (26 November 2001)

MDAC in Motion (26 November 2001)

XML dominates database file formats (with Yukon info) (26 November 2001)

Forum Upgrade (25 November 2001)

SQL Server worm on the prowl (25 November 2001)

Displaying Images that Reside in a Database (13 November 2001)

SQLXML 2.0 (XML for SQL Server 2000) (12 November 2001)

Reader Challenge #2 Solutions (29 October 2001)

Programmers Heaven - Where programmers go! (15 October 2001)

Reader Challenge #2 (CLOSED) (10 October 2001)

dbdebunk (26 September 2001)

SQL Server 2000 Operations Guide (25 September 2001)

SQL Server administration best practices (20 September 2001)

SQL Injection (20 September 2001)

Using Triggers to Track Database Action History (18 September 2001)

ITtoolbox Database (17 September 2001)

Cursor Performance (17 September 2001)

SQL Server security model overview and security best practices (16 September 2001)

ASPapp.com (16 September 2001)

INF: How to Configure SQL Mail (5 September 2001)

MS poised to switch Windows file systems with Blackcomb (7 August 2001)

More Ask SQLTeam Coming... (1 August 2001)

Clustering SQL7 on Windows 2000 (29 July 2001)

MSDN SQL Server Homepage (20 July 2001)

Database Architecture: The Storage Engine (20 July 2001)

Clustering SQL Server 2000 from 500 Feet (11 July 2001)

Step-by-Step Guide to Clustering Windows 2000 and SQL Server 2000 (11 July 2001)

Newsletter and Server Upgrade (1 July 2001)

SQLTeam.com: The First Birthday (25 June 2001)

SQL Server 2000 Service Pack 1 (14 June 2001)

Numeric Primary Keys (13 June 2001)

Database programming guidelines/conventions and best practices (11 June 2001)

Oracle vs. SQL Server - An Issue Of Complexity (10 June 2001)

Selecting Based on a Version Field (10 June 2001)

Trees in SQL (7 June 2001)

Reader Challenge #1 Solutions (Part II) (4 June 2001)

Reader Challenge #1 Solutions (Part I) (28 May 2001)

Database object naming conventions for SQL Server (17 May 2001)

Reader Challenge #1 (16 May 2001)

SQL Server CE: New Version Lets You Store and Update Data on Handheld Devices (msdn) (15 May 2001)

SQL Administrative Scripting (14 May 2001)

SQL-DMO Automation (microsoft.com) (12 May 2001)

ASPDB-Ax (9 May 2001)

Evaluation of Federated Database Servers and Distributed Partitioned Views of SQL Server 2000 (7 May 2001)

Cental Ohio SQL SIG (6 May 2001)

Schema Comparison & Synchronization Tools (6 May 2001)

SSCodeGen - Code Generation for SQL Server 7/2000 (1 May 2001)

SQL Server interview questions for DBA and Developer positions (19 April 2001)

SQLSecurity.com (18 April 2001)

International Features in SQL Server 2000 (13 April 2001)

Cincinnati SQL Server Users Group (11 April 2001)

Stored Procedures: Returning Data (9 April 2001)

Professional Association for SQL Server (6 April 2001)

St. Louis SQL Server Users Group (1 April 2001)

Answering a SQL Query Question from a Recruiter (28 March 2001)

Deleting Duplicate Records (26 March 2001)

OLE DB Connectivity (22 March 2001)

ANSI SQL "School" (19 March 2001)

Umachander's SQL Server Script page (11 March 2001)

Sql Query Builder released (8 March 2001)

ANSI SQL-92 Standard (8 March 2001)

Another Recruiter Asks a SQL Question (7 March 2001)

SQLTeam.com a Wrox Site of the Week (7 March 2001)

Narayana Vyas Kondreddi's SQL Server site. (1 March 2001)

Stored Procedures: Parameters, Inserts and Updates (26 February 2001)

SQL Server crosstab utility (25 February 2001)

Upgrading Forums . . . Done. (24 February 2001)

Updated: Logging In and Article Ratings (16 February 2001)

Returning complete words from a substring (9 February 2001)

Using Partitions (SQL Server 2000 OLAP) (8 February 2001)

SQL for Threaded Discussion Forums (4 February 2001)

Default Constraint Names (24 January 2001)

Dimensionally Friendly System (18 January 2001)

Temporary Tables (17 January 2001)

Denormalize for Performance (10 January 2001)

Searching on SQLTeam.com (2 January 2001)

Microsoft SQL Server Homepage (1 January 2001)

SQL Server on MSDN (1 January 2001)

Books Online . . . online (28 December 2000)

Estimating the Size of a Table (28 December 2000)

SQL Server XML View Mapper 1.0 (20 December 2000)

SQL7 Service Pack 3 Available (20 December 2000)

Ballmer comments on Yukon (19 December 2000)

Book Review: Professional SQL Server 7 Programming (17 December 2000)

Building a Highly Available Database Cluster (13 December 2000)

Search Design (13 December 2000)

SQL Interpreter and Tutorial (10 December 2000)

SQL for Threaded Discussion (Part II) (7 December 2000)

Returning a Row Number in a Query (5 December 2000)

Multiple Joins to the same Table in a Query (30 November 2000)

Good Things in Small Packages: Microsoft Launches SQL Server 2000 for Windows CE (28 November 2000)

Timestamps vs Datetime data types (28 November 2000)

String Functions: Incrementing a Number in a Char (27 November 2000)

Massive Vote Fraud at SQLTeam.com (22 November 2000)

Statistics Used by the Query Optimizer in Microsoft SQL Server 2000 (21 November 2000)

Retrieving Dynamic XML from SQL Server 7.0 and 2000 (13 November 2000)

Let SQL Server Write SQL Statements (10 November 2000)

Book Review: Practical Issues In Database Management (9 November 2000)

SQL Query asked by a recruiter (7 November 2000)

Images and SQL Server (6 November 2000)

Using Application Roles (30 October 2000)

Some Quickies in the Forum (30 October 2000)

XML for SQL Web Release 1 Beta 1 (23 October 2000)

Union of two full text queries without duplicates (23 October 2000)

Microsoft SQL Server XML Technology Preview (18 October 2000)

OSQL: Storing result of a Stored Procedure in a file (17 October 2000)

Catching Up (16 October 2000)

MSDN: Data Transformation Services in SQL 2000 (11 October 2000)

SQL Server Lock Contention Tamed: The Joys Of NOLOCK and ROWLOCK (11 October 2000)

The case for CASE (6 October 2000)

MSDN: Improving Performance with SQL Server 2000 Indexed Views (5 October 2000)

Multiple Random Records w/Single Select (4 October 2000)

MSDN: Index Tuning Wizard for Microsoft SQL Server 2000 (4 October 2000)

MSDN: DTS in SQL Server 2000 (3 October 2000)

Group By using Weeks (2 October 2000)

Returning a Single Random Row (27 September 2000)

Creating a Sequential Record Number field (25 September 2000)

New Look (20 September 2000)

Avoid Locking Conflicts (18 September 2000)

Controlling Jobs in Transact-SQL (18 September 2000)

Recursive Joins or Parent/Child Trees (15 September 2000)

Returning Rows in Random Order - Part III - Practical Applications (12 September 2000)

Service Pack 2 for SQL Server 7.0 (9 September 2000)

Passing a CSV or Array to a Stored Procedure (8 September 2000)

Finding the Most Popular Field Values (8 September 2000)

Database Normalization And Design Techniques (8 September 2000)

Selecting data from different databases (7 September 2000)

Using a Covered Index (7 September 2000)

Retrieving 1 record from 2 tables with where syntax (5 September 2000)

Stored Procedures: An Overview (1 September 2000)

What's after TOP? (31 August 2000)

Cursors: An Overview (30 August 2000)

Using ISNULL (25 August 2000)

New Forum Posts (24 August 2000)

Other Approaches to NOT EXISTS (23 August 2000)

Keeping Data in Temp Tables (21 August 2000)

Searching two SQL 7.0 tables at once (21 August 2000)

Comparing Dates (21 August 2000)

More Site Updates (19 August 2000)

Site Updates (18 August 2000)

Returning @@IDENTITY back to an ASP Page (18 August 2000)

Can I Backup Across the Network? (17 August 2000)

Using Subqueries to Select Records (17 August 2000)

Our FAQ is posted (15 August 2000)

Using SELECT to INSERT records (15 August 2000)

Multiple record counts in one SQL statement (14 August 2000)

More Quickies in the Forum (13 August 2000)

Apostrophe's and Quotation Marks in SQL Server (13 August 2000)

Row Locking (13 August 2000)

Passing Dates to a Stored Procedure (13 August 2000)

Exporting records into ASCII format (13 August 2000)

Computed Columns (10 August 2000)

SQL Subqueries from ASP (9 August 2000)

Uploading MDB to SQL Server Programmatically (9 August 2000)

UNION: Selecting from multiple tables in one statement (8 August 2000)

SQL Server 2000 Released to Manufacturing (8 August 2000)

Finding the biggest tables in a database (4 August 2000)

Forums and extra questions (3 August 2000)

Using the Information Schema Views (3 August 2000)

Using VBScript to make a new SQL Server Database (2 August 2000)

Dates in SQL Server (1 August 2000)

Dynamic SQL or How do I SELECT TOP @var records? (1 August 2000)

SQL Trace: Back again, and better than ever (31 July 2000)

Writing dyanmic SQL in an ASP page (29 July 2000)

Can I install SQL Server on Windows 98? (29 July 2000)

SQL Server 2000 Will RTM Next Week (27 July 2000)

Handling Exceptions (24 July 2000)

Getting the time zone (20 July 2000)

SQL Server and OLE DB Heterogeneous Queries (18 July 2000)

SQL Conference: Who needs a vacation? (16 July 2000)

MSDN Article on SQL 2000 (16 July 2000)

Best way to store text in SQL Server for ASP pages? (13 July 2000)

Welcome to our New Server (12 July 2000)

Error Message when dumping to hard drive backup device (12 July 2000)

Network Attached Storage: An Overview (11 July 2000)

Running Jobs (UNC vs Drive Letters ) (2 July 2000)

Full-text indexing: Advanced Queries (30 June 2000)

4GuysFromRolla.com (30 June 2000)

SQL Server 2000 Technology Guarantee (29 June 2000)

Full-text indexing: Overview and Installation (27 June 2000)

Autonumbering & Identity Columns (25 June 2000)

Using Web Assistant to Improve performance of ASP Pages (22 June 2000)

Documenting Scripts (21 June 2000)

Kansas City SQL Server Users Group (20 June 2000)

Microsoft SQL Server Homepage (2 June 2000)

Microsoft TechNet for SQL Server (1 June 2000)

Yampa Valley Yaks (30 May 2000)

SQL Server Consulting (1 January 2000)

- Advertisement -