This script will drop and recreated all indexes in a database within a transaction. The script will also add standard nameing conventions to the index names. Any duplicated indexes are removed.
2007-07-20 (first published: 2006-10-24)
1,386 reads
Quick and accurate method to get the row count of each table in a given database. Execution time is dependent on the number of rows in each table.-- Girish (gvphubli)
2007-07-20
1,363 reads
the following scripts helps in finding top 5 missing indexes using the new feature of DMV available in SQl Server 2005
2007-07-19 (first published: 2006-10-23)
5,382 reads
This script will delete the duplicate records without using cursor
2007-07-18
668 reads
Show line of code executing - more details than dbcc inputbuffer
2007-07-18 (first published: 2006-10-16)
912 reads
2007-07-17 (first published: 2006-10-12)
462 reads
I have written stored procedure which simply read each row one by one and update the some column in same table.SP is running fine in SQL Server 2000 and completed within 5 minutes (around 5 million rows)But same SP in SQL Server 2005, its taking around more than one hour (for same number of rows)Note: […]
2007-07-16
521 reads
Sometimes you need to calculate a running sum. Uses of this include adding a Month-To-Date column to a query of recent orders. I haven't seen anyone publish how to do this before (using this method).This query works by using the Row_Number() function and recursive query capability of SQL 2005.
2007-07-16
547 reads
Hope this is helpful to someone. This script will create a table and a stored procedure in the master database to gather and store table info for all datbases. The sp uses a temp table to hold the results returned by sp_spaceused, then transfers the information to the permanent table DatabaseTableSizes and adds the database […]
2007-07-16 (first published: 2006-10-11)
289 reads
2007-07-13 (first published: 2006-10-11)
133 reads
Fabric inbound network protection involves two tenant-level controls: Private Link and Block Public Internet...
Most apps that call an LLM send every request to the same model. That...
By Steve Jones
“The foundation of maturity: Just because it’s not your fault doesn’t mean it’s not...
WhatsApp:0838-3161-8008 Pondok Bambu Center, Jl. Pahlawan Revolusi No.30 Blk A/5-6, RT.2/RW.2, Wil, Kec. Duren...
WA CS (08218154392) Jl. H. Agus Salim No.57 B, RT.3/RW.1, Kb. Sirih, Kec. Menteng,...
Comments posted to this topic are about the item AI Observability Challenges in FinOps...
Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?
See possible answers