Viewing 15 posts - 19,231 through 19,245 (of 22,219 total)
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
Prior to 2005? Suffered.
There really wasn't an easy way to do it back then. The best approach was to have a natural key on the table then you wouldn't have...
"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:08 am
You mean like "You're right and I'm wrong" as I just recently posted?
😛
"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:03 am
Sorry, you're right. It's leakage from the old days. SCOPE_IDENTITY specifically deals well with triggers. My bad.
I still like the OUTPUT approach becuase it works the same with one row...
"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 7:44 am
It doesn't work on 2005. Period. Full Stop.
It doesn't work terribly well on 2008.
Get Red Gate SQL Prompt. It works great on both and in Visual Studio (although it's a...
"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 6:50 am
I assume you already updated the statistics with a full scan?
After doing that... Can you post the execution plan & query? Some functions that worked well enough in 2k don'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
November 26, 2008 at 6:47 am
Keith West (11/25/2008)
I'm not sure if this is the correct forum for this but here goes.
As good a forum as any. This is a huge topic, but I'll try to...
"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 6:43 am
If you're scripting database creation, two areas are going to cause you problems in terms of time. First, however big the database you create determines, on a given system, how...
"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 6:22 am
Viewing 15 posts - 19,231 through 19,245 (of 22,219 total)