Have you ever experienced a T-SQL query, a stored procedure, view or a trigger returning unexpected results. In this article by Raj Gill, he shows you how ANSI DEFAULTS may be to blame.
2001-10-18
10,824 reads
Running a script automatically from SQL Server is easier than you think. Here are a few methods you can use.
2001-10-17
17,265 reads
This article covers some of the common issues and questions when you cluster SQL Server 2000 and Windows 2000.
2001-10-11
13,658 reads
The Web Data Administrator is a utility program implemented in ASP.NET that enables you to easily manage your SQL data, wherever you are.
2001-10-10
1,911 reads
In this article, Alexander Chigrik looks at some useful undocumented stored procedures that shipped with SQL Server 2000.
2008-10-17 (first published: 2001-10-08)
30,228 reads
This article examines some of the undocumented stored procedures that exist in SQL Server 7.0
2001-09-28
7,772 reads
This article examines some useful undocumented stored procedures in SQL Server 6.5
2001-09-21
3,305 reads
This is a broad overview of the DBCC SQLPERF command primarily for version 7 and 2000.
2001-09-17
1,927 reads
By default, network database files are not supported with Microsoft SQL Server. Here's a workaround.
2001-09-14
1,145 reads
In an online transaction processing (OLTP) environment, the connection affinity mask option may provide performance enhancement in high-end, enterprise-level SQL Server environments that are running on computers with 16 or more CPUs. In particular, this option is useful when there are a significant number of network interactions (more than 10,000 per second) between the middle-tier application servers and the back-end SQL Server system.
2001-08-28
1,500 reads
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
I need to delete rows from both the temporal main and history tables. The...
Comments posted to this topic are about the item When SQL Server Central Went...
Comments posted to this topic are about the item The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers