Viewing 15 posts - 8,221 through 8,235 (of 22,224 total)
I would assume you get the disk so that you can adjust the services on offer on the server. I've never tried adding a second instance. I'll check with some...
"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 9, 2014 at 6:22 am
What you have in diagram 1 is a definition of an index and the balanced tree, or b-tree, that defines. Yes, each little box in that diagram is a page...
"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 9, 2014 at 5:56 am
I'd probably go to PowerShell to run this. It's pretty easy to set the command to connect to the other server and run a restore operation. It's also very easy...
"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 9, 2014 at 5:48 am
You can only do that if you have a license for an additional SQL Server instance and your own product key. The money you're paying for on the VM 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 8, 2014 at 5:04 pm
Yes.
Seriously though, each one is more efficient in a given situation. If both data sets are ordered, the Merge join is extremely efficient. If you have a smaller set of...
"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 8, 2014 at 3:50 pm
My suggestion would be to examine the execution plans for your queries before and after you apply your index. Just because the DTA suggested it, doesn't mean it's a good...
"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 8, 2014 at 10:30 am
shahgols (5/7/2014)
... the execution plan cost is down 2/3...
Which is a meaningless measure. The costs within execution plans are only applicable within themselves. I would never compare execution plan cost...
"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 8, 2014 at 6:10 am
Yeah, not sure. Just following where the error messages lead.
"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 8, 2014 at 6:08 am
Complete agreement with what Gail is suggesting.
"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 8, 2014 at 6:07 am
arkiboys (5/8/2014)
as I send this text I have your book with me.
infact I carry your book in my bag every day as it is a useful book.
ok. I will...
"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 8, 2014 at 6:06 am
And all this advice just points out how difficult it is to provide a good answer to such vague & general questions.
I hope all this helps. You've received great pointers.
"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 8, 2014 at 6:03 am
Jonathan's advice here [/url]would still be completely applicable to virtual machines, whether they're running in the cloud or 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
May 8, 2014 at 3:05 am
Last batch means the last time it was run, not the amount of time it's been running.
It's the checkpoint operation. That's a fundamental part of the process. It's actually what...
"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 7, 2014 at 2:46 pm
The time it takes really depends on the system you're installing it to, the stuff you choose to install, the size of your databases, a ton of stuff that 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
May 7, 2014 at 2:36 pm
Not sure about the encryption. I'm not sure why that would affect performance much at all (a little in the CPU I suppose).
As to figuring out how the server 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
May 7, 2014 at 12:47 pm
Viewing 15 posts - 8,221 through 8,235 (of 22,224 total)