Viewing 15 posts - 15,436 through 15,450 (of 22,227 total)
Michael Valentine Jones (4/21/2010)
That should cut off any further discussion....
"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 12:23 pm
To a degree, what he's proposing is partitioning your data. That's actually a fine way to go, but you can actually work with sQL SErver to have it do 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 12:22 pm
John Waclawski (4/21/2010)
I hope to find an answer to my question(s) here. If not, I will continue my quest.
Due to a lay-off from my former job 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
April 21, 2010 at 12:18 pm
Jeff Moden (4/21/2010)
Grant Fritchey (4/21/2010)
Trey Staker (4/21/2010)
Roy Ernest (4/21/2010)
GabyYYZ (4/21/2010)
Please tell me THIS doesn't happen a lot...*groan*.I hope it is just a joke....
I doubt it's a joke. I've seen...
"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 11:42 am
If you're saying that the searches are always on everything, every time... you're in trouble. But eveyrone always points to web sites like Facebook or Google and all the flexibility...
"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 10:28 am
Trey Staker (4/21/2010)
Roy Ernest (4/21/2010)
GabyYYZ (4/21/2010)
Please tell me THIS doesn't happen a lot...*groan*.I hope it is just a joke....
I doubt it's a joke. I've seen stuff like this before,...
"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 10:16 am
GabyYYZ (4/21/2010)
Please tell me THIS doesn't happen a lot...*groan*.
You have to admit, that completely qualifies as "WTF"
"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 9:08 am
Take my advice with a huge grain of salt, but if I were doing this, I'd make those types of choices default values that I loaded for the client. You...
"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 9:01 am
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
Viewing 15 posts - 15,436 through 15,450 (of 22,227 total)