Viewing 15 posts - 11,341 through 11,355 (of 19,560 total)
Ray K (12/20/2010)
Celko warning alert
nah - that isn't bad. I think there are many people that would have or have posted similar statements in their replies.
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
December 20, 2010 at 12:32 pm
The Dixie Flatline (12/20/2010)
Congratulations, Gianluca 😀
I echo that - Congrats Gianluca.
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
December 20, 2010 at 12:29 pm
Here is an article from Gail Shaw on how to post that information.
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
yes, please provide the queries as well as the "staging" table structure. It would also be nice...
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
December 20, 2010 at 12:21 pm
Can you provide the DDL, DML and execution plan for the SQL in the DFT?
That will help immensely in troubleshooting your problem.
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
December 20, 2010 at 12:08 pm
What else do you have running on that server at 10PM?
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
December 20, 2010 at 10:39 am
tosscrosby (12/20/2010)
Daniel Bowlin (12/20/2010)
Four day week. Woo Hoo:-Pfor two weeks in a row!!! Double -woo hoo
Half days - triple woohoo
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
December 20, 2010 at 10:22 am
Thanks Paul - I can use this already.
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
December 20, 2010 at 10:20 am
That is a nice benefit of this forum - many times people will find that the issue resolution becomes clear once they write out the problem.
Congrats on solving the issue.
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
December 20, 2010 at 10:19 am
We use a two-op approach but don't use tape backup anymore. We backup to disk and then those backups are retrieved into an appliance that is disk based. ...
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
December 20, 2010 at 10:16 am
OCTom (12/20/2010)
Who are these people?!? No, seriously, I haven't heard of most of them. 😛Anyhow, Happy/Merry <insert individual celebration preference here> to one and all.
I think that is a fun...
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
December 20, 2010 at 10:08 am
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
December 20, 2010 at 10:03 am
Jack Corbett (12/17/2010)
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
December 17, 2010 at 4:06 pm
I would break up the presentations into smaller chunks. Spread them out over a few days. It's hard to take all of that in one sitting. It...
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
December 17, 2010 at 12:37 pm
wjlugaila (12/17/2010)
Thank You for the help!
You're 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
December 17, 2010 at 12:29 pm
Not a tool but at least a starting point.
A query and several links are provided here. The query shows how to query the plan cache specifically for missing indexes....
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
December 17, 2010 at 10:20 am
Viewing 15 posts - 11,341 through 11,355 (of 19,560 total)