Viewing 15 posts - 18,736 through 18,750 (of 22,219 total)
Jack Corbett (1/14/2009)
"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
January 14, 2009 at 10:14 am
Instead of rolling your own cache management, you might consider one of the cache management softwares that's available. One of our systems under development has just started this process. Here's...
"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
January 14, 2009 at 10:09 am
GilaMonster (1/14/2009)
Grant Fritchey (1/14/2009)
Evidently I'm only providing problems, not solutions.*twitch* I'm losing my temper here....
Clearly, I am as well.
"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
January 14, 2009 at 9:16 am
Well, I just popped off
http://www.sqlservercentral.com/Forums/Topic635918-149-1.aspx?Update=1
Evidently I'm only providing problems, not solutions.
"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
January 14, 2009 at 8:57 am
foxjazz (1/14/2009)
These tables are not (data) are not changed frequently, and the data is cached on the clients software.
When 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
January 14, 2009 at 8:56 am
GilaMonster (1/14/2009)
"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
January 14, 2009 at 8:39 am
foxjazz (1/14/2009)
populate another table with :
changedtablename, changeddate, changedvaluestring
Have my service process run...
"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
January 14, 2009 at 8:38 am
Can you turn on TraceFlag 1204 and capture the deadlock graph that it will generate in the error log and post it? That's the best way to help.
The exact locks...
"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
January 14, 2009 at 6:33 am
I'm not entirely sure what you're shooting for here either.
But, if I'm understanding you correctly, you're wondering how to use MAX in the WHERE clause.
You would do something like this...
"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
January 14, 2009 at 6:21 am
To create a common table expression (CTE) the last statment prior to the CTE must be closed off with a semi-colon, in your case:
DECLARE @sumAllProducts INT...
"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
January 14, 2009 at 6:17 am
After you work through the best practices, you can start here [/url]to work on performance.
"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
January 14, 2009 at 6:09 am
I'm assuming you're referring to data changes in the table...
Triggers are probably going to be the simplest to implement. Keep it really simple and just set a flag somewhere 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
January 14, 2009 at 6:05 am
Just to take a slightly different approach, what is the clustered index on the table where the inserts are occurring? With a bit of tuning, probably including the CreateDt column...
"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
January 14, 2009 at 5:59 am
ALZDBA hit the nail on the head. You're setting the variable as a CHAR(10) and the very first parameter, 'David Howard', has 12 characters. So it's going to truncate 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
January 14, 2009 at 5:56 am
Bob Hovious (1/13/2009)
Think they even had chocolate covered dill pickles one year.
HERESY!!! :w00t:
Everybody down South knows you should deep-fry those suckers and serve 'em with come-back sauce. (They'd go...
"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
January 14, 2009 at 5:34 am
Viewing 15 posts - 18,736 through 18,750 (of 22,219 total)