Viewing 15 posts - 9,226 through 9,240 (of 22,219 total)
Sigerson (12/18/2013)
Yes it was homework, but I thank you for taking your time to craft such a gracious (and clear!) answer. Some posters here scorn helping students and I've...
"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 18, 2013 at 8:10 am
I'm with Gail. It sounds like statistics to me.
"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 18, 2013 at 5:02 am
You may also want to take a look at Extended Events within SQL Server. You can set them up to capture all the queries that are run against 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
December 18, 2013 at 5:00 am
Yeah, it sounds like the account that it's running under doesn't have access. Validate which account is running Agent. Make sure it's an account with access to your network and...
"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 18, 2013 at 4:49 am
Unless you need to learn hybrid environments, I wouldn't bother setting up a system at home any more. Do you have access to an MSDN license through work? If so,...
"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 18, 2013 at 4:47 am
In my youth, I loved getting involved with online arguments. For some reason, as I've aged, I just walk away from the goofy things. To a degree, this feels 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
December 17, 2013 at 8:26 pm
inevercheckthis2002 (12/17/2013)
I thought...
"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 17, 2013 at 10:05 am
I'd suggest getting a copy of my book. I go through all the information you're asking in great detail. The 2008 version is more applicable for your 2005 instance, but...
"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 17, 2013 at 10:00 am
defyant_2004 (12/17/2013)
"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 17, 2013 at 9:59 am
I know there is a way to do it, yes, but I'm not familiar with it. It's actually something I need to spend some time getting my arms around and...
"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 17, 2013 at 9:49 am
KumarVelayutham (12/17/2013)
Based on my understanding,Microsoft assessment and planning tool will help to get the load and all details for each and every server.Is it right?
Not at all.
As Richard says, you'll...
"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 17, 2013 at 6:27 am
Honestly, I can't.
How much CPU does each of those servers use? If one is maxed out on memory, we probably don't want to put it into a VM, but from...
"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 17, 2013 at 5:39 am
I have to ask, how, possibly, from a listing of servers could I tell you which of the databases on those servers would need mirroring? How could I? Possibly? Further,...
"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 17, 2013 at 5:25 am
The restore won't change the compatibility level, you have to do that as a second step.
Even if you create the database in 2012, when you restore the 2005 backup, 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
December 17, 2013 at 5:19 am
chandan_jha18 (12/17/2013)
Grant Fritchey (12/17/2013)
If the table has 100K of records, this looks like it's also returning over 100K of records. Is the WHERE clause not filtering...
"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 17, 2013 at 4:17 am
Viewing 15 posts - 9,226 through 9,240 (of 22,219 total)