Speed Tips For Select Statements
This article by Neil Boyle examines techniques for speeding up your queries by writing better T-SQL.
2001-06-07
13,610 reads
Articles
Professional SQL Server 2000 DTS Review
Steve Jones reviews the premier DTS reference for SQL Server 2000.
2001-06-06
12,574 reads
SQL Server 7.0 and OLE DB Heterogeneous Queries
This article discusses queries that involve more than one database server. For example, you can run a query that returns a joined recordset where some records come from a SQL Server™ database and others come from an AS/400 machine.
2001-06-06
1,416 reads
Speedy Database Recovery with Differential Backups
Differential backups are a new feature in SQL 7 that can speed up your recovery times when restoring from database and transaction log backups.
2001-06-05
7,638 reads
Microsoft SQL Server 2000 Reliability
Lots of people are designing and building Microsoft Windows-based apps with previously unimagined reliability. Starbucks, GMAC, and FreeMarkets.com all have case studies demonstrating five nines. So, how are these companies able to achieve these levels of reliability?This month I am going to show you how to use standard Microsoft Windows technologies to make your Microsoft SQL Server™ app just like Denny's—“always open” and ready for business.
2001-06-05
1,660 reads
Complex updates using the Case statement
One of the keys to database performance if keeping your transactions as short as possible. In this article we will look at a couple of tricks using the CASE statement to perform multiple updates on a table in a single operation.
2001-06-04
10,709 reads
2001-06-04
2,735 reads
Put Advanced SQL Server Features To Work
SQL is the lingua franca of server-side Web data apps. Some of the advanced features of SQL joins, views, rankings, and computed columns can drastically simplify your code.
2001-06-04
1,107 reads
Missing Temp Tables
In part one of a two part article, Andy Warren challenges the readers of SQLServerCentral.com to solve a problem involving ADO and SQL Server. Are you up to the challenge?
2001-06-01
4,234 reads
Scrubbing Data With DTS : Part 1
When trying to implement data from an external source, very rarely do you receive the data in perfect condition. In part one of this series, we show you how to clean your data using DTS.
2001-06-01
8,408 reads
Blogs
SQL Saturday Boston Slides and Code
By Steve Jones
Thanks to everyone who attended my sessions today at SQL Saturday Boston 2025. I’ve...
Scaling SQL Server 2025 Vector Search with Load-Balanced Ollama Embeddings
SQL Server 2025 introduces native support for vector data types and external AI models....
Advice I Like: Fear and Imagination
By Steve Jones
Fear is fueled by a lack of imagination. The antidote to fear is not...
Forums
how to use a variable in a CASE statement?
hi everyone I am getting an error when I add a variable to a...
How to Use SQL Server Features to Cut Web App Latency in Half
Comments posted to this topic are about the item How to Use SQL Server...
Choosing an AI in Sept 2025
Comments posted to this topic are about the item Choosing an AI in Sept...
Question of the Day
The New SQL Server 2025 Data type
In SQL Server 2025, there is a new data type designed to support similarity search and machine learning applications for AI applications. What is this new data type?
See possible answers