Viewing 15 posts - 12,436 through 12,450 (of 22,224 total)
Congratulations Grand Dad!
"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
June 6, 2011 at 1:11 pm
I'm a surrogate key fan too. I do tend to treat them like natural keys on the child tables. I was taught a mechanism where the master tables are are...
"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
May 29, 2011 at 5:29 pm
You're right, this can be practically a religious war.
In general, I've found that identity works well, but can be abused. In the situation you're describing for example, I'd go 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
May 29, 2011 at 6:39 am
WayneS (5/28/2011)
Grant Fritchey (5/28/2011)
WayneS (5/28/2011)
Jim Murphy (5/27/2011)
"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
May 29, 2011 at 6:26 am
WayneS (5/28/2011)
Jim Murphy (5/27/2011)
"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
May 28, 2011 at 10:04 am
And to you!
First time in years I won't be marching in the parades in town with the Scouts. Stupid Alaska cruise.
"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
May 28, 2011 at 10:01 am
Sounds like you set it up to log in as 'sa' and you don't have the password correctly entered. You may need to try the install again. Pay attention 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
May 28, 2011 at 6:04 am
If you're moving up to 10TB systems and you haven't handled that level before, I'd strongly recommend getting some consulting help in on your project. Anything past 1-2TB requires specialized...
"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
May 28, 2011 at 4:18 am
Piling on for just a moment, but you need to know this, all those functions running in your columns is going to prevent any indexes on those tables from being...
"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
May 28, 2011 at 4:15 am
I'd guess either differences in data or statistics being out of date on one of the servers. Hard to say without seeing the execution plans.
"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
May 28, 2011 at 4:13 am
Performance tuning is a large topic. Gail Shaw has some excellent articles[/url] on Simple-Talk. I'd start there. Once you've got those under your belt, pick up a copy of my...
"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
May 28, 2011 at 4:09 am
So don't use sp_who2. That's the old approach anyway. Dive into the DMOs and get lots of good information.sys.dm_exec_requests will show you what's currently running. You can combine that 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
May 28, 2011 at 4:06 am
Roy Ernest (5/27/2011)
WayneS (5/27/2011)
GilaMonster (5/27/2011)
Precon and spotlight! Could this PASS Summit get any better?So, you're aiming for a keynote address now?
Along with Dr DeWitte
She'll probably start correcting him.
"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
May 27, 2011 at 3:27 pm
Your trigger needs to be on the child table and it needs to say "UPDATE Parentable..." in order for the parent table to be updated.
"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
May 27, 2011 at 6:19 am
Modify the procedure that updates the child table so that it also updates the parent table. That'd be my first approach. You could also look at setting up a trigger...
"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
May 27, 2011 at 5:55 am
Viewing 15 posts - 12,436 through 12,450 (of 22,224 total)