Viewing 15 posts - 12,016 through 12,030 (of 22,224 total)
A friend of mine has been IT for non-profits for a while. I'll see if I can't get him to swing by & 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
August 22, 2011 at 4:46 am
Nope. And you'd best hope your potential future employer doesn't do searches out there to try to find out where and how you post. They'll see what could easily be...
"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 4:44 am
There's no way to no for sure if any technology will survive for long. However, look at like this. None of the new technologies looks poised to take over relational...
"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 4:39 am
And that's why you only store 4000 some odd characters instead of 8000 some odd without resorting to using MAX. That's for nchar & nvarchar.
"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 4:34 am
No, an hour seems very excessive for that query.
"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 4:03 am
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
Viewing 15 posts - 12,016 through 12,030 (of 22,224 total)