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,348 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,616 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)
518 reads
Blogs
STRING_SPLIT Basics–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
My new Online Training: SQL Server Query Tuning Fundamentals – German Edition
As we all know there is already a lot of information available about SQL...
My new Online Training: SQL Server Query Tuning Fundamentals – German Edition
As we all know there is already a lot of information available about SQL...
Forums
Migrate the SSIS Catalog in Just a Few Clicks
Comments posted to this topic are about the item Migrate the SSIS Catalog in...
SQL Server Kerberos authentication from a Linux clients
Hi All, I have a need to establish a SQL Server Kerberos authentication from...
Housekeeping of SQL Azure DB's
Hi all, I have a question for you, as some move into the cloud...
Ask SSC