158 reputation
15
bio website
location United States
age 48
visits member for 1 year, 8 months
seen Oct 16 at 15:43

Sep
29
comment Finding dependencies on a SPECIFIC COLUMN (modern way, without using sysdepends)
ALSO: Any idea if this would resolve nested dependencies? ie: a PROD depends on a VIEW which depends on TABLE.COLUMN: if we set criteria on TABLE & COLUMN, will both the view and the proc show in the results?
Sep
29
comment Finding dependencies on a SPECIFIC COLUMN (modern way, without using sysdepends)
This looks excellent. Can you comment on whether this AT ALL or POSSIBLY suffers from the same "stale, out of date" issues as sysdepends? See: sqlblog.com/blogs/aaron_bertrand/archive/2008/09/09/…
Sep
26
asked Finding dependencies on a SPECIFIC COLUMN (modern way, without using sysdepends)
Feb
21
awarded  Notable Question
Aug
14
awarded  Popular Question
Feb
12
awarded  Nice Question
Feb
12
awarded  Scholar
Feb
12
awarded  Student
Feb
12
awarded  Supporter
Feb
12
accepted Is there a way to determine if SQL Server queries are running in memory or going to disk?
Jan
30
asked Is there a way to determine if SQL Server queries are running in memory or going to disk?