Viewing 15 posts - 17,446 through 17,460 (of 19,560 total)
You have a composite key as your primary key in Dim_Blog and don't use half the key.
If you add
And A.BlogTransID = 1
To your where clause, then a clustered index seek...
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
February 9, 2010 at 4:11 pm
Lynn - no.
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
February 9, 2010 at 3:44 pm
Brian and Gail (and others) have made excellent points. Gails points are thought provoking in that, a local admin really can do quite a bit on the server -...
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
February 9, 2010 at 3:41 pm
Alvin Ramard (2/9/2010)
CirquedeSQLeil (2/9/2010)
From http://www.dbnewsgroups.net/group/microsoft.public.sqlserver.programming/topic13791.aspx, Kalen Delaney brings up the stored proc that can changed the ObjectProperty 'IsMSShipped' to a value...
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
February 9, 2010 at 3:19 pm
Not sure I want to post this in that thread.
From http://www.dbnewsgroups.net/group/microsoft.public.sqlserver.programming/topic13791.aspx, Kalen Delaney brings up the stored proc that can changed the ObjectProperty 'IsMSShipped' to a value of 1. ...
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
February 9, 2010 at 3:12 pm
GSquared (2/9/2010)
CirquedeSQLeil (2/9/2010)
I think the only method to exclude those two tables (sysdiagrams and dtproperties) is to hard code them into the query. Anybody else have any other ideas?
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
February 9, 2010 at 2:59 pm
Roy Ernest (2/9/2010)
If you use is_ms_shipped = 0, does it not exclude those tables?
Those two tables, no. They are tweener tables. They were technically shipped with SQL Server,...
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
February 9, 2010 at 2:28 pm
BaldingLoopMan (2/9/2010)
However I would never ever withhold my help because someone did not conform to my professional standards or called me mean names. I find that shallow and conceded....
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
February 9, 2010 at 2:24 pm
I think the only method to exclude those two tables (sysdiagrams and dtproperties) is to hard code them into the query. Anybody else have any other ideas?
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
February 9, 2010 at 2:11 pm
I am testing it. So far, both your query and my query return the exact same results. I also found another extended property on which to limit the...
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
February 9, 2010 at 1:52 pm
Yes, this is a very interesting 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
February 9, 2010 at 1:46 pm
I don't believe in this scenario that you need to use all of those options. Here is a modified query that returns the same result set. The sysdiagrams...
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
February 9, 2010 at 1:45 pm
J-F Bergeron (2/9/2010)
Lynn Pettis (2/9/2010)
I guess it's time for me to start a personal black-list
Ehh, I wish I would've seen that comment before I posted the solution,
Why be so rude...
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
February 9, 2010 at 1:42 pm
I agree, that one was over the top. Right at the top of the list for worst comments.
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
February 9, 2010 at 1:20 pm
Nice article. Well written.
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
February 9, 2010 at 12:05 pm
Viewing 15 posts - 17,446 through 17,460 (of 19,560 total)