Viewing 15 posts - 12,841 through 12,855 (of 22,219 total)
SQLkiwi (4/4/2011)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 4, 2011 at 6:06 am
WayneS (4/3/2011)
Grant Fritchey (4/3/2011)
I'm just glad it's over. All that crap is out of my basement. Yay!So, whose more glad about that... you or your family?
Oh, the wife is pretty...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 4, 2011 at 6:04 am
WayneS (4/1/2011)
I'm specifically interested in the use of stored procedures.
1. Should ORM tools...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 4, 2011 at 4:57 am
Jeff Moden (4/3/2011)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 4, 2011 at 4:54 am
SQLkiwi (4/2/2011)
Got to meet heaps of great people including Grant and Stefan K!
If anyone would like to see the slides...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 3, 2011 at 5:04 am
SQLkiwi (4/1/2011)
Hi everyone. Just to confirm it officially: I am now a SQL Server MVP (yay!)Thanks to everyone for their kinds words and encouragement.
Paul
Congratulations again Paul. Extremely well deserved.
And...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 3, 2011 at 5:02 am
Roy Ernest (4/1/2011)
Shaken and hurts. Other wise I am Ok. Thx
Sorry to hear it. Take it easy and feel better.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 3, 2011 at 4:59 am
Fixed it. Sorry about that.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 1, 2011 at 9:11 am
David Benoit (4/1/2011)
Grant Fritchey (4/1/2011)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 1, 2011 at 8:56 am
On a guess, the optimizer timed out trying to unpack the views and the "best" plan at the time of the timeout was missing the predicate because the optimizer hadn't...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 1, 2011 at 8:03 am
Absolutely. You should test each SP prior to putting it on your production system and that should take a week or two, just to be sure, but then, yes, you...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 1, 2011 at 6:59 am
- Win. (4/1/2011)
The step 3 and 4 has 19 storedprocedures, which pulls data from other source and which creates #temp tables and bulk inserts into my DB. Execution plan shows...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 1, 2011 at 6:48 am
I guess it really depends on what the error is. XML is THE method of sending messages remotely. It's how BizTalk works. You can certainly use XML as a means...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 1, 2011 at 6:40 am
In general, if you don't want to purchase a third party product, setting up server side traces and using the, free from Microsoft, RML Utilities.
But, if you want to spend...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 1, 2011 at 5:37 am
I am frankly just a but nervous of certifications when I see them on a resume. Sorry, but there it is.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 1, 2011 at 5:19 am
Viewing 15 posts - 12,841 through 12,855 (of 22,219 total)