Viewing 15 posts - 2,701 through 2,715 (of 19,560 total)
Please refrain from the use of maintenance plans.
I would recommend the defrag script by Michelle Ufford way before any others offered on the internet based on experience and client experience...
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
June 30, 2014 at 6:53 pm
You can try a query like what was in that article. If it returns results, then you have the packages stored in SQL Server (or at least some of...
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
June 30, 2014 at 3:44 pm
I have charged them on occasion.
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
June 30, 2014 at 3:41 pm
Lowell (6/30/2014)
...
could it be that because 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
June 30, 2014 at 9:15 am
These days my answers are along the lines of...
A DBA - to which they give the quizzical look
Then I say
A Database Consultant - seems to keep the requests for free...
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
June 30, 2014 at 9:12 am
David Burrows (6/30/2014)
SQLRNNR (6/30/2014)
David gave him most of the answer already but he didn't try to do anything with it other than say it doesn't work.
Actually Lynn's solution looked like...
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
June 30, 2014 at 9:07 am
Hugo Kornelis (6/29/2014)
I hate these questions where a declaration bad practice is buried under a heap of distracting code. I know that this happens in real code too,...
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
June 30, 2014 at 9:05 am
How long after you wake the machine are you waiting to do this data retrieval?
Long enough to have other tasks run first?
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
June 30, 2014 at 9:01 am
Sean Lange (6/30/2014)
SQLRNNR (6/30/2014)
Lynn Pettis (6/29/2014)
Koen Verbeeck (6/29/2014)
Lynn Pettis (6/28/2014)
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
June 30, 2014 at 8:46 am
EL Jerry (6/30/2014)
Intermission
https://www.youtube.com/watch?v=O0wOD9TWynM
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
June 30, 2014 at 8:44 am
Lynn Pettis (6/29/2014)
Koen Verbeeck (6/29/2014)
Lynn Pettis (6/28/2014)
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
June 30, 2014 at 8:34 am
When you do the conversion that is an explicit conversion.
If you allow SQL Server do the conversion, that is an implicit conversion.
Common places for that to happen is in joins...
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
June 28, 2014 at 12:38 pm
Do you mean convert_implicit?
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
June 28, 2014 at 12:28 pm
Have you tried making any adjustments to the provided code to make it work for your scenario?
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
June 28, 2014 at 12:07 pm
Lynn Pettis (6/28/2014)
And 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
June 28, 2014 at 11:04 am
Viewing 15 posts - 2,701 through 2,715 (of 19,560 total)