This procedure will display the rows, reserved, data, index and unused space used in KB for all user tables in the database. The idea is to call sp_spaceused repeatedly. Limitation: certain versions of sp_spaceused will truncate the table name to 20 characters.Speed will depend on current activity level and locking in the database. It will […]
2002-03-14
397 reads
By Kevin3NF
We get it. There’s no budget for a DBA on staff, or even a...
By Steve Jones
waldosia– n. a condition in which you keep scanning faces in a crowd looking...
By Zikato
Learn how to deploy schema changes in an always-online SQL Server environment without a...
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
Hi, We have some Windows Workstations Standalone and in Workgroup, and they all have...
I have a utility stored procedure of the form: CREATE PROCEDURE [dbo].[sp_Utility] @rule...
What does this code return in SQL Server 2022+?
select bit_count(2.4)See possible answers