Viewing 15 posts - 19,231 through 19,245 (of 22,226 total)
Permits? We don't need no stinking permits.
Seriously though, the main reason I keep coming back here, well, in addition to learning something every single day, is that the tone 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
December 1, 2008 at 5:50 am
Well, it was a thrilling moment, I don't mind saying. I'll be picking up one of those integrated face sheild/helmet/ear protection things soon (read ASAP). First time in 10 years...
"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
November 30, 2008 at 8:08 am
I'm sort of loving the long weekend. I'm busting butt on the stupid book and I'm chain-sawing & splitting wood to get ready for the winter.
Broke a chain for...
"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
November 30, 2008 at 7:12 am
rbarryyoung (11/29/2008)
Lynn Pettis (11/29/2008)
I just find it pretentious to list all those certs. It begs the question, who is he trying to impress.
Probably himself. Seriously. It's easy...
"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
November 30, 2008 at 7:03 am
rbarryyoung (11/28/2008)
"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
November 28, 2008 at 2:31 pm
May as well chime in on this one.
First off, Phil, feel lucky. At least your developers are still at least using the words "data." We've had a rash of the...
"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
November 28, 2008 at 6:54 am
Yikes! I'd say so. Upgrades to the data model must be entertaining.
"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
November 28, 2008 at 6:28 am
GilaMonster (11/27/2008)
Train wreck waiting to happen.
If you want some...
"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
November 27, 2008 at 8:27 am
J (11/27/2008)
Could you not just use a common table with an extra field like "OwnerID"to keep...
"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
November 27, 2008 at 8:21 am
Jeffrey Williams (11/26/2008)
Or, you could try using SET FMTONLY OFF; in your stored procedure. One thing the TableAdapter is probably doing is running the stored procedure with format only...
"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
November 27, 2008 at 5:45 am
It sounds like you're getting parameter sniffing. You need to force a recompile on the procedure. Take a look at plan guides and see if you can implement one with...
"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
November 26, 2008 at 1:16 pm
Another vote for that book. Great read and good information.
Just remember that getting the clustered index right should be task #1. All other indexing flows from there.
"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
November 26, 2008 at 11:16 am
Sweet!
I'll bet it makes programming easy.
"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
November 26, 2008 at 11:15 am
Still, if it came down to it, I'd rather see inplace updates generating the aggregates than a series of columns going across a row. That's just horribly sloppy design. Again,...
"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
November 26, 2008 at 10:46 am
No, sorry, I'm not an ASP.Net programmer. I'd suggest trying either MSDN or Simple-Talk, just to get started. Other than that, I'm clueless. Sorry.
"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
November 26, 2008 at 8:48 am
Viewing 15 posts - 19,231 through 19,245 (of 22,226 total)