Viewing 15 posts - 18,736 through 18,750 (of 22,226 total)
bdgenterprises (1/14/2009)
Thank you very much. I couldn't see the forest from the trees. That was supposed to be 510, not 10.
Thank you very much!...
"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 1:03 pm
I guess I'm lucky. I've only had it lock up the system once. You guys ought to post your experiences over at the Red Gate forums. They'd be interested 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
January 14, 2009 at 1:02 pm
I agree. SQL Prompt works better in lots of ways. That's before we talk about formatting your code for you... Woo Hoo!
"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 12:20 pm
You can manage 2005 servers from the 2008 interface (and 2000 servers, not 7.0 or 6.5).
Intellisense will only work on 2008 instances. Sorry.
Check out Red Gate's SQL Prompt. I...
"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 11:35 am
Hey, AdventureWorks is my friend. Without it I'd have to create a fake database as well as fake queries for the book.
There's cool stuff on Codeplex. Nose around a bit.
"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 11:32 am
All the good Microsoft examples are up there. This might be it.
"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:19 am
Steve Jones - Editor (1/14/2009)
I think you did alright, Grant. Typical response for people that don't want to think about issues, just solve what they think is the problem.
Thanks Steve,...
"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:16 am
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
Viewing 15 posts - 18,736 through 18,750 (of 22,226 total)