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,170 reads
Alexander Chigrik
SQL Server 6.5: Index Statistic Details
This article examines how index statistics are used in SQL Server 6.5
2002-02-08
162 reads
Some Useful UDFs for SQL Server 2000
Alxander Chigrik presents some useful User Defined Functions you can add to your SQL Server.
2001-12-19
8,597 reads
SQL Server 2000 Undocumented System Tables
Alexander Chigriks decodes some SQL Server 2000 Undocumented System Tables.
2001-11-21
9,864 reads
SQL Server 7.0 Undocumented Extended Stored Procedures
A few stored procedures that are not documented in SQL Server 7.0, but may come in handy for DBAs
2001-11-07
7,767 reads
SQL Server 6.5: Index Statistic Details
This article examines how index statistics are used in SQL Server 6.5
2001-10-30
3,280 reads
SQL Server 7: Some Useful Undocumented DBCC Commands
This article looks at some of the undocumented DBCC commands that exist in SQL Server 7.0
2001-10-22
7,059 reads
A Few Meta Data UDFs
Alexander Chigrik presents a few UDFs he has developed for getting meta data about your database objects.
2001-10-17
4,054 reads
2001-10-12
3,512 reads
A Few Mathematical UDFs
Alexander Chigrik presents a few Math UDFs he has developed for common functions.
2001-10-09
5,960 reads
Blogs
Social: Going Along to Get Along
By Steve Jones
It’s the eve of the Fourth of July, when the Declaration of Independence is...
Daily Coping 3 Jul 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
Using Docker Volumes for SQL Server in Linux
By John
No, not that kind of volume! Over the past couple of blog posts, I...
Forums
Pintable into cache
Pintable into cache to avoid fragmentation I have a table(OLTP database) which gets fragmented...
stored procedure to delete user and login
I was trying these but it does not work: USE [MyDatabase] GO /****** Object:...
Ask SSC