Viewing 15 posts - 4,276 through 4,290 (of 22,227 total)
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
Just curious, what about the right hand side? You can write a query that puts a function against a column on either side of the operand and it will behave...
"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:33 am
Hugo Kornelis (11/1/2016)
BWFC (11/1/2016)
I've got a barrel of cider maturing in the cellar, can I come?Just send the barrel. We'll review your application later. :Whistling:
SECOND!
All in favor?
"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 1, 2016 at 5:50 am
Bill Talada (10/31/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
October 31, 2016 at 12:33 pm
Here's a blog post [/url]from Microsoft on how to do this if you're not using AD. It's a little old, but the process is the same. You'll need to connect...
"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
October 31, 2016 at 7:48 am
As long as the checklists are for things we can't automate. I've seen many peoples checklists and thought, why don't you just automate the first six items.
"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
October 31, 2016 at 7:46 am
Jeff Moden (10/31/2016)
[font="Arial Black"]<sarcasm ON> [/font]everyone knows that it's the database that's the problem [font="Arial Black"]<sarcasm OFF>[/font], right?
Not at my old company. They actually had a running joke 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
October 31, 2016 at 7:17 am
Sean Redmond (10/31/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
October 31, 2016 at 7:13 am
Viewing 15 posts - 4,276 through 4,290 (of 22,227 total)