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.
2008-10-17 (first published: 2001-10-08)
30,222 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,222 reads
This article examines how index statistics are used in SQL Server 6.5
2002-02-08
207 reads
Alxander Chigrik presents some useful User Defined Functions you can add to your SQL Server.
2001-12-19
8,636 reads
Alexander Chigriks decodes some SQL Server 2000 Undocumented System Tables.
2001-11-21
10,010 reads
A few stored procedures that are not documented in SQL Server 7.0, but may come in handy for DBAs
2001-11-07
7,982 reads
This article examines how index statistics are used in SQL Server 6.5
2001-10-30
3,308 reads
This article looks at some of the undocumented DBCC commands that exist in SQL Server 7.0
2001-10-22
7,515 reads
Alexander Chigrik presents a few UDFs he has developed for getting meta data about your database objects.
2001-10-17
4,099 reads
2001-10-12
3,575 reads
Alexander Chigrik presents a few Math UDFs he has developed for common functions.
2001-10-09
6,020 reads
You can find the slides of my session on the €100 DWH in Azure...
By Steve Jones
This value is something that I still hear today: our best work is done...
By gbargsley
Have you ever received the dreaded error from SQL Server that the TempDB log...
Hi everyone I am writing an SP where there is logic inside the SP...
Comments posted to this topic are about the item Planning for tomorrow, today -...
We have a BI-application that connects to input tables on a SQL Server 2022...
I try to run this code on SQL Server 2022. All the objects exist in the database.
CREATE OR ALTER VIEW OrderShipping AS SELECT cl.CityNameID, cl.CityName, o.OrderID, o.Customer, o.OrderDate, o.CustomerID, o.cityId FROM dbo.CityList AS cl INNER JOIN dbo.[Order] AS o ON o.cityId = cl.CityNameID GO CREATE OR ALTER FUNCTION GetShipCityForOrder ( @OrderID INT ) RETURNS VARCHAR(50) WITH SCHEMABINDING AS BEGIN DECLARE @city VARCHAR(50); SELECT @city = os.CityName FROM dbo.OrderShipping AS os WHERE os.OrderID = @OrderID; RETURN @city; END; goWhat is the result? See possible answers