Viewing 15 posts - 8,956 through 8,970 (of 22,224 total)
At best, buffer count hit ratio is just an indication of load. And, as you see with Jonathan's test, it's not even necessarily that. Yeah, a very low number 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
February 10, 2014 at 5:13 pm
SQLRNNR (2/7/2014)
jasona.work (2/7/2014)
SQLRNNR (2/7/2014)
ChrisM@Work (2/7/2014)
Anybody else seeing a kinky image of Koen, Gail and Grant wondering around without their tshirts?
Kinky??
Um no. Just got back from SQLCruise with Grant and...
"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
February 7, 2014 at 8:36 am
wolfkillj (2/7/2014)
ChrisM@Work (2/7/2014)
Anybody else seeing a kinky image of Koen, Gail and Grant wondering around without their tshirts?
Word is that there are photos of a shirtless Grant from SQL Cruise,...
"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
February 7, 2014 at 7:40 am
Koen Verbeeck (2/7/2014)
GilaMonster (2/7/2014)
Koen Verbeeck (2/7/2014)
Ed Wagner (2/7/2014)
"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
February 7, 2014 at 7:21 am
g.mclachlan (2/7/2014)
We are a National Library and 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
February 7, 2014 at 6:33 am
Thanks. That was a fun discussion. Greg is a great guy.
"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
February 7, 2014 at 4:16 am
EXACTLY!
It's going to be a hybridized world, partially hosted locally, partially externally, and partially through various services. It's happening right now and shows every sign of accelerating. I am all...
"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
February 6, 2014 at 5:08 am
TheSQLGuru (2/5/2014)
Grant Fritchey (2/5/2014)
"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
February 5, 2014 at 9:30 am
Assuming I understand the question, yes, that's not only possible, it's the right way to get the job done.
"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
February 5, 2014 at 8:37 am
But the FAST (50) hint is also going to impact what gets delivered by the optimizer. It's likely to see what you're seeing, a seek where a scan would serve...
"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
February 5, 2014 at 6:10 am
The update statement you have is modifying the row where the ID = 9. If you want to move the value from 27 to 9, try writing an UPDATE FROM...
"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
February 5, 2014 at 6:05 am
If you know you have a query that is causing performance problems, I'd start by looking at the code to see any of the common issues and then I'd look...
"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
February 5, 2014 at 6:03 am
I have used, as a DBA, Idera, Spotlight, Foglight, Operations Manager and SQL Monitor. Currently, I work for Red Gate, so my view might be a little biased. All these...
"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
February 5, 2014 at 5:58 am
Not sure without seeing what is being blocked. One recommendation, get rid of the drop table statement entirely. Let SQL Server clean it up on its own. Not saying that...
"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
February 5, 2014 at 5:45 am
On any query while looking at the execution plan, the costs will add up to about 100% (sometimes a little less, occasionally a lot more, it's a bug). So seeing...
"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
February 5, 2014 at 5:37 am
Viewing 15 posts - 8,956 through 8,970 (of 22,224 total)