Viewing 15 posts - 4,261 through 4,275 (of 22,224 total)
Assuming we're talking about an inline table function, that's the approach I would use. If you're looking at the multi-statement table valued function, I would caution against it.
Be careful. You're...
"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
November 5, 2016 at 4:34 am
I don't know if you're on 2008 or 2008R2, but if the latter, you should explore using traceflag 2371. It makes a huge difference for lots of people when dealing...
"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
November 4, 2016 at 7:21 am
I agree 100% with Gail. To do this accurately, you need to have monitoring in place.
However, you could look to the Dynamic Management View, sys.dm_exec_query_stats. That does have the last...
"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
November 4, 2016 at 6:46 am
And since you have NOLOCK everywhere, it's worth pointing out that the use of NOLOCK can lead to missing or extra rows in your query. Be very cautious in how...
"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
November 4, 2016 at 6:40 am
There are a bunch of people around here with that kind of experience. What's the question?
"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
November 3, 2016 at 1:24 pm
Hugo Kornelis (11/3/2016)
Grant Fritchey (11/3/2016)
Steve Jones - SSC Editor (11/3/2016)
Hugo Kornelis (11/2/2016)
Hi Grant,Of course views are faster than stored procedures. And that cars are faster than laptops.
Ah, laptops can be...
"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
November 3, 2016 at 10:53 am
Steve Jones - SSC Editor (11/3/2016)
Hugo Kornelis (11/2/2016)
Hi Grant,Of course views are faster than stored procedures. And that cars are faster than laptops.
Ah, laptops can be just as fast as...
"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
November 3, 2016 at 10:42 am
It's either someone reseeding or it's someone doing an identity_insert to your data. Neither is good, but both should be under your control.
"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
November 2, 2016 at 5:55 pm
Yes, you should upgrade to SSMS 2014. Backwards compatibility is largely ensured within SSMS, so 2012 will work with 2008R2, 2008, 2005 and 2000. However, forward compatibility is absolutely not...
"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
November 2, 2016 at 5:21 pm
If by out of sync you mean that the numbers look like:
1,2,3,17,18,19
That can be from two causes. Either deletes, or, more likely, rollbacks. If an insert fails, the identity value...
"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
November 2, 2016 at 5:18 pm
If the database is passing a consistency check, then it's something in your apps that's doing that. It could be a trigger though. I'd check that too.
"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
November 2, 2016 at 4:07 pm
The question for me is, if that index really is superior, what was keeping the optimizer for choosing it. It does happen on occasion that the optimizer won't choose 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
November 2, 2016 at 4:05 pm
Ed Wagner (11/2/2016)
"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
November 2, 2016 at 3:16 pm
GilaMonster (11/2/2016)
Grant Fritchey (11/2/2016)
Do I need to explain a 5 micro-second difference
No. That's well into the range of measurement inaccuracies. If you could check my blog (which you can't at...
"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
November 2, 2016 at 3:13 pm
Grant Fritchey (11/2/2016)
jasona.work (11/2/2016)
Luis Cazares (11/2/2016)
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
November 2, 2016 at 12:13 pm
Viewing 15 posts - 4,261 through 4,275 (of 22,224 total)