Viewing 15 posts - 18,136 through 18,150 (of 22,220 total)
jcrawf02 (3/4/2009)
Grant Fritchey (3/4/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
March 4, 2009 at 6:11 am
Mangal Pardeshi (3/4/2009)
dear Grant,Honestly I'm reading your name for the first time.
Not entirely true. I've responded to other posts of yours in the past. 😎
But all the same, you 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
March 4, 2009 at 6:08 am
In production we have two or three 2005 servers and already two 2008 servers. The other 30 are 2000. We're starting the process of migrating off the 2000 to 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
March 4, 2009 at 6:03 am
Bevan keighley (3/3/2009)
veena (3/2/2009)
thank you for replying....
For Some reason i want to Store TableA id in TableC....
Plz Tell me Whether i can do this in a database where Normalization rules...
"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
March 4, 2009 at 5:59 am
I always forget they're there when I post. Makes me crazy.
:D:P;):w00t::cool::hehe:
"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
March 4, 2009 at 5:57 am
It is bad, really bad, form to have tables without primary keys. You need a way to identify data in order to retrieve it.
The problem is, in your example, 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
March 4, 2009 at 5:55 am
Well that one just yacked me off but good. He may as well be quoting from my posts because I'm "guilty" of all the "crimes" he listed. But hey, 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
March 4, 2009 at 5:45 am
Mangal Pardeshi (3/4/2009)
I must confess, my that comment was with one of the poster with not all of you guys.
I observe that one such member is just looking for increase...
"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
March 4, 2009 at 5:41 am
Mangal Pardeshi (3/4/2009)
Steve Jones - Editor (3/3/2009)
Marking something as "answered my question" is something we're considering.
Sooner the better.
The rating thing, hard to know. I think if you consistently answer poorly,...
"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
March 4, 2009 at 5:34 am
Something. That isn't closing it's connections. Could be SQL, could be something else. Probably something else.
"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
March 3, 2009 at 9:47 am
That sounds like some app isn't closing it's connections. Lots of open connections will certainly chew up memory eventually.
"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
March 3, 2009 at 9:31 am
It can be yes. If you look through the white paper though they're using DMV (dynamic management views) which give you a lot more detail that you'll get through 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
March 3, 2009 at 9:10 am
Stamey (3/3/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
March 3, 2009 at 9:04 am
Hmmm... Well, have you tried looking at the wait states and queues? That's where I'd go next. See what everything is waiting on. Here's an excellent article on it: http://download.microsoft.com/download/4/7/a/47a548b9-249e-484c-abd7-29f31282b04d/Performance_Tuning_Waits_Queues.doc
"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
March 3, 2009 at 8:41 am
One issue I've seen repeatedly with linked servers is running the query such that the filters are processed on the SQL SErver side. This requires that a SELECT * be...
"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
March 3, 2009 at 8:30 am
Viewing 15 posts - 18,136 through 18,150 (of 22,220 total)