Viewing 15 posts - 21,571 through 21,585 (of 22,224 total)
kev_byrne (11/2/2007)
The SQL when run directly against the DB, on 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
November 2, 2007 at 7:03 am
This is unlikely to run very fast, 43 seconds on my machine against 54 million rows, but it'll work.
WITH x AS (SELECT b.[ID]
,b.[Date]
,b.[Value]
,ROW_NUMBER() OVER(ORDER BY b.[ID]) AS RowNum
FROM [BigTable] b
)
SELECT...
"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
November 2, 2007 at 6:55 am
Johannes Fourie (11/2/2007)
Then remove the ORDER BY 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
November 2, 2007 at 6:46 am
Thinking about it more, you should be able to get reasonable performance, even pivoting the data, assuming the indexes are clean, especially the clustered indexes. How did you set those...
"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
November 2, 2007 at 5:39 am
Unfortunately, I'm going out of town for a week, but posting a bit of code could help someone else to help you.
Based on the requirements... 30 fields each 100 characters...
"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
November 2, 2007 at 5:37 am
Bump.
Surely someone has a comment?
"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
November 2, 2007 at 5:28 am
The one time I did manage a VLDB, we sure has heck ran the log backups more frequently than once a day, but then it was an OLTP system. I'm...
"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
November 1, 2007 at 12:43 pm
Bob Fazio (11/1/2007)[hrComplaints come from many sources. A stable system is a good goal too. Performance is also a goal. If you haven't noticed before a high...
"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
November 1, 2007 at 9:37 am
Please, a syntax check on the XQuery. It's my first time out of the gate with this and I'm not sure I'm avoiding stupidity successfully.
"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
November 1, 2007 at 6:00 am
Neither full text or xml has me terribly excited. If it were my project, I'd be reexamining the assumptions and trying to find a method of defining the requirements more...
"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
November 1, 2007 at 5:20 am
Sounds like you just need an "ORDER 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
October 31, 2007 at 7:04 am
What about XML for the meta data? It really does sound like it's only semi-structured data.
"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 31, 2007 at 6:58 am
I'm sorry, I don't understand the question. Can you supply a few more details?
When you say in-lined table function, do you mean a user defined function that returns a table...
"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 31, 2007 at 6:54 am
Well, again, there's not enough detail to start to give you very specific answers. It sounds like you're doing RBAR (row by agonizing row) processing. I'd strongly suggest you examine...
"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 31, 2007 at 6:47 am
Andras Belokosztolszki (10/31/2007)
Grant Fritchey (10/30/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 31, 2007 at 5:51 am
Viewing 15 posts - 21,571 through 21,585 (of 22,224 total)