Viewing 15 posts - 17,956 through 17,970 (of 22,226 total)
Lynn Pettis (3/24/2009)
Is it me or are the people we are trying to help just getting dumber, or do we need to start commenting are code a lot more heavily?
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
March 24, 2009 at 7:57 am
I doubt there's a way to do this in a single go. Each table will need and individual PK created. Unless you've named the primary key in all 100 tables...
"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 24, 2009 at 6:08 am
Try looking at sys.dm_tran_locks to see what locks are being held. When I run it, I see an exclusive intent lock on the page from the first statement. That's causing...
"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 24, 2009 at 6:05 am
Ray Herring (3/23/2009)
I have two related questions. First I have been working with sys.dm_db_index_physical_stats and I am really surprised by it's relative poor performance compared to DBCC.
I am...
"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 23, 2009 at 12:45 pm
If you're trying to check to see if a particular procedure is running at, say, noon, you can could query the sys.dm_exec_requests DMV to see if it's 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
March 23, 2009 at 8:28 am
No, it's not true. Depending on how you're calling nested queries you may not get the plan you think you'd get, as Gail outlined, but the plans will be created...
"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 23, 2009 at 7:10 am
I don't know if it's the best place to learn SQL Server from, but I do know that it's open on my desktop most days and it's the first place...
"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 23, 2009 at 7:04 am
I had copies of Ken Henderson's books on my desk at all times. But since I'm not working 2000 any more, I've had to switch to Kalen & Itzik's books...
"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 23, 2009 at 6:46 am
Leo (3/22/2009)
Hi Grant,I have a couple of questions here,
1. What about detach the database in 2000 and reattach in 2008? It should be okay, isn't it?
Sure. I just like...
"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 23, 2009 at 6:21 am
There's a decent, but inexpensive, single malt scotch called Sheep Dip. Great stuff.
"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 20, 2009 at 12:22 pm
Chris Morris (3/20/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 20, 2009 at 8:23 am
Luke L (3/20/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 20, 2009 at 8:20 am
It was introduced in 2008. There just is no equivalent in 2005.
"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 20, 2009 at 8:15 am
I haven't sat down to a hand-drawn real ale since 1993... so... I hate you all. I hope they have nothing left but Coors.
Luckily brew pubs are all over 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 20, 2009 at 7:30 am
Absolutely. Plus, I'm lazy. If I can pick something up for trying stuff out, that's what I'm going to do. I know there are lots of complaints about AdventureWorks... it'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
March 20, 2009 at 6:21 am
Viewing 15 posts - 17,956 through 17,970 (of 22,226 total)