SQL Server

More Topics

ITPro Today logo

Early Versions (SQL Server 2000 – 2008)

Returning First and Last Rows from Columns Containing Different Data Types Returning First and Last Rows from Columns Containing Different Data Types

These three solutions return a table’s first and last rows in distinctly different ways. Choose the solution that best fits your scenario.

byItzik Ben-Gan

Mar 31, 2002

|

1 Min Read

ITPro Today logo

April 2002 T-SQL Tutor Project April 2002 T-SQL Tutor Project

byKimberly L. Tripp

Mar 31, 2002

1 Min Read

ITPro Today logo

Early Versions (SQL Server 2000 – 2008)

Comparisons Against Columns of Data Type Bit in SQL Server 2000 and 7.0 Comparisons Against Columns of Data Type Bit in SQL Server 2000 and 7.0

Mar 26, 2002

1 Min Read

ITPro Today logo

Early Versions (SQL Server 2000 – 2008)

Should I Defragment My SQL Server Data Files?Should I Defragment My SQL Server Data Files?

Mar 26, 2002

1 Min Read

ITPro Today logo

Early Versions (SQL Server 2000 – 2008)

Inline vs. Multistatement Table-Valued UDFs Inline vs. Multistatement Table-Valued UDFs

Mar 26, 2002

1 Min Read

ITPro Today logo

Early Versions (SQL Server 2000 – 2008)

Data Missing from Error Logs Data Missing from Error Logs

byMicrosoft's Sql Server Development Team

Mar 26, 2002

1 Min Read

Early Versions (SQL Server 2000 – 2008)

DISTINCT vs. GROUP BY

DISTINCT vs. GROUP BY

Early Versions (SQL Server 2000 – 2008)

Tip: Commenting Out the GO Keyword in a Multiple-Batch SQL Script

Tip: Commenting Out the GO Keyword in a Multiple-Batch SQL Script

Early Versions (SQL Server 2000 – 2008)

Evaluating the Page Splits/Sec Value

Evaluating the Page Splits/Sec Value

byMicrosoft's Sql Server Development Team

.NET Connection-String Keywords

.NET Connection-String Keywords

Early Versions (SQL Server 2000 – 2008)

Hashing for Performance

Hashing for Performance

byKalen Delaney

Early Versions (SQL Server 2000 – 2008)

Wake Up to T-SQL

Wake Up to T-SQL

byItzik Ben-Gan

Early Versions (SQL Server 2000 – 2008)

Check Out the Updated SQL Server BOL

Check Out the Updated SQL Server BOL

Early Versions (SQL Server 2000 – 2008)

Make a SQL Server Wish

Make a SQL Server Wish

Early Versions (SQL Server 2000 – 2008)

Working with Variables in T-SQL, Part 2

Working with Variables in T-SQL, Part 2

byItzik Ben-Gan

Using T-SQL to Count Corporate Partners

Using T-SQL to Count Corporate Partners

Early Versions (SQL Server 2000 – 2008)

Using T-SQL to Manipulate the Registry

Using T-SQL to Manipulate the Registry

Early Versions (SQL Server 2000 – 2008)

The Fn_Split() and CamelCase() Functions

The Fn_Split() and CamelCase() Functions

Early Versions (SQL Server 2000 – 2008)

Qualifying a Table Variable’s Columns

Qualifying a Table Variable’s Columns

byItzik Ben-Gan

Early Versions (SQL Server 2000 – 2008)

Finding the Distinct Count of a Combination of Values in a Group

Finding the Distinct Count of a Combination of Values in a Group

byItzik Ben-Gan

Early Versions (SQL Server 2000 – 2008)

New SQL Server Magazine LIVE! Webinar: Fourteen Steps to a Better Database Schema

New SQL Server Magazine LIVE! Webinar: Fourteen Steps to a Better Database Schema

byKathy Blomstrom

Early Versions (SQL Server 2000 – 2008)

Feng Shui and Database Design

Feng Shui and Database Design

Early Versions (SQL Server 2000 – 2008)

Tracing Performance

Tracing Performance

Identifying Trends

Identifying Trends

byItzik Ben-Gan

Early Versions (SQL Server 2000 – 2008)

Using XML Bulk Load to Load ADO-Generated XML Data

Using XML Bulk Load to Load ADO-Generated XML Data

Early Versions (SQL Server 2000 – 2008)

Protecting Your Application from Variations in Date/Time Format

Protecting Your Application from Variations in Date/Time Format

byMicrosoft's Sql Server Development Team

Early Versions (SQL Server 2000 – 2008)

Does Sort Order Affect Performance?

Does Sort Order Affect Performance?

Early Versions (SQL Server 2000 – 2008)

Use the SQL Server 2000 Web Services Toolkit to Get Started with .NET

Use the SQL Server 2000 Web Services Toolkit to Get Started with .NET

Early Versions (SQL Server 2000 – 2008)

Converting Access Data into XML

Converting Access Data into XML

byMicrosoft's Sql Server Development Team

Early Versions (SQL Server 2000 – 2008)

Converting SQL Server 6.5 Databases to SQL Server 7.0

Converting SQL Server 6.5 Databases to SQL Server 7.0

byMicrosoft's Sql Server Development Team

Early Versions (SQL Server 2000 – 2008)

Unchecked Buffer in Microsoft SQL Server 2000 and 7.0

Unchecked Buffer in Microsoft SQL Server 2000 and 7.0

Early Versions (SQL Server 2000 – 2008)

Importing a Word Table into SQL Server

Importing a Word Table into SQL Server

byMicrosoft's Sql Server Development Team

Early Versions (SQL Server 2000 – 2008)

Sending SQL Server Job Notifications to Multiple Operators

Sending SQL Server Job Notifications to Multiple Operators

Early Versions (SQL Server 2000 – 2008)

Indexes and Joins

Indexes and Joins

byKalen Delaney

Early Versions (SQL Server 2000 – 2008)

Multivalued Attributes

Multivalued Attributes

byMichelle A. Poolet

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