select t.name as tablename, i.*
from sys.indexes i, sys.tables t
where i.object_id = t.object_id
and i.type_desc = 'NONCLUSTERED'
Showing posts with label NonCluster. Show all posts
Showing posts with label NonCluster. Show all posts
Monday, July 7, 2014
Script to list all NON-Clustered indexes in a database
Subscribe to:
Posts (Atom)
Cannot access the specified path or file on the server. Verify that you have the necessary security privileges and that the path or file exists
If you received below error while attaching a .mdf file in cluster environment please follow below steps to resolve the issue ERROR Ca...
