Viewing 15 posts - 4,261 through 4,275 (of 22,219 total)
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
jasona.work (11/2/2016)
Luis Cazares (11/2/2016)
That said, can...
"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 11:54 am
Hugo, you are awesome!
It doesn't matter what everyone else says about you.
Kidding. Totally kidding. Thanks. A couple of comments inline.
Hugo Kornelis (11/2/2016)
Of course views are faster than stored...
"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 6:42 am
John Mitchell-245523 (11/2/2016)
Whoever is making these wacky claims, it's his or her case to make, not yours to rebut. If you're going to do a service to the community...
"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 6:35 am
OK, but just using the equals (=) as an example, you can put the column on either side of that and a variable, parameter, or hard coded value on the...
"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 6:04 am
I'd like to request a beating from the Threadizens.
I have a blog post[/url] that I'm informed doesn't adequately test the question I'm attempting to answer. You guys will likely recognize...
"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:50 am
Viewing 15 posts - 4,261 through 4,275 (of 22,219 total)