Viewing 15 posts - 18,961 through 18,975 (of 22,226 total)
The primary key is the unique identifier in the table. That's it's primary purpose, a constraint on data so that each row is uniquely identified. However, it can also help...
"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
December 22, 2008 at 9:11 am
As you've already discovered, it's possible. I'm not sure I'd recommend it though. Take the time & trouble to create the databases, keep them small and then copy and use...
"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
December 22, 2008 at 7:00 am
Without at least an execution plan, we're just not going to be very specific in helping you.
Yeah, you might be accessing the clustered index, but you might not. It depends...
"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
December 22, 2008 at 6:54 am
Also that it's going to the right database. I've seen the default database used and it isn't immediately obvious.
"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
December 22, 2008 at 5:51 am
Paul (12/20/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
December 22, 2008 at 5:45 am
It's either a really poorly written query or you have blocking. You need to look at, at least, sp_who2.
Also, can you get the execution plan? Query sys.dm_exec_query_plans if you can'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
December 22, 2008 at 5:39 am
And best practices dictate that you don't use them in user defined tables. Nothing prevents you from doing it, but it's generally considered poor design and can, in some cases,...
"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
December 22, 2008 at 5:30 am
bitbucket (12/19/2008)
Then of course, I move on to Assistant Scoutmaster with the Troop. Lots of camping and hiking, which will be really cool.
Good luck in that position. 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
December 19, 2008 at 9:33 am
Steve Jones - Editor (12/19/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
December 19, 2008 at 8:48 am
ALZDBA (12/19/2008)
Grant Fritchey (12/19/2008)
DO NOT, I repeat, DO NOT, GO PUTTIN' FRUIT INTO MY GOL DURNED BEER.
Belgians... They get a couple of things right (double, triple, & saison (very...
"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
December 19, 2008 at 8:46 am
I just installed it from a network share. Nothing special. I'm not sure if you'd have something different or not. Since it's automated, it could be the automation is incorrect....
"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
December 19, 2008 at 8:13 am
I want to try this on my own, but I'm a bit busy. Has anyone tried querying sys.dm_exec_query_plan?
"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
December 19, 2008 at 8:12 am
Matt Miller (12/19/2008)
Grant Fritchey (12/19/2008)
jcrawf02 (12/19/2008)
Chris Morris (12/19/2008)
Someone said beer I swear...Nicest beer this week was Blue Moon wheat beer from Denver, CO, purchased from Sainsbury's, Reading, UK.
My sister-in-law is...
"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
December 19, 2008 at 8:10 am
A LAMBIC!!!!!
DO NOT, I repeat, DO NOT, GO PUTTIN' FRUIT INTO MY GOL DURNED BEER.
Belgians... They get a couple of things right (double, triple, & saison (very right)) and then...
"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
December 19, 2008 at 7:46 am
Since we've alredy deviated from movies, I'd also like to add Berserkers. They make Terminators look like wee small girls.
"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
December 19, 2008 at 7:41 am
Viewing 15 posts - 18,961 through 18,975 (of 22,226 total)