Viewing 15 posts - 7,891 through 7,905 (of 19,560 total)
Trey Staker (11/11/2011)
I signed up for a Twitter account today. I'm not sure what to do with it. Is that a sign that I'm a geezer?
If you are,...
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
November 11, 2011 at 5:54 pm
have you queried the tables that Gail provided?
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
November 11, 2011 at 1:57 pm
Have you checked the VMWare host rather than the client logs?
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
November 11, 2011 at 1:54 pm
smileswithharish86 (11/11/2011)
any script related to this
K, did you look at the scripts in the links I provided?
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
November 11, 2011 at 1:24 pm
Criticize the code, and train the developer. Constructively criticize the person who wrote the code and see if they improve. Otherwise, how else will they ever get better...
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
November 11, 2011 at 1:03 pm
RedGate's SQL Data Compare does 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
November 11, 2011 at 12:56 pm
Marios Philippopoulos (11/11/2011)
The main problem here is lack of consistency.How can I expect the developer to fix this, if it cannot be reproduced in the dev environment?
You can't - totally...
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
November 11, 2011 at 12:53 pm
Very odd. When you updated stats, did you do it with fullscan? (Saw recently that a stat update with fullscan caused a query to run slower - just lobbing...
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
November 11, 2011 at 12:52 pm
smileswithharish86 (11/11/2011)
yes but i couldn't get
couldn't get what?
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
November 11, 2011 at 12:42 pm
did it get progressively slower, or did it just happen all of a sudden?
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
November 11, 2011 at 12:42 pm
Here is a resource for instance that could be helpful.
There is also this one:
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
November 11, 2011 at 11:46 am
Have you looked in the scripts section of SSC?
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
November 11, 2011 at 11:32 am
While first impressions do count, I find myself relying on them very rarely. My impression of someone can change very quickly from that first impression.
I also find it important...
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
November 11, 2011 at 11:19 am
So long as the data does not violate UQ indexes or PKs, you can use that wizard. Just don't select to have the table truncated first.
And, it would be...
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
November 11, 2011 at 11:12 am
Marios Philippopoulos (11/11/2011)
SQLRNNR (11/11/2011)
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
November 11, 2011 at 10:59 am
Viewing 15 posts - 7,891 through 7,905 (of 19,560 total)