Viewing 15 posts - 15,436 through 15,450 (of 22,219 total)
Paul White NZ (4/21/2010)
Grant Fritchey (4/21/2010)
It is a tad costly, but not like the DBCC check.
LIMITED mode just scans level 1 of the index structures (not the leaf) - or...
"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, 2010 at 7:52 am
Stefan_G (4/21/2010)
Paul White NZ (4/21/2010)
Sumanta-1056020 (4/21/2010)
"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, 2010 at 7:15 am
I generally try not to do this, but in this case, follow the link in my signature below. There's a book that covers what you need.
There's no way for someone...
"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, 2010 at 7:05 am
Since we're not sitting at your desk, you really need to supply us with the full command that you're trying to run. Without it, there's no way for us 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
April 21, 2010 at 7:03 am
I'd suggest starting with the Books Online. But if you get stuck you can always go here: http://tinyurl.com/yyfyagj
"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, 2010 at 7:01 am
There really is no hard and fast rule on this because you're comparing apples to hammers. If you have to delete a row, what would it matter if the delete...
"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, 2010 at 6:59 am
Well the first and most obvious part is that you have to record a start & stop time and keep it in order to compare to other start & stop...
"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, 2010 at 6:56 am
It's logical, but a poor choice. In order to implement it, all access to your system would need to be through dynamic tsql, where you build the sql statement. This...
"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, 2010 at 6:08 am
Third vote. You're on the money the other guys need to go back & hit the books.
"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, 2010 at 6:01 am
You say the data is "huge" but what does that mean in real terms? It sounds like you may have tuning opportunities in the SSIS data load.
Regardless, one way around...
"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, 2010 at 5:59 am
Sumanta-1056020 (4/21/2010)
We got microsoft recommendation like this..
An index that is more than 5 percent or less than 30 percent fragmented should be reorganized. In addition, an index that 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 21, 2010 at 5:54 am
I'd start with the Books Online. You're listing a large swath of different performance metrics, so there's not going to be a single source for this information except for 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
April 21, 2010 at 5:49 am
Whisper9999 (4/20/2010)
Grant Fritchey (4/20/2010)
"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, 2010 at 5:18 am
It will rebuild the indexes, but it might not be the most optimal method, but I only say that because, depending on the table, some tables might be better off...
"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, 2010 at 4:39 pm
greggoble2 (4/20/2010)
I just installed Visual Studio 2010 and it has compare functionality built in. It is pretty nice.
It is decent and functional. I don't think it quite has all...
"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, 2010 at 11:11 am
Viewing 15 posts - 15,436 through 15,450 (of 22,219 total)