Viewing 15 posts - 6,061 through 6,075 (of 22,211 total)
AAAAAARRRRRRGGGGGGGHGHGHGHGHGHGH!!!!
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...
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.
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...
May 20, 2015 at 4:03 am
audiocool (5/20/2015)
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...
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...
May 19, 2015 at 9:41 am
butcherking13 (5/19/2015)
I'm curious about two...
May 19, 2015 at 8:15 am
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...
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.
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...
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,...
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...
May 18, 2015 at 10:21 am
audiocool (5/18/2015)
I'm not sure whether...
May 18, 2015 at 10:18 am
Viewing 15 posts - 6,061 through 6,075 (of 22,211 total)