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,325 reads
Augusto Alfonso
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-03 (first published: 2008-07-10)
4,507 reads
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
2008-08-22 (first published: 2008-06-24)
516 reads
Blogs
Event Notifications Example
By SQLPals
Event notifications are kinda like a trigger in the sense that they respond to...
Did you know we have another SQL Server book coming out?
SQL Server 2017 Administration Inside Out was the first technical book I contributed to,...
Batch Scripting SQLCMD–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Forums
Using sftp in Visual Studio for SSIS packages
Hi, I've inherited the maintenance of SSIS packages that were created by our former...
Merge vs other options
Hi, I need to load a table that has 5,000,000 records, I usually use...
Password changes
I would like my SQL users to be able to change their SQL password.Using...
Ask SSC