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,337 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,592 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
Azure SQL Database Compatibility with SQL Server
By gorandalf
A long time ago, in early days of the Azure SQL Database in 2015,...
Custom deployment parameters in Azure Data Factory - Forget Me Not
By Rayis Imayev
(2020-Sep-26) Last week one of my Azure Data Factory (ADF) deployment pipelines failed with an...
VMworld 2020 – Top 10 Database Sessions (Part 2)
By kleegeek
Whether you are a SQL Server Database Administrator, Infrastructure Architect, or any other member...
Forums
about the option (fast n) and acutal execution plan
what kind of situation can I use "option (fast 1)" when I execute a...
Problem during the setup of SQL Server 2019
During the installation I come to the step of configuring the database engine. It...
A Getting Started PostgreSQL Tutorial
Comments posted to this topic are about the item A Getting Started PostgreSQL Tutorial
Ask SSC