The Guru's Guide to T-SQL
Steve Jones's review of this classic and reference. A must-have for every SQL Server DBA.
2001-07-04
5,415 reads
Articles
PASS 2001 North America - Register and Save $500
Unique access to more than 110 sessions and 80 presenters, including SQL Server users and Microsoft developers. Educational tracks include: data warehousing and business intelligence; developing web-enabled and line of business solutions; enterprise database administration and deployment; and, professional development. Register today and get a great return on your SQL Server investment!
2001-07-04
3,665 reads
Clonation and the Case of Table Dolly, Part 2
In the last installment of this column, at the end of a long and erudite discussion on clonation, I introduced the sad but instructive story of Dolly. As a real scientist, I was conducting experiments on disconnected data features applied to intermittent applications.
2001-07-03
950 reads
2001-07-02
4,064 reads
SQL Server 7.0 Log Shipping Frequently Asked Questions
This article addresses some common questions about the Log Shipping tool for Microsoft SQL Server 7.0.
2001-07-02
1,764 reads
Find The First Row
Ever needed to find the first occurrance of some data. This article looks at T-SQL querying for data in natural order.
2001-06-29
12,688 reads
Microsoft Certification Exams Included in VA Education
Microsoft Corp. today announced that veterans taking tests in the Microsoft® Certified Professional (MCP) program can now use their Department of Veterans Affairs (VA) education benefits to cover examination fees (May 23, 2001).
2001-06-29
4,208 reads
Using Stored Procedures from ADO 2.1
If you’re running database-intensive code from Visual Basic or ASP, stored procedures can give you a great speed boost. With ADO 2.1, one of the components that makes up MDAC, this technique is easier to implement than ever.
2001-06-29
1,967 reads
Multiple paths in DTS Workflow
This article shows you how to create multiple converging paths in workflow, and covers the use of a simulated OR constraint, not available directly from within the designer.
2001-06-28
990 reads
Missing Temp Tables - Follow Up
Two weeks ago Andy challenged the readers of SQLServerCentral.com to figure out a small puzzle. Come see the results for yourself and find out who won some cash!
2001-06-27
4,867 reads
Blogs
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
How to Find Expensive Queries in Amazon Redshift
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
Forums
SQL 2019 instance with AG, across 2 Windows 2016 OS servers - OSin-place upgrade
Hi all Can I get some perspective from the community please on performing in-place...
How Long is a Long I/O?
Comments posted to this topic are about the item How Long is a Long...
T-SQL Trigonometric Functions in SQL Server
Comments posted to this topic are about the item T-SQL Trigonometric Functions in SQL...
Question of the Day
How Long is a Long I/O?
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers