Finding all Columns of an Index
This script helps to find all columns of an index on a table. Include columns covered (include)
2011-06-17 (first published: 2011-05-31)
1,356 reads
Augusto Alfonso
Numero de Registros y espacio usado en disco
Generacion de numero de registros y espacio usado en disco todas las tablas de la base de datos
2011-06-08 (first published: 2008-06-24)
520 reads
Check Fragmentation on All Indexes on Database
In this script we create a temporal table and then review all indexes with next conditions.
avg_fragmentation_in_percent > 10 % or avg_page_space_used_in_percent > 90 %
2008-09-05 (first published: 2008-07-10)
4,631 reads
Blogs
Using Data Masker on Chinese Surnames
By Steve Jones
A customer had a question recently on masking Chinese characters. I thought that was...
A New Word: Looseleft
By Steve Jones
looseleft – the feeling of loss upon finishing a good book, sensing the weight...
Using ChatGPT for Writing
By Steve Jones
I have been experimenting more and more with ChatGPT on a regular basis. I’m...
Forums
FREE SAMPLES ARE AVAILABLE FOR FACE-TO-FACE BUSINESS WhatsApp:+1(403) 388-4402
FREE SAMPLES ARE AVAILABLE FOR FACE-TO-FACE BUSINESS WhatsApp:+1(403) 388-4402 Buy the best quality supper...
MSSQL Service Broker DSQL operation on another database causing Broker failure
I have established a Service Broker configuration based on Eitan Blumin's excellent example. Advanced...
Validating Password Expiration
Comments posted to this topic are about the item Validating Password Expiration
Ask SSC