Viewing 15 posts - 9,196 through 9,210 (of 19,560 total)
Thanks for the question
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 4, 2011 at 9:35 am
Jeffrey Williams-493691 (8/3/2011)
SQLRNNR (8/3/2011)
Try the suggestions in this articlehttp://blogs.msdn.com/b/sql_protocols/archive/2006/04/28/585835.aspx
I just posted the same link on SQLTeam.com for the same question :w00t:
:hehe: What are the chances?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 4, 2011 at 9:28 am
Is the GUID required to be a part of the stored proc call?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 4, 2011 at 9:25 am
savedanthony (8/4/2011)
It's just hard to find someone with the knowledge in both systems. But thank you both for trying.
Sorry we couldn't help more.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 4, 2011 at 9:24 am
Try the suggestions in this article
http://blogs.msdn.com/b/sql_protocols/archive/2006/04/28/585835.aspx
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 3, 2011 at 5:44 pm
I currently have Developer Edition SQL 2008 R2 installed on Win 7 Home Premium as well as Professional.
You should be fine with the express edition on those same platforms.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 3, 2011 at 5:41 pm
It sounds like that GUID parameter is required to pass to the proc. Is a NULL value permissible for that parameter?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 3, 2011 at 5:40 pm
Lowell (8/3/2011)
SQLRNNR (8/3/2011)
Yes there is. Check this one out.http://jasonbrimhall.info/2011/07/11/foreign-key-hierarchy-update/
Nice script Jason, I had done something similar for Hierarchy, but mentally skipped over dependencies in the other direction.
i added that...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 3, 2011 at 2:59 pm
kishoremania (8/3/2011)
I tried for many tables, that too join tables which will definitely have foreign keys.
You might want to check in SSMS under the table properties as well as sys.foreign_keys
SELECT...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 3, 2011 at 2:31 pm
You are welcome.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 3, 2011 at 2:27 pm
You may want to test with other tables. If there are no FKs related to that table, you should get an empty result set.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 3, 2011 at 11:39 am
Yes
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 3, 2011 at 11:37 am
Without the sample data I'll venture that something like this may work
SELECT [LOAD DATE], [LEVEL], [TITLE], [ATTUID], [NAME],
(SELECT COUNT(*)
FROM dbo.tbl_CDE_Hierarchy_Export
WHERE (SVP_ATTUID = [ATTUID]
OR VP_ATTUID = [ATTUID]
OR...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 3, 2011 at 10:49 am
K I see what you are trying to do. IMHO, I would use some other app to do this. Since you are trying to do it strictly within...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 3, 2011 at 10:41 am
As the article explains, it covers both ancestry and hierarchy.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 3, 2011 at 10:28 am
Viewing 15 posts - 9,196 through 9,210 (of 19,560 total)