Viewing 15 posts - 17,671 through 17,685 (of 22,226 total)
I wouldn't recommend using this method in the WHERE or JOIN clauses of your queries, but for the SELECT list, instead of CASE statements, try this:
SELECT COALESCE(MyColumn,'') AS MyColumn
...
That will...
"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
April 21, 2009 at 6:24 am
You can also run it from Profier (Tools - Database Engine tuning Advisor) or from a SSMS query window (Query - Analyze Query in Database Enging Tuning Advisor).
"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
April 20, 2009 at 11:49 am
I agree with GSquared. Capture the query info and make decisions from there. The one other thing that you might concern yourself with is the volatility of the data 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
April 20, 2009 at 11:45 am
GilaMonster (4/20/2009)
Jack Corbett (4/20/2009)
"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
April 20, 2009 at 11:00 am
Jack Corbett (4/20/2009)
Bob Hovious (4/20/2009)
Although I have no preference, aren't they using VB with SSIS?
In 2005 yes, but in 2008 you can use C# as well. My current work...
"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
April 20, 2009 at 7:11 am
SQL Server is heavily involved on managing parallelism. It has to to merge the data from the various streams so, it does quite a lot of work.
"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
April 20, 2009 at 7:03 am
Krishna Potlakayala (4/18/2009)
fayilt (4/18/2009)
"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
April 20, 2009 at 6:34 am
Yes, you can follow the link provided above and download the book for free. It's also available in a dead-tree version from Amazon if you prefer reading from paper.
Also, you...
"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
April 20, 2009 at 6:31 am
Parallelism is an expensive process because of all the management that SQL Server has to do. So, you only want it to run on queries that are running long already...
"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
April 20, 2009 at 6:26 am
I'm not sure I understand the question. Are you trying to tune queries where there is a lot NULL columns?
If so, yes, this can be an issue in 2005 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
April 20, 2009 at 6:19 am
Bruce W Cassidy (4/19/2009)
Florian Reischl (4/18/2009)
What do you like more C# or VB.Net?
[font="Verdana"]For me personally I prefer C#. But you will probably find there's a bigger audience for VB....
"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
April 19, 2009 at 5:03 pm
It honestly depends on what the optimizer considers to be a trivial plan. Here's an explanation of how plans are determined: http://msdn.microsoft.com/en-us/library/aa226174.aspx
"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
April 18, 2009 at 4:53 am
Lynn Pettis (4/17/2009)
But sometimes you just have to get in there and beat some heads with that quarter staff. It ain't just for walking you know.
I actually missed 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
April 18, 2009 at 4:48 am
Jack Corbett (4/17/2009)
Lynn Pettis (4/17/2009)
But sometimes you just have to get in there and beat some heads with that quarter staff. It ain't just for walking you know.
Which 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
April 18, 2009 at 4:45 am
You can try joing to dm_exec_plan_attributes and see if the user_id is available for the plans you're interested in. It might not be.
"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
April 17, 2009 at 11:43 am
Viewing 15 posts - 17,671 through 17,685 (of 22,226 total)