Thursday, November 29, 2012

SQL Server: Script to Find Tables in Stored Procedures, That Are Without NonClustered Index

From my query bank here is another useful script which can help a Database Administrator to list down stored procedures with tables names which are used in stored procedures but don't contain and non clustered index.

Query Output:

at 4:51 PM
Labels: , , , , ,

2 comments:

  1. AnonymousDecember 9, 2012 at 4:06 PM

    Helpful Script....

    ReplyDelete
  2. AnonymousMay 25, 2016 at 12:20 PM

    What if there is no entry for an object in sysdepends?

    ReplyDelete

All suggestions are welcome

Subscribe to: Post Comments (Atom)