This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
A hand checking an unlit firework rocket standing in a bottle on a garden wall, the matches still closed.

SET NOEXEC and PARSEONLY: Checking a Script Without Running It

January 4, 2012
Pinal Dave
SQL Tips and Tricks
SQL Coding Standards, SQL Dependency, SQL Server, SQL Stored Procedure

Use PARSEONLY and NOEXEC to inspect scripts without executing them, understand deferred references, and check existing module dependencies.

Read More
A fingertip touching one strand of a dewy spider web in a garden, drops trembling across the whole web

Finding Every Object That Uses a Column

December 11, 2010
Pinal Dave
SQL Tips and Tricks
SQL Column, SQL Dependency, SQL Server, SQL System Table

Find an object that uses a column with dependency metadata and module text search, then check dynamic SQL and application code.

Read More
SQL SERVER - Get the List of Object Dependencies - sp_depends and information_schema.routines

SQL SERVER – Get the List of Object Dependencies – sp_depends and information_schema.routines

February 4, 2010
Pinal Dave
SQL Tips and Tricks
SQL Dependency, SQL Scripts, SQL Server, SQL Server Security, SQL System Table

sp_depends can return wrong dependency results where information_schema.routines gets it right. See where it fails and the DMVs recommended in its place.

Read More
A hand redrawing one of several pinned maps with a red pencil to match a changed road

sp_refreshsqlmodule: Refreshing Views and Procedures After a Table Change

August 15, 2008
Pinal Dave
SQL Tips and Tricks
SQL Dependency, SQL Server, SQL Stored Procedure, SQL View

Use sp_refreshsqlmodule to refresh changed table dependencies, inspect stale view columns, and protect stable contracts with schema binding.

Read More
Previous 1 2
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com