Viewing 15 posts - 16,531 through 16,545 (of 22,219 total)
You can set the database to single user mode or, what I usually do, restricted user mode and use WITH ROLLBACK IMMEDIATE. That will remove all the connections and leave...
"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 16, 2009 at 6:36 am
You can get an idea of which queries use those indexes by using the execution plans available in the plan cache, yes. You should be able to run an XPath...
"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 12:13 pm
Inexpensive, Red Gate's SQL Compare. Fantastic tool.
"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 8:28 am
GSquared (9/15/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 15, 2009 at 7:56 am
If you want short articles, I'd suggest doing a search in the Search box near the top of the screen here. There are a ton of articles on how 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
September 15, 2009 at 6:09 am
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
Viewing 15 posts - 16,531 through 16,545 (of 22,219 total)