Viewing 15 posts - 11,521 through 11,535 (of 19,560 total)
GilaMonster (12/1/2010)
In the last 2 weeks there have been three resignations at current client:
The senior developer (leaving only 2 permanent developers)
The Chief Enterprise...
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 1, 2010 at 8:13 am
Tom.Thomson (12/1/2010)
CirquedeSQLeil (11/30/2010)
For any that might be interested in an opportunity to heckle a threadizen, check this out[/url].
The 744 pixel wide image doesn't really fit well unscaled in a 670...
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 1, 2010 at 8:11 am
Chad Crawford (12/1/2010)
CirquedeSQLeil (11/30/2010)
For any that might be interested in an opportunity to heckle a threadizen, check this out[/url].Will there be virtual doughnuts and virtual pizza?
Yes - lots 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
December 1, 2010 at 8:09 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
November 30, 2010 at 11:25 pm
Banish the crappy job. If you enjoy your profession but don't enjoy your current job, then make the change. It is well worth it in the end.
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 30, 2010 at 11:20 pm
sharath.chalamgari (11/30/2010)
LutzM (11/30/2010)
looks like a missing comma before the CASE statement.I'd also recommend to add an alias to your CASE .. END. 😉
apart from the above your code is also...
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 30, 2010 at 11:17 pm
How much memory do you have?
How many concurrent connections do you have?
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 30, 2010 at 11:15 pm
Jeff Moden (11/30/2010)
CirquedeSQLeil (11/30/2010)
Good stuff Jeff. Got that spackle article out pretty quick.
Thanks, Jason. Heh... When Steve first came out with the "Requested Articles" forum, I banged out...
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 30, 2010 at 11:14 pm
GilaMonster (11/30/2010)
InfiniteError (11/30/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
November 30, 2010 at 11:09 pm
What is the RAID configuration of the disks for both the old and the new? How many disks in the arrays? What is the allocation unit size 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
November 30, 2010 at 11:08 pm
This problem occurs because memory allocation contention causes a slowdown on the login process or the query execution process.
It is resolved by applying the hotfix.
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 30, 2010 at 10:23 pm
Jeff Moden (11/30/2010)
CirquedeSQLeil (11/30/2010)
For any that might be interested in an opportunity to heckle a threadizen, check this out[/url].Very cool... looking forward to that.
Put it on the calendar and we...
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 30, 2010 at 10:08 pm
Good stuff Jeff. Got that spackle article out pretty quick.
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 30, 2010 at 10:06 pm
What SP level are you at?
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 30, 2010 at 9:47 pm
phuong.nguyen-1008376 (11/30/2010)
Thanks for support. I resolved it
Now that you have it resolved, do you better understand what a deadlock is or how to find 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
November 30, 2010 at 9:43 pm
Viewing 15 posts - 11,521 through 11,535 (of 19,560 total)