Viewing 15 posts - 11,881 through 11,895 (of 22,219 total)
What do you mean by current record?
"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
September 8, 2011 at 9:48 am
Jack Corbett (9/8/2011)
I believe I'll be seeing Grant on...
"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
September 8, 2011 at 8:02 am
Jack Corbett (9/8/2011)
I believe I'll be seeing Grant on...
"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
September 8, 2011 at 8:01 am
There isn't a switch or setting that creates an archive. You have to create a second database, or a second set of tables within your database, and then migrate 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
September 8, 2011 at 7:48 am
If you have to program this, I'd say the best way would be to use SMO. It has the ability to generate scripts in a very sophisticated manner. If 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
September 8, 2011 at 7:47 am
Ninja's_RGR'us (9/8/2011)
SwayneBell (9/8/2011)
Grant Fritchey (9/7/2011)
https://www.livemeeting.com/cc/8000181573/join?id=33Z39D&role=attend&pw=f%5E%3E2mzT7H
I'm going on at 2300GMT or 7:00PM EDT
https://www.livemeeting.com/cc/8000181573/join?id=69K9DZ&role=attend&pw=f%5E%3E2mzT7H
You'll get close to 2 out of 7 hours...
"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
September 8, 2011 at 6:47 am
First, go to the Microsoft and get the 2008 Upgrade Advisor. Run it against your 2005 database. If there are any major issues, it will identify them. Otherwise, it's an...
"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
September 8, 2011 at 5:36 am
Roy Ernest (9/7/2011)
Grant Fritchey (9/7/2011)
https://www.livemeeting.com/cc/8000181573/join?id=33Z39D&role=attend&pw=f%5E%3E2mzT7H
I'm going on at 2300GMT or 7:00PM EDT
https://www.livemeeting.com/cc/8000181573/join?id=69K9DZ&role=attend&pw=f%5E%3E2mzT7H
You'll get close to 2 out of 7 hours...
"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
September 7, 2011 at 1:28 pm
You all know Gail is on right now? She's doing great:
https://www.livemeeting.com/cc/8000181573/join?id=33Z39D&role=attend&pw=f%5E%3E2mzT7H
I'm going on at 2300GMT or 7:00PM EDT
https://www.livemeeting.com/cc/8000181573/join?id=69K9DZ&role=attend&pw=f%5E%3E2mzT7H
You'll get close to 2 out of 7 hours of our precon this...
"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
September 7, 2011 at 12:27 pm
When you create a foreign key, it's a constraint, not an index. If you want an index on a foreign key, that must be created separately.
You can look at 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
September 7, 2011 at 5:48 am
Schadenfreude-Mei (9/7/2011)
SwayneBell (9/7/2011)
Grant Fritchey (9/7/2011)
Oh no, really? I thought she was only writing to me. Our relationship was built on a lie <sob>.
I was disappointed too Grant, what with 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
September 7, 2011 at 5:45 am
Oh no, really? I thought she was only writing to me. Our relationship was built on a lie <sob>.
"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
September 7, 2011 at 3:51 am
Sounds like something going wrong on the Windows Server. Have you checked there for errors?
"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
September 7, 2011 at 3:50 am
ravindranath.s (9/7/2011)
SELECT DISTINCT UPP.ProductID,dbo.fnGetProductTestStatus(UPP.ProductID,@UserID) AS EndDate ,
FROM #UserProductProgression UPP
when i say 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
September 7, 2011 at 3:48 am
Also, you're saying "similar" data sets, not identical data sets. Similar can be pretty radically different depending on the data distribution.
Also, no mention of any measure for contention. Are 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
September 7, 2011 at 3:40 am
Viewing 15 posts - 11,881 through 11,895 (of 22,219 total)