Viewing 15 posts - 12,016 through 12,030 (of 22,219 total)
Ninja's_RGR'us (8/21/2011)
Or a short exemple like : SELECT NULLIt's the only thing I can imagine with 0 cost plan...
granted I didn't give this any energy before today.
SET statements for parameters,...
"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
August 22, 2011 at 3:56 am
Ninja's_RGR'us (8/21/2011)
Grant Fritchey (8/21/2011)
mister.magoo (8/20/2011)
The other way I can...
"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
August 21, 2011 at 5:35 pm
I'm with Lutz. Sounds like an issue with the backup, but I wouldn't discount the network.
"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
August 21, 2011 at 5:35 pm
Christi Wilson (8/21/2011)
If anyone knows a good blogging software that has the ability to post code would be greatly appreciated.
WordPress is excellent. There are several plugins that work well with...
"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
August 21, 2011 at 5:33 pm
mister.magoo (8/20/2011)
The other way I can get that behaviour...
"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
August 21, 2011 at 4:52 am
The choice of which one comes first does matter. If you were to have a composite with the leading edge of FamilyId and a single index with the leading edge...
"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
August 21, 2011 at 4:44 am
Just a guess, any chance that the database is in compatibility mode? I'm not sure that would affect anything, but that's odd behavior.
"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
August 20, 2011 at 1:35 pm
I agree with the Ninja, killing the process is a bandaid at best. You need to address the issue and fix that set of procs so that they're not stepping...
"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
August 20, 2011 at 1:34 pm
Another thing to take a look at are some of the new data types, especially the CLR types, and some of the new options with indexes. Those things made 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
August 20, 2011 at 1:32 pm
Most systems I've managed we updated the statistics daily. But some were less volatile so we updated statistics weekly. You're approaching dealing with large databases at 1TB. You might need...
"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
August 20, 2011 at 1:29 pm
I'd try uninstalling and then reinstalling.
"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
August 20, 2011 at 1:24 pm
Sounds like some kind of hardware issue. Was the restore run across the network? Might have glitched there. You're using a third party product? Might have been something in there...
"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
August 20, 2011 at 1:23 pm
ajaysanhotra (8/20/2011)
Hi i am curious to know what is the difference betweenCREATE INDEX PIndex ON Persons (LastName) ,
CREATE INDEX PIndex ON Persons (DOB)
AND
CREATE INDEX PIndex ON Persons (LastName,DOB)
You can't...
"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
August 20, 2011 at 1:19 pm
1. What ever process you're using would need to keep track of which index has been done. There's nothing automatic around that.
2. CHECKDB outputs it's results, and yes, you can...
"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
August 20, 2011 at 1:12 pm
I'm pretty sure that FILESTREAM stores individual files, not a single file like a database file. Each time you write a file out to the FILESTREAM, it gets stored out...
"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
August 19, 2011 at 7:44 am
Viewing 15 posts - 12,016 through 12,030 (of 22,219 total)