Viewing 15 posts - 21,616 through 21,630 (of 22,232 total)
Table valued stored procedures do not generate statistics. This means if you are going to join one function to another or anything else along these lines, performance won't just 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
October 26, 2007 at 12:36 pm
Bob Fazio (10/26/2007)
Developers should have 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
October 26, 2007 at 11:08 am
Hey, nice trouble shooting pattern. I'll have to see if we can begin to apply that 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
October 26, 2007 at 11:03 am
CREATE VIEW x
AS
SELECT * from linkedserver..schema.table
Works great.
"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
October 26, 2007 at 9:47 am
Jereme Guenther (10/25/2007)
"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
October 26, 2007 at 7:21 am
Unless it's impossible for some external reason, your stored procedure's parameters should always be of the data type that you're attempting to manipulate within the database. So, instead of 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
October 26, 2007 at 6:54 am
This is a discussion about the editorial posted today (Friday 10/26) by Steve Jones. Scroll up & follow the link at the top of the comments.
"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
October 26, 2007 at 6:08 am
Drew Mayo (10/26/2007)
Kelvin Lush (10/25/2007)
"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
October 26, 2007 at 5:48 am
I don't have a solution, but possibly an idea.
I live the first few years of my life in a VERY small town in Southwest Missouri called Sarcoxie. For a while...
"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
October 26, 2007 at 5:41 am
Sorry, I just plucked it from the middle of existing code. Our system has one table that doesn't have versions and all the rest do. So the query included 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
October 25, 2007 at 1:08 pm
We also did some this way:
SELECT...
FROM Table x
CROSS APPLY (SELECT TOP(1) whatever..
...
"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
October 25, 2007 at 1:02 pm
We had a similar problem and solved it, nicely, like this:
SELECT...
FROM Table1
JOIN Table2
on table2.PK = table1.Pk
and table2.AuditDate = (SELECT TOP(1) t2.AuditDate
...
"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
October 25, 2007 at 12:26 pm
They've already had several instances of "Oh, I forgot to add that WHERE thingie to the 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
October 25, 2007 at 11:17 am
We did win the support argument. We've pretty much told them, if they tank the system, our only troubleshooting method will be a restore or restart the server. No other...
"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
October 25, 2007 at 9:54 am
AAARRRGGGGH!
I can't believe I got such a simple question wrong. Reading the question carefully really does matter. I saw amalgamate & rows and didn't see the word tables in between......
"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
October 25, 2007 at 8:05 am
Viewing 15 posts - 21,616 through 21,630 (of 22,232 total)