Viewing 15 posts - 14,641 through 14,655 (of 22,219 total)
Jeff Moden (7/14/2010)
"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
July 15, 2010 at 5:47 am
Paul White NZ (7/15/2010)
Fraggle-805517 (7/14/2010)
Paul,That works perfect. Thank you very much. That will solve the problem.
Fraggle.
Good. By the way, I think Grant was thinking of the system...
"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
July 15, 2010 at 5:38 am
There are multiple ways you could do that. Personally, I'd go with using PowerShell from the 2008 server. You can issue file commands to copy the file and then issue...
"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
July 15, 2010 at 5:38 am
SwedishOrr (7/14/2010)
"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
July 15, 2010 at 5:32 am
Is the SQL Server 2005 a 64 bit install? If it's a 32 bit version, it'll be trying to load the 32 bit version of the commandlet. I've run into...
"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
July 14, 2010 at 2:52 pm
Whew! Standard deadlock. You've got INSERT & DELETE statements in there. So the deadlocks are not from the shared locks alone. There's more at work, a lot more.
So, standard questions...
"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
July 14, 2010 at 2:46 pm
Novicejatt (7/14/2010)
"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
July 14, 2010 at 12:41 pm
Novicejatt (7/14/2010)
"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
July 14, 2010 at 11:54 am
doobya (7/14/2010)
even your post said "seems" do you know what ambiguous means?
And on that note, I'm calling troll and dropping this thread. It's been enlightening. Ya'll have fun.
"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
July 14, 2010 at 11:45 am
Are you sure you're in SQL Server 2005? I just connected up to one of our 2005 instances, ran it and got back information. It's right there in the DB....
"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
July 14, 2010 at 7:12 am
Auditing is a way of tracking the changes in data over time. If all you're interested in is seeing activity and performance, I'd stick with using Profiler and server-side trace.
Also,...
"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
July 14, 2010 at 6:09 am
Also, it's worth noting, there are pretty vast differences between 2000 and 2008. You need to be sure that your 2000 database is compatible with 2008. If you have not...
"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
July 14, 2010 at 6:05 am
In addition to what Ron notes, spend the time to learn T-SQL. Access querying and T-SQL querying are just not the same.
"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
July 14, 2010 at 6:02 am
No, that's normal. What you'll see is that when updates are occurring, a version of the row is stored off in tempdb and that will be used instead of 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
July 14, 2010 at 6:01 am
CirquedeSQLeil (7/13/2010)
Jim McLeod (7/13/2010)
CirquedeSQLeil (7/13/2010)
Grant Fritchey (7/13/2010)
This document sounds like it's a doozy.That's an understatement.
On the plus side, it is providing me with good fodder for a blog post.
I love...
"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
July 14, 2010 at 5:34 am
Viewing 15 posts - 14,641 through 14,655 (of 22,219 total)