Viewing 15 posts - 21,811 through 21,825 (of 22,219 total)
Forgive us our typos. Absolutely. The most you'd get gigged for only going to 99 is some good natured ribbing about being premature or something.
It's amazing how much discussion what...
"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
May 29, 2007 at 5:39 am
Yikes.
I haven't seen that many GOTO's in quite a while. Nice job.
"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
May 29, 2007 at 5:26 am
WOO HOO!
A CLR solution. Thanks Adam.
"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
May 29, 2007 at 5:25 am
Absolutely more appropriate languages than SQL. I'm not serious about putting this on an interview. This was just some geek fun that we had one morning at work. Actually we...
"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
May 29, 2007 at 5:22 am
Oh boo. That's so procedural. Not set based at all.
What? Are you some kind of developer or something?
Nice job though.
"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
May 29, 2007 at 5:15 am
I had this query from Itzik too. I didn't want to use it in relation to the article. It works really well for populating a table of numbers, which, 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
May 29, 2007 at 5:14 am
WHOA!
Great post. Very nice solution. Scalable. That was something I honestly hadn't thought of. We were just having fun with the problem statement. But, in my, and my co-worker's, defense,...
"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
May 29, 2007 at 5:12 am
Nice query, violated the rules though.
"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
May 29, 2007 at 5:05 am
Nice. I like it. Simple, clean. Good job.
"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
May 29, 2007 at 5:04 am
I wouldn't recommend passing executable strings to the database just because each execution gets it's own plan. You want the system to reuse plans. Most of the time, in most...
"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
May 24, 2007 at 6:36 am
No arguments there. We had a proc that was so poorly written that it took about 3 minutes to recompile. It too was called thousands of times a minute 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
May 24, 2007 at 6:29 am
And, if you do decide to split them, you can still use the original proc as a wrapper around the other two so that you don't have to re-write your...
"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
May 24, 2007 at 5:25 am
I think you've already answered your own question. If the optimizer can generate a plan that kills performance then you need a method to avoid this. You could try forcing...
"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
May 23, 2007 at 5:20 am
This is a part of Analysis Services. According to the books online you can turn this off through the Properties of the server in SSMS.
"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
May 23, 2007 at 5:13 am
I did tech support for a bank in the early 90's and had to wear a suit & tie while pulling cable and crawling under desks. Dumbest damn thing in...
"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
May 22, 2007 at 8:48 am
Viewing 15 posts - 21,811 through 21,825 (of 22,219 total)