Viewing 15 posts - 19,276 through 19,290 (of 22,219 total)
Please don't cross-post. There are now two different discussions going on about the same topic. Please continue discussion at the other location:
http://www.sqlservercentral.com/Forums/Topic607252-1291-1.aspx?Update=1
"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 24, 2008 at 6:05 am
This is a cross-post with this http://www.sqlservercentral.com/Forums/Topic607251-149-1.aspx
I'd suggest keeping discussion here.
"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 24, 2008 at 6:04 am
Yeah, I was going to recommend SQL Compare from Red Gate too. There's also Apex SQL, they have a nice compare utility. Visual Studio Team System Database Edition comes 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 24, 2008 at 6:01 am
Nice article over here:
http://jmkehayias.blogspot.com/2008/09/monitoring-for-blocked-processes-on-sql.html
Interesting, but I'd need to read this on in more detail to see if it's really good:
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1162653,00.html
Nice one from MS on technet
http://technet.microsoft.com/en-us/magazine/cc434694.aspx
"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 24, 2008 at 5:58 am
Your options are severely limited.
First, check the execution plan. Identify where the scans are occurring, if any, and see if you can affect them with an index or three. Think...
"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 23, 2008 at 10:28 am
GilaMonster (11/23/2008)
Grant Fritchey (11/23/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 23, 2008 at 10:20 am
Jeff Moden (11/23/2008)
Heh... no... haven't seen one like this before. The tools that generate code like this one and like Hibernate are gettin' kinda spooky and I've always resisted...
"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 23, 2008 at 9:29 am
Jeff Moden (11/23/2008)
Grant Fritchey (11/23/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 23, 2008 at 8:20 am
Ah, true, I hadn't thought about that. Still, the execution plan can point out where an index might help. He might be able to use a plan guide but I'll...
"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 23, 2008 at 8:00 am
The DTA can be a somewhat useful tool, but it's not terribly reliable.
Do you have an execution plan for the query? That would help identify what's occuring within your system.
First...
"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 23, 2008 at 7:42 am
Jeff Moden (11/23/2008)
Grant Fritchey (11/23/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 23, 2008 at 7:19 am
GilaMonster (11/22/2008)
Jack Corbett (11/22/2008)
Glad it was packed out Gail.
It wasn't completely packed out. There were empty seats. I'd say the room was 50-60% full. Bob Ward's session in...
"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 23, 2008 at 7:10 am
GilaMonster (11/22/2008)
Jeff Moden (11/22/2008)
But none of us has written a book like some of the good folks we know. 😉And he's writing another one. A full, published dead-tree book...
Re-writing one....
"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 23, 2008 at 7:05 am
Jeff Moden (11/22/2008)
GAAAA!!!http://www.sqlservercentral.com/Forums/Topic606992-65-1.aspx
And yet, there is Gail, answering his questions... Amazing. I wouldn't even bother with a response on one like 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
November 23, 2008 at 7:02 am
I'm too busy to learn how to keep the log from growing? No. I'm actually not too busy to learn that one. I'm too busy to learn how to figure...
"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 23, 2008 at 6:52 am
Viewing 15 posts - 19,276 through 19,290 (of 22,219 total)