Viewing 15 posts - 21,826 through 21,840 (of 22,232 total)
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
Guiness is OK, still not as good as a real ale. Corona? Blech! The best beer out of Ol Mehico is Bohemia. Great stuff. Hold the friggin' lime.
"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 7:36 am
Actually, I haddn't thought of that, but yeah, in most cases this is probably quicker.
"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 6:02 am
Viewing 15 posts - 21,826 through 21,840 (of 22,232 total)