Viewing 15 posts - 6,766 through 6,780 (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
March 8, 2012 at 8:48 am
Here is an article just went live today. I would have posted sooner but the article was scheduled for today 😉
http://jasonbrimhall.info/2012/03/07/physical-or-virtual/
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
March 7, 2012 at 4:02 pm
http://msdn.microsoft.com/en-us/library/ms345408.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
March 7, 2012 at 3:39 pm
sqlfriends (3/7/2012)
two tables, see my top message shows the view definition
My bad. I didn't understand that to be the actual view definition since it said "something like this".
I was...
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
March 7, 2012 at 3:36 pm
Nope, no need to restart when changing that setting.
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
March 7, 2012 at 3:18 pm
sqlfriends (3/7/2012)
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
March 7, 2012 at 3:17 pm
Leeland (3/7/2012)
Lastly,
Have you considered the use of filtered indexes for c1.off_cycle and d1.ded_class?
I am not that familiar with the fuction filtered indexes (I will be reading up on that after...
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
March 7, 2012 at 3:13 pm
Lowell (3/7/2012)
CREATE VIEW v_YOURTABLE
WITH SCHEMABINDING
AS
SELECT * FROM YOURTABLE
Msg 1054, Level 15, State 6,...
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
March 7, 2012 at 2:10 pm
Echo
Some of the SQL binaries and components must be installed on the system drive. You can redirect some of the program install, but not all of it. I...
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
March 7, 2012 at 1:58 pm
That's all fine and well that the person running it might know what they are doing. But if they don't let you evaluate the query and tune it how...
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
March 7, 2012 at 1:53 pm
Will you update the old style join from this:
FROM PS_PAY_CHECK C,
PS_PAY_DEDUCTION D,
PS_BN_SNAP_JOB J
To the new style where Inner Join blah on something...
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
March 7, 2012 at 1:36 pm
I like to use Red Gate SQL Compare.
Another that I have used on occassion is dbdiff ( http://dbdiff.codeplex.com/ ).
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
March 7, 2012 at 1:08 pm
Please repost the execution plan as outlined in this article by Gail Shaw:
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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
March 7, 2012 at 1:01 pm
crookj (3/7/2012)
SQLRNNR (3/7/2012)
Two for today:SQL2012LaunchFailFailFail
and
SadSadDayinIndy
Now the Bears need to pick up Peyton.
Ditto! Indy has lost one of the few superstars that actually has class. Best wishes for him.
His...
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
March 7, 2012 at 12:56 pm
The DBA in me says to keep it restricted. Then whenever they have one of these queries run amok you will find out about it.
Is this a dev 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
March 7, 2012 at 12:55 pm
Viewing 15 posts - 6,766 through 6,780 (of 19,560 total)