Viewing 15 posts - 7,816 through 7,830 (of 22,224 total)
Backups work in 2014, so we'll need more information. I would suggest you install the cumulative updates though. They fix some pretty serious bugs.
"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
July 3, 2014 at 8:03 am
vsamantha35 (7/3/2014)
... make up a story ...
Let me first assume this is just an "English as a second language" moment and point out that "make up a story" would mean...
"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
July 3, 2014 at 7:35 am
Sometimes I wish I could just vote for answers here.
Karen has the cause, Sean has the solution.
"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
July 3, 2014 at 7:29 am
Who says it needs correcting? PLE < 300 is not necessarily a bad thing. It could be that your system just has a highly volatile memory use. I'd want 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
July 3, 2014 at 7:11 am
And... what's the question? Ha!
That would have made a great blog post.
"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
July 3, 2014 at 7:05 am
If a process has timed out, you won't see blocking now. There may have been blocking during the process. Depending on how long things were running, I'd suggest taking 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
July 3, 2014 at 7:03 am
Views aren't just for security. They're basically a mechanism that is used to mask structures. This may be for security. It may also be for backwards compatibility for an application....
"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
July 3, 2014 at 7:01 am
quackhandle1975 (7/3/2014)
Have you tried to contact the interviewer to find out why he wasn't impressed with your answer? That would be my first action.qh
That might not work well. Back...
"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
July 3, 2014 at 6:49 am
I'd suggest looking at the wait statistics. It might just be CPU, but sometimes a problem with I/O or memory can show up as CPU. You may also need 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
July 3, 2014 at 5:47 am
A safe recovery from a possible outage is a great story. I'm not sure why they were unimpressed. Maybe it was delivery. Maybe they were hoping for something more spectacular....
"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
July 3, 2014 at 5:34 am
Lynn Pettis (7/2/2014)
TheSQLGuru (7/2/2014)
Users - BAHHH!!! Who needs 'em?!? 😀Yea, our databases would perform so much better without them! :w00t:
And the queries would run even faster if we could...
"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
July 2, 2014 at 12:49 pm
Kwisatz78 (7/2/2014)
In regards...
"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
July 2, 2014 at 9:04 am
Did you hear, for a little while Tim Howard was listed on Wikipedia as the US Secretary of Defense. That's awesome.
"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
July 2, 2014 at 8:01 am
yeah, I don't have a precise checklist that I use. I'm not sure of one either. Brad McGeehee may have one.
"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
July 2, 2014 at 7:33 am
All things you need to do when designing a database fills books. In fact, if you're just getting started at database design, I'd strongly recommend reading a bunch of books....
"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
July 2, 2014 at 6:45 am
Viewing 15 posts - 7,816 through 7,830 (of 22,224 total)