Viewing 15 posts - 6,631 through 6,645 (of 22,221 total)
Assuming no data manipulation, you might also be able to use a scalar function. Due caution, testing, your mileage may vary, etc. But, it'll make the code a lot easier...
"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
March 9, 2015 at 6:37 am
Bouke Bruinsma (3/9/2015)
You might try creating a few views to break up the query.
I myself an against views altogether. The current view is part of an application. I can change...
"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
March 9, 2015 at 6:34 am
Without seeing the query and the plan, just speculation, but, timeout means that the optimizer went through the number of optimizations that it determined should arrive at a good enough...
"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
March 9, 2015 at 6:31 am
First option, use a table valued parameter. Here's documentation on how that works.
Another option, use Jeff Moden's scripts to turn comma delimited lists into a table. Here's documentation[/url] on 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
March 9, 2015 at 6:26 am
Your process is not hung on CPU. You may need more memory, faster, or more, disks, or a faster network. You can use sys.dm_os_wait_stats to understand what precisely is causing...
"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
March 9, 2015 at 6:24 am
Eirikur Eiriksson (3/6/2015)
"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
March 7, 2015 at 1:48 am
Lynn Pettis (3/1/2015)
I am HOME!I had a nice dinner at Kassondra's house. I'm sorry, nothing beats good home cooking!
Well done sir.
"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
March 2, 2015 at 10:20 pm
Pretty much what Jeff says. Actually, that's just a good rule to live by.
"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
March 1, 2015 at 10:12 pm
Lynn Pettis (3/1/2015)
Okay, getting close to boarding time. I am going to go dark. Next time I get on I will be home in beautiful Colorado Springs, Colorado
WHOOP!
That'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
March 1, 2015 at 10:10 pm
Lynn Pettis (3/1/2015)
Brandie Tarvin (3/1/2015)
Lynn Pettis (3/1/2015)
By the way, I'm in Atlanta waiting for my flight to SLC.YAY! Welcome back to the U.S. of A., Lynn.
Thank you. It is good...
"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
March 1, 2015 at 7:40 am
ANn -425914 (2/27/2015)
for indexes, does the order of column matters?
For example I want to create an index of ID, SchoolID, on terms table.
Does the order of...
"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
February 28, 2015 at 12:05 pm
Jeff Moden (2/27/2015)
Lynn Pettis (2/27/2015)
ZERO DAY! Leaving Afghanistan!Going Dark!
Zero bottles of beer on the wall.
Zero bottles of beer!
For those that roam,
Just come on home,
To one hundred bottles...
"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
February 28, 2015 at 12:00 pm
Jeff Moden (2/27/2015)
Grant Fritchey (2/27/2015)
Instead, I'd go with a more standard approach:Heh... why? Portability? 😛
Yes Joe.
"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
February 28, 2015 at 11:59 am
The whole idea around "best practices" is not that they fit in ALL circumstances, but that they fit in MOST circumstances (and most is substantially higher than 50.00001%). Of course...
"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
February 28, 2015 at 11:59 am
sql-lover (2/27/2015)
djj (2/27/2015)
Grant Fritchey (2/27/2015)
"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
February 28, 2015 at 11:53 am
Viewing 15 posts - 6,631 through 6,645 (of 22,221 total)