SQL Server

More Topics

ITPro Today logo

Early Versions (SQL Server 2000 – 2008)

Shrinking a Bloated Database and Log File Shrinking a Bloated Database and Log File

Richard Waymire tells a reader how to shrink a ballooning database and log file.

byRichard Waymire

Nov 19, 2001

|

1 Min Read

ITPro Today logo

Early Versions (SQL Server 2000 – 2008)

Should I Use the sp_ Prefix for Procedure Names?Should I Use the sp_ Prefix for Procedure Names?

Nov 19, 2001

1 Min Read

ITPro Today logo

Early Versions (SQL Server 2000 – 2008)

Why Doesn't Profiler Capture ObjectId?Why Doesn't Profiler Capture ObjectId?

Nov 19, 2001

1 Min Read

ITPro Today logo

Taming the Skew Taming the Skew

byChristian Unterreitmeier

Nov 19, 2001

1 Min Read

ITPro Today logo

Early Versions (SQL Server 2000 – 2008)

Generating Descriptions for All Tables in a Database Generating Descriptions for All Tables in a Database

Nov 19, 2001

1 Min Read

ITPro Today logo

Early Versions (SQL Server 2000 – 2008)

Manipulating the Registry Manipulating the Registry

Nov 19, 2001

1 Min Read

Early Versions (SQL Server 2000 – 2008)

Split Mirror, SAN, and NAS

Split Mirror, SAN, and NAS

Early Versions (SQL Server 2000 – 2008)

Log Shipping in SQL Server 2000, Part 1

Log Shipping in SQL Server 2000, Part 1

Early Versions (SQL Server 2000 – 2008)

Querying a Real-Life Denormalized Table

Querying a Real-Life Denormalized Table

Early Versions (SQL Server 2000 – 2008)

Using Sql:nullvalue to Pass NULL Parameters to Stored Procedures

Using Sql:nullvalue to Pass NULL Parameters to Stored Procedures

Early Versions (SQL Server 2000 – 2008)

Updating SQL Server’s Internal Server Name

Updating SQL Server’s Internal Server Name

byRichard Waymire

Early Versions (SQL Server 2000 – 2008)

Early Versions (SQL Server 2000 – 2008)

Using Updategrams to Store Data in an Image Column

Using Updategrams to Store Data in an Image Column

Early Versions (SQL Server 2000 – 2008)

Matching Transactions

Matching Transactions

byItzik Ben-Gan

Early Versions (SQL Server 2000 – 2008)

Using XML Bulk Load to Invoke a Stored Procedure

Using XML Bulk Load to Invoke a Stored Procedure

Early Versions (SQL Server 2000 – 2008)

Microsoft Data Analyzer: The Future of Business Intelligence?

Microsoft Data Analyzer: The Future of Business Intelligence?

Early Versions (SQL Server 2000 – 2008)

Using Windows Security with IIS and SQL Server 2000

Using Windows Security with IIS and SQL Server 2000

Early Versions (SQL Server 2000 – 2008)

SP1 Bug: SELECT Query on Table with Computed Column Generates Access Violation

SP1 Bug: SELECT Query on Table with Computed Column Generates Access Violation

byKathy Blomstrom

Early Versions (SQL Server 2000 – 2008)

Demonstration Scripts for SQL Server Internals Webinar, November 6, 2001

Demonstration Scripts for SQL Server Internals Webinar, November 6, 2001

byKalen Delaney

Early Versions (SQL Server 2000 – 2008)

Generating a Crosstab Report

Generating a Crosstab Report

byUmachandar Jayachandran

Early Versions (SQL Server 2000 – 2008)

Using a UDF in a CHECK Constraint to Validate a Column

Using a UDF in a CHECK Constraint to Validate a Column

byItzik Ben-Gan

Early Versions (SQL Server 2000 – 2008)

Roll Your Own System Stored Procedures

Roll Your Own System Stored Procedures

byKalen Delaney

Early Versions (SQL Server 2000 – 2008)

The Outer (Join) Limits

The Outer (Join) Limits

byKimberly L. Tripp

Early Versions (SQL Server 2000 – 2008)

Aliases in T-SQL

Aliases in T-SQL

byKimberly L. Tripp

Early Versions (SQL Server 2000 – 2008)

Tip: Managing Data Dictionaries Based on SQL Server 2000 Extended Properties

Tip: Managing Data Dictionaries Based on SQL Server 2000 Extended Properties

Early Versions (SQL Server 2000 – 2008)

Using Table Variables in a Join

Using Table Variables in a Join

Early Versions (SQL Server 2000 – 2008)

Data-Mining Terminology

Data-Mining Terminology

+2

byKamal Hathi, JIM Yangand 2 more

Early Versions (SQL Server 2000 – 2008)

Put Data Mining to Work

Put Data Mining to Work

+2

byKamal Hathi, JIM Yangand 2 more

Early Versions (SQL Server 2000 – 2008)

Resetting the SQL Server Service Account Password

Resetting the SQL Server Service Account Password

byRichard Waymire

Early Versions (SQL Server 2000 – 2008)

Reestablishing Stored Procedure Dependencies

Reestablishing Stored Procedure Dependencies

byRichard Waymire

Early Versions (SQL Server 2000 – 2008)

Capturing the DDL from SQL Server 2000 Tables

Capturing the DDL from SQL Server 2000 Tables

byRichard Waymire

Early Versions (SQL Server 2000 – 2008)

Testing a SQL Server–VB Connection

Testing a SQL Server–VB Connection

byRichard Waymire

Early Versions (SQL Server 2000 – 2008)

Early Versions (SQL Server 2000 – 2008)

One Size Fits All?

One Size Fits All?

Early Versions (SQL Server 2000 – 2008)

Performance Counters

Performance Counters

Sign up for the ITPro Today newsletter

Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.

Newsletter Sign-Up