Another way to track the database data growth
Scripts will display size of the data in the database/data files and remaining allocated space.
2013-05-10 (first published: 2008-11-17)
3,745 reads
Scripts will display size of the data in the database/data files and remaining allocated space.
2013-05-10 (first published: 2008-11-17)
3,745 reads
This little script will search for all matching tables on the SQL Server instance
2008-07-30 (first published: 2007-10-15)
736 reads
By Steve Jones
I had mentioned some new T-SQL functions for SQL Server 2022 and a commenter...
This post comes off the back of my last, where I looked at issues...
By Vinay Thakur
As this is an Artificial Intelligence (AI) World, things are changing. We can see that...
In today’s connected world, a reliable network is the backbone of any successful business....
A while into install I get a Microsoft OLE DB Driver for SQL Server....
Comments posted to this topic are about the item More Funny SELECTs
What does this code return?
SELECT ( SELECT COUNT (*), MAX(soh.OrderDate) AS latestorder FROM Sales.SalesOrderHeader AS soh WHERE soh.OrderDate > '01/01/2011' AND soh.OrderDate < '01/01/2012') AS OrdersIn2000 , ( SELECT COUNT (*), MAX(soh.OrderDate) AS latestorder FROM Sales.SalesOrderHeader AS soh WHERE soh.OrderDate > '01/01/2012' AND soh.OrderDate < '01/01/2013') AS OrdersIn2001 , ( SELECT COUNT (*), MAX(soh.OrderDate) AS latestorder FROM Sales.SalesOrderHeader AS soh WHERE soh.OrderDate > '01/01/2013' AND soh.OrderDate < '01/01/2014') AS OrdersIn2002; GOSee possible answers