Viewing 15 posts - 6,076 through 6,090 (of 22,226 total)
AAAAAARRRRRRGGGGGGGHGHGHGHGHGHGH!!!!
"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 20, 2015 at 4:08 am
arrjay (5/20/2015)
So a restore will write to disk, and at a later date SQL will write the data to memory once the user starts querying 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
May 20, 2015 at 4:07 am
Also, look at your cost threshold for parallelism. If it's at the default value of 5, it needs to be bumped up.
"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 20, 2015 at 4:07 am
audiocool (5/19/2015)
Hi Grant,First of all, I would like to thanks for your effort for trying to help me on this.
Below is the output that you require:
Wait_Stat:
Query Stat
https://drive.google.com/file/d/0B7H-a08logDcdEY1WmY2bEo2Rlk/view?usp=sharing
Sorry. My fault. 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 20, 2015 at 4:03 am
audiocool (5/20/2015)
"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 20, 2015 at 3:42 am
It sounds like there are a lot of different problems going on here. I recognize that you're focused on the memory, but you need to step back from it. It...
"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 19, 2015 at 8:33 pm
SQLRNNR (5/19/2015)
If you are hiring for a senior position, you create an exam for the position, you require...
"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 19, 2015 at 9:41 am
butcherking13 (5/19/2015)
I'm curious about two...
"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 19, 2015 at 8:15 am
I've got a short article[/url] on all the steps to really ensure that your backups are 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 19, 2015 at 4:57 am
You'll have to test it, monitor it, and adjust as needed. That's the normal approach to any of this. I'm not even sure that I would mess with the fill...
"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 19, 2015 at 4:55 am
I'm not sure that any data types were added. You can see all the new features and functions in the Microsoft documentation.
"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 19, 2015 at 4:53 am
ramana3327 (5/18/2015)
In that case we need to take everyday full backup right?Currently we have weekly full backup & 15 min log backups.
Jeff didn't say to throw away differentials, just 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
May 19, 2015 at 4:35 am
audiocool (5/19/2015)
I knew that no matter if I pump in more RAM to the new SQL Server, it will just slowly consume it compare to current situation.
For my case,...
"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 19, 2015 at 4:32 am
Lynn Pettis (5/18/2015)
Michael L John (5/18/2015)
Jeff Moden (5/18/2015)
andrew gothard (5/18/2015)
Jeff Moden (5/14/2015)
Me, the interviewer: As the Lead Developer on this project, we're very interested in...
"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 18, 2015 at 10:21 am
audiocool (5/18/2015)
I'm not sure whether...
"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 18, 2015 at 10:18 am
Viewing 15 posts - 6,076 through 6,090 (of 22,226 total)