SQL Server 2000 Useful Undocumented Stored Procedures
In this article, Alexander Chigrik looks at some useful undocumented stored procedures that shipped with SQL Server 2000.
2004-08-27 (first published: 2001-10-08)
30,243 reads
In this article, Alexander Chigrik looks at some useful undocumented stored procedures that shipped with SQL Server 2000.
2004-08-27 (first published: 2001-10-08)
30,243 reads
This article examines how index statistics are used in SQL Server 6.5
2002-02-08
227 reads
Alxander Chigrik presents some useful User Defined Functions you can add to your SQL Server.
2001-12-19
8,653 reads
Alexander Chigriks decodes some SQL Server 2000 Undocumented System Tables.
2001-11-21
10,028 reads
A few stored procedures that are not documented in SQL Server 7.0, but may come in handy for DBAs
2001-11-07
8,002 reads
This article examines how index statistics are used in SQL Server 6.5
2001-10-30
3,329 reads
This article looks at some of the undocumented DBCC commands that exist in SQL Server 7.0
2001-10-22
7,571 reads
Alexander Chigrik presents a few UDFs he has developed for getting meta data about your database objects.
2001-10-17
4,122 reads
2001-10-12
3,599 reads
Alexander Chigrik presents a few Math UDFs he has developed for common functions.
2001-10-09
6,064 reads
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Comments posted to this topic are about the item Stored Procedures for Server-Level Object...
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
Comments posted to this topic are about the item The Costs of Multiple Platforms
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^d') AND BusinessEntityID IN (7,8)See possible answers