Viewing 15 posts - 8,341 through 8,355 (of 22,224 total)
Since it's a dev box, I'd just do an in-place upgrade. I recently did one for my 2012 system to move it to 2014. It just worked. You do have...
"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
April 28, 2014 at 4:22 am
Excellent! Happy to share.
"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
April 25, 2014 at 6:57 am
They may be saying that, but you can't store data in the proc cache. You can't. It's an internal system memory space completely managed by SQL Server. It's not something...
"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
April 24, 2014 at 2:16 pm
Good to hear you have it all figured out. When operating with two different databases like that, another thing to keep an eye on is the statistics.
"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
April 24, 2014 at 2:12 pm
One of the best resources I've found on getting started with the in-memory databases. Tons of links to good articles.
"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
April 24, 2014 at 2:10 pm
Start with the Microsoft documentation. Always start with the Microsoft documentation. But, there are also 3rd party resources such as Tim Ford and Louis Davidson's excellent book.
"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
April 24, 2014 at 2:08 pm
Frequently, yes. Because you're going to lavish attention on that instance, know when it's running, possibly set up some type of high availability for it, etc. Yes, if you have...
"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
April 24, 2014 at 4:20 am
You're talking Azure VMs, not SQL Azure which is the platform as a service offering, not infrastructure.
As far as disks go, the only ones available currently are through Azure blob...
"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
April 23, 2014 at 3:28 pm
You're comparing apples to hammers.
The procedure cache within SQL Server is for caching query execution plans for the queries running within SQL Server. It does this to avoid recompiling queries...
"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
April 23, 2014 at 12:29 pm
The best thing to do is not share resources with anything. sQL Server just doesn't play well with others. But, it doesn't sound right that just reducing the amount 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
April 23, 2014 at 12:25 pm
You can use a statement level trace event, but, be very cautious because those generate a ton of data and might have a negative impact on performance, even 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
April 23, 2014 at 12:22 pm
Differences in statistics are the more common explanation for differences in 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
April 23, 2014 at 12:20 pm
If the files are "locked" it sounds like a SQL Server instance is actively using them. You may want to look into the process for taking a database backup 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
April 23, 2014 at 12:18 pm
rodjkidd (4/23/2014)
I'm over for some more SQL Skills training, so thought I might as well attend.
Looks as though a...
"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
April 23, 2014 at 10:30 am
You sure it's a complete rebuild? Nothing has inserted a row? It's not doing an incremental build? The behavior is pretty consistent from what I've seen. But then, if 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
April 23, 2014 at 8:19 am
Viewing 15 posts - 8,341 through 8,355 (of 22,224 total)