Viewing 15 posts - 19,756 through 19,770 (of 22,219 total)
GilaMonster (8/12/2008)
Grant Fritchey (8/12/2008)
I'm on the way home, I'll try to set up a test tomorrow.I saved you the trouble.
http://sqlinthewild.co.za/index.php/2008/08/12/views-or-functions/
Too late. I ran up a silly example and posted...
"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
August 13, 2008 at 6:22 am
riix (8/12/2008)
"Just watch the performance implications. A single statement tvf is usually fine, the multi-statement ones...
"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
August 13, 2008 at 6:11 am
I'm on the way home, I'll try to set up a test tomorrow. You can see a huge difference in only a few hundred rows. Multi-statement UDF's are just 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
August 12, 2008 at 1:48 pm
Gail, I can tell you do softer style martial arts because your response is much more a redirect of his energies than mine would have been. Very nice.
riix, try this,...
"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
August 12, 2008 at 1:43 pm
The thing is, most people on the thread, just about everyone on the thread, that suggested using TSQL cursors was a bad thing didn't say "THOU SHALT NEVER USE 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
August 12, 2008 at 1:01 pm
You can't do that in 2000.
"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
August 12, 2008 at 12:11 pm
Go for it. The more knowledge that gets out there, the better.
"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
August 12, 2008 at 11:59 am
Thanks.
I've been remiss in my writing just lately (Tom, who I'm supposed to be working with, is going to kick my butt). There will be another OpsMgr article in 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
August 12, 2008 at 11:44 am
Lots of cursing. If you run out of good words, let me know. I used to be a sailor.
😉
"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
August 12, 2008 at 10:04 am
I can't come up on Saturday, but I can get there early on Sunday. If that fits the agenda, let me know.
"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
August 12, 2008 at 10:03 am
Steve Jones - Editor (8/12/2008)
Heck, I used to enjoy karate tournaments.Easy to tell who wins when only one is still standing 😉
That's the old days. Now, most karate tournies, it's...
"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
August 12, 2008 at 9:49 am
Here's the bad news, the amount of good information in a single source on writing custom reports in OpsMgr is even less than that for programming against it.
Have fun!
"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
August 12, 2008 at 9:45 am
You were running a query that moved 390 gb of data in 15 minutes? That's the estimated data size from the execution plan. Overall, the plan doesn't look too bad....
"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
August 12, 2008 at 7:36 am
I don't see anything immediately visible that would prevent you from creating that constraint. Can you post the scripts to recreate the tables? There may be a constraint of some...
"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
August 12, 2008 at 7:28 am
Hopefully, you're right. It does seem like this one may have missed a point or two. Something to keep in mind for the next one.
"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
August 12, 2008 at 7:18 am
Viewing 15 posts - 19,756 through 19,770 (of 22,219 total)