Viewing 15 posts - 16,546 through 16,560 (of 22,229 total)
I'd go a bit farther and suggest if you're even thinking about putting locking hints into your query, then you need to reassess your system, it's design, the queries you're...
"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
September 15, 2009 at 6:06 am
This is an estimated execution plan, not the actual execution plan, so there may be other issues that I can't see with this. The thing that jumps out at me...
"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
September 14, 2009 at 12:24 pm
JC (9/14/2009)
Thanks MarcinI need someone in the Los Angeles area
Jim
Solid Quality instructors travel. A lot. You can also pay a little extra and bring them to your location directly. My...
"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
September 14, 2009 at 9:28 am
Silverfox (9/14/2009)
"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
September 14, 2009 at 9:23 am
dma (9/14/2009)
"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
September 14, 2009 at 8:50 am
Rudy Panigas (9/14/2009)
"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
September 14, 2009 at 8:40 am
Thinking about this some more, I have a question back to you SilverFox.
Are you simply trying to know just enough to maintain your current position or get hired at 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
September 14, 2009 at 8:33 am
You're talking about 4GB database? As in gigabyte?
That's teeny-tiny. Having a million people connecting to it is pretty scary, but you should be able to put the entire database, including...
"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
September 14, 2009 at 8:06 am
There is no need to order the inserts of your data. This is because your data is not stored in a perfect order. Even a clustered index, which is logically...
"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
September 14, 2009 at 8:02 am
ma.daissaoui (9/14/2009)
table CategorieChild ====> IdCategorieChild | Idcategorie
...
"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
September 14, 2009 at 7:55 am
Unless the two databases were identical in every possible way, you couldn't transfer the statistics (not that you can). But if they are identical in every possible way, the generated...
"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
September 14, 2009 at 7:52 am
Micrososoft has an Upgrade Advisor that will check your 2000 database to see if it has any deprecated code, so you can fix it before there are errors in 2005...
"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
September 14, 2009 at 7:49 am
Jack Corbett (9/14/2009)
"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
September 14, 2009 at 7:05 am
David.Poole (9/14/2009)
There will always be people who complain about...
"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
September 14, 2009 at 5:40 am
giaks0wn (9/14/2009)
"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
September 14, 2009 at 5:38 am
Viewing 15 posts - 16,546 through 16,560 (of 22,229 total)