Get record count for a specific database
This will sum all of the records of a specified database, excluding the 'sysdiagrams' table.
2013-10-23 (first published: 2007-12-17)
19,843 reads
This will sum all of the records of a specified database, excluding the 'sysdiagrams' table.
2013-10-23 (first published: 2007-12-17)
19,843 reads
One of the most common questions asked about SQL Server has to do with the transaction log and why does it grow. James Rea brings us a good explanation here of what happens and what you should do about it.
2010-05-28 (first published: 2009-01-05)
32,747 reads
The transaction log is a fairly complex construct in SQL Server and present in every database installation. New author James Rea brings us a great introduction to how the log works and how to maintain it.
2009-11-06 (first published: 2008-07-02)
40,595 reads
James Rea brings us another great article that shows you how to keep on top of the code that's stored in each of your databases.
2008-07-28
24,075 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