Viewing 15 posts - 18,031 through 18,045 (of 22,219 total)
MS says that less than 1000 pages defragging won't help... that might be true, but if it's less than 8 pages, you can't defrag at all. Setting a fragmentation percentage...
"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 12, 2009 at 9:21 am
The structure and the query are the driving factors. You've got an open-ended query with no well defined WHERE clause, so it's going to be hard to index it properly,...
"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 12, 2009 at 6:05 am
dmoldovan (3/12/2009)
Grant Fritchey (3/12/2009)
The default size is based off the model database. Anything structural you do to the model database will be reflected in new databases you create.
Is this true...
"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 12, 2009 at 6:00 am
This seems to work. Set it to off, backup the database with a new backup and you should be able to restore to another server without the need for certificates.
ALTER...
"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 12, 2009 at 5:42 am
The default size is based off the model database. Anything structural you do to the model database will be reflected in new databases you create.
"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 12, 2009 at 5:37 am
The thing is, no one reads 5 million records. No one reads 5000 records. Very few people read 500. A report should be a succinct display of interesting data, usually...
"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 12, 2009 at 5:30 am
moojjoo (3/11/2009)
Grant thanks for the reply can you provide me a simple sample code...Great quote.
This is straight out of the books online:
USE AdventureWorks;
GO
DECLARE @MyTableVar table( ScrapReasonID smallint,
...
"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 11, 2009 at 8:11 am
When and how often to update statistics and reorganize/rebuild indexes is really dependent on your system. You do need to worry about the order of these operations though. I would...
"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 11, 2009 at 5:51 am
There's no one right answer to this question, but by and large, if you have a general set of data that has to be filled out, then yeah, I'd say...
"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 11, 2009 at 5:47 am
5 million rows is not a report, that's a data move. Generally reports are much, much smaller.
Since you're using a completely ad hoc mechanism for the query, it's going to...
"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 11, 2009 at 5:44 am
5 + 2 = 7 not 8... Yeah, that simple math gets away from me sometimes. Sorry about 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 10, 2009 at 7:04 pm
Do both connections have the same settings? You can check this by looking at the connection information in a trace, either existing connections or logins.
"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 10, 2009 at 12:51 pm
I'm not sure how you could do it either, but when you get it done, write it up as an article 'cause I'd love to read it.
"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 10, 2009 at 12:47 pm
Try it WITH ROLLBACK IMMEDIATE
"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 10, 2009 at 12:45 pm
Can you create a graphical execution plan? An actual plan please, not estimated. Save it to a file as .sqlplan and then zip that attach it to a message. 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
March 10, 2009 at 12:34 pm
Viewing 15 posts - 18,031 through 18,045 (of 22,219 total)