Viewing 15 posts - 12,991 through 13,005 (of 22,232 total)
Roy Ernest (3/21/2011)
Have anyone heard of Hampton Inn in Plymouth? If so what do you think?
She is crying when I told her that Duxbury 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
March 21, 2011 at 3:27 pm
Roy Ernest (3/21/2011)
Stefan Krzywicki (3/21/2011)
Roy Ernest (3/21/2011)
"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 21, 2011 at 11:50 am
I'm near Boston.
"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 21, 2011 at 9:58 am
Ninja's_RGR'us (3/21/2011)
Grant Fritchey (3/21/2011)
"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 21, 2011 at 6:43 am
It's not that kind of site.
"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 21, 2011 at 6:38 am
Ninja's_RGR'us (3/21/2011)
GilaMonster (3/21/2011)
Ninja's_RGR'us (3/21/2011)
Grant Fritchey (3/21/2011)
"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 21, 2011 at 6:37 am
Let's see, movies, games, surfing the web...
For work?
Not much. I've done some writing on it because I have the ZaggMate keyboard. I take notes on it. I use it 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 21, 2011 at 6:22 am
Whether the table is large or not, if you have the write indexes on it, you should be able to retrieve your data easily. You might want to consider partitioning...
"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 21, 2011 at 5:56 am
If you're getting an index scan, you should try to understand why. Is there something in the code, such as a function on the column, that is causing the scan?...
"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 21, 2011 at 5:53 am
I'm with Steve. I wouldn't advocate putting artificial data, especially financial data, into the database. It's just too likely to cause problems down the road.
"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 21, 2011 at 5:49 am
Just to state it as clearly as possible, nesting views is generally a bad idea.
Same goes for nesting functions.
The query optimizer is smart and effective, but it will throw up...
"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 21, 2011 at 5:46 am
If you've validated the data with SQL Data Compare, also validate the structure with SQL Compare. I'll bet other things are missing.
When you're not sure what a query is doing...
"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 21, 2011 at 5:43 am
All true but, the load placed on the TEMPDB by the consistency operations won't go away and could lead to to contention. If I was going to bother with offloading...
"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 18, 2011 at 8:12 pm
I agree with Pam, first place to look is the actual execution plans. Are they different, if so, what are the differences?
Another option to check, what are the ANSI connection...
"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 18, 2011 at 3:53 pm
[Jim].[dba].[Murphy] (3/18/2011)
Grant Fritchey (3/18/2011)
...you may want to take the consistency checks offline, perform them on a restored copy of the database or something.
I have to agree; also helps minimize the...
"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 18, 2011 at 3:26 pm
Viewing 15 posts - 12,991 through 13,005 (of 22,232 total)