Viewing 15 posts - 7,816 through 7,830 (of 22,219 total)
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
Kwisatz78 (7/2/2014)
I actually have your book SQl Server 2012 Performance Tuning. The flow of the book seems to be arming the reader with techniques for tuning queries followed...
"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:24 am
All performance tuning should start at the server. Ensure the server is well-configured first. Then start gathering metrics, again, at the server level to start. Wait stats, etc. Be sure...
"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 5:07 am
Back to your basic argument, I'm with you. Using the language in the standard mechanism by default is usually the better approach. There are any number of valid reasons 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 2, 2014 at 3:41 am
GilaMonster (7/2/2014)
wilks (7/2/2014)
I had misunderstood the scan count from IO statistics, I see now it can refer to an index or table scan.
No, it doesn't. It is not a count...
"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 3:39 am
You could capture a lot more information using extended events. You can usually capture machine name and other information with it. I'm not sure which event I'd set this 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 3:33 am
Viewing 15 posts - 7,816 through 7,830 (of 22,219 total)