MSSQL Query Blog
Viewing Table Based Index Information in SQL Server
Hello everybody, In this article, I will try to give information about displaying table-based Index information in SQL Server. In SQL Server, in some cases, you may want to display table-based Index information. You can easily do this using the code below. SELECT sys.objects.object_id, sys.objects.name AS tablename, sys.indexes.name AS indexname,...
Checking Index Fragmentation by Name in SQL Server
Hello to everyone, In this article, I will try to give information about Index fragmentation control by name in SQL Server. In SQL Server, in some cases, you may want to check Index fragmentation by name. You can easily do this using the code below. SELECT dbschemas.[name] as ‘Schema’, dbtables.[name]...
