Viewing 15 posts - 20,206 through 20,220 (of 22,219 total)
ganatra.neha (6/6/2008)
That was bulls eye. You were rightThank you
I shall try and rewrite the queries and avoid the the multi-statement UDF
Thank you once again
Glad I could...
"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
June 6, 2008 at 12:51 pm
I don't see the attachment.
I'll bet you're working with a table valued function, probably a multi-statement function instead of an inline. Right?
If so, the optimizer doesn't and can't know 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
June 6, 2008 at 11:38 am
You'll have to do this from outside TSQL. I've done it two ways. First, write an app in .NET that opens threads and makes DB calls. It works, but 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
June 6, 2008 at 9:30 am
Enormous topic. I'm just getting going with Reporting Services myself. Short answer, SQL Server Business Intelligence Development Studio. Long answer... This is the book I'm starting to read.
"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
June 6, 2008 at 9:05 am
OK. That makes sense. I'm also not surprised it works like that. Thanks for the input.
"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
June 6, 2008 at 8:48 am
Another guy just asked for something similar over in the Development forum. I had the same answer for him. I kind of thought it might be possible in CLR. Is...
"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
June 6, 2008 at 8:25 am
The performance increase is pretty small in most cases, but it is there. It really depends though, if the data is fixed length, you should use CHAR/NCHAR for it. If...
"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
June 6, 2008 at 7:57 am
Honestly, that's a tough one.
Best approach I can recommend is to establish a very tight discipline around your main production builds. They should only be done by a script 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
June 6, 2008 at 7:51 am
Oh yeah, this is a major SQL Server tool if you can put it to work. Talk to Tom LaRock some time. He's gone way past where I am currently...
"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
June 6, 2008 at 7:12 am
That's what I mean when I say you have to learn how to work with the tool. I generally type 'SELECT * FROM' and then start building the FROM clause...
"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
June 6, 2008 at 7:09 am
Problem is, you can't do the CASE statement like that. You have to use an IF and this becomes a multi-statement query.
"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
June 6, 2008 at 7:06 am
Maybe you need to better define what you're looking for. ALZ's solution shows procedures that are running and how long they are taking. Determining whether or not a query is...
"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
June 6, 2008 at 6:18 am
A table valued function does require you to define the structure of the table. So, no, this won't work the way you want. I'm not at all sure, but I...
"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
June 6, 2008 at 6:10 am
I'm glad it was helpful.
"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
June 6, 2008 at 5:57 am
I haven't used JPA, but our developers have been making noises about nHibernate. I did some tests with it. The basic parameterized queries ran similarly to stored procedures. But 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
June 5, 2008 at 12:51 pm
Viewing 15 posts - 20,206 through 20,220 (of 22,219 total)