Dynamic Columns with PIVOT Operator
Script to convert to N Columns the rows in a table with PIVOT Operator
2009-06-05 (first published: 2009-05-15)
1,973 reads
2006-11-14 (first published: 2006-05-08)
93 reads
Script to get total rows and space used
Script to Get Total Rows, space used and reserved (KB) of all tables
2006-08-18 (first published: 2006-08-01)
1,082 reads
Blogs
Setting Up Always Encrypted
In this post we're going to go through the steps to set up Always...
Using Azure Automation and Runbooks to Run Azure SQL Database Maintenance Tasks
I’ve been using Azure SQL Database for quite some while and have set up...
Create and Verify Microsoft Fabric Capacity
From June 1, 2023, Microsoft Fabric (preview) capacities are available via the Azure portal....
Forums
how to determine if we can delete the index can be removed
In SQL Server database, there is a table InventDim with two indexes: Idx1 with...
how to determine if we can delete the index can be removed
In SQL Server database, there is a table InventDim with two indexes: Idx1 with...
how to determine if we can delete the index can be removed
The table InventDim has some indexes, we create one index idx1 which has index...
Ask SSC