Viewing 15 posts - 8,956 through 8,970 (of 22,226 total)
Don't do the ISNULL mechanism. That's going to lead to straight table scans and will not help your performance at 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 10, 2014 at 5:16 pm
If you do want the equivalent of the default trace, but you want to control it more directly, I'd suggest taking a look at extended events. You can have them...
"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:14 pm
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
Viewing 15 posts - 8,956 through 8,970 (of 22,226 total)