Viewing 15 posts - 14,086 through 14,100 (of 22,219 total)
Rob Schripsema (10/15/2010)
nick.mcdermaid (10/14/2010)
"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
October 15, 2010 at 10:11 am
Steve Jones - SSC Editor (10/15/2010)
"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
October 15, 2010 at 8:31 am
michal_marek (10/15/2010)
My suggesting isset:
sp_configure 'max degree of parallelism', '1'Best,
But, what if a given query really benefits from parallelism? Now you've just taken it away.
However, I do notice that more...
"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
October 15, 2010 at 7:42 am
Try using sp_help_revlogin[/url].
"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
October 15, 2010 at 7:26 am
Ninja's_RGR'us (10/15/2010)
Grant Fritchey (10/15/2010)
"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
October 15, 2010 at 7:11 am
Maybe I don't understand the question.
DROP INDEX myschema.mytable.myindex
This usually does the job. Then you can create the index.
If you mean, what's the best mechanism for determining which indexes need 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
October 15, 2010 at 6:52 am
Views aren't compiled. If you want to know which views are dependent on a table that you've modified, you can use sys.dm_sql_referencing_entities. If, on the other hand, you're curious 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
October 15, 2010 at 6:18 am
Amu (10/14/2010)
I am looking into thest...
"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
October 15, 2010 at 6:14 am
We have this automated all over the place. You need to script out a few sets of processes. First, obviously, the database restore. Then, you need to remove production level...
"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
October 15, 2010 at 6:08 am
Just remember that the DMV referenced above, while an excellent approach to finding the offending query, is dependent on that query being in cache. If you want to be sure...
"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
October 15, 2010 at 6:06 am
aspardeshi (10/15/2010)
Thanks for the update. I will give you sufficient reasoning below the logic, the logic is that every student need not register parent user id, but every parent...
"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
October 15, 2010 at 6:04 am
That is a huge topic. You're not likely to get really useful responses in a forum like this. The configuration you need to put on your system is very dependent...
"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
October 15, 2010 at 5:56 am
Best way to avoid this that I know of, two logins. Have a special login for going to the production system. Then, you have to do a Run As in...
"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
October 15, 2010 at 5:50 am
nick.mcdermaid (10/14/2010)
"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
October 15, 2010 at 5:40 am
WayneS (10/14/2010)
I've used Sybase's PowerDesigner before, it's pretty good.
I haven't used it, but I did an eval of PowerDesigner. It's a very good piece of software, especially if you have...
"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
October 15, 2010 at 5:34 am
Viewing 15 posts - 14,086 through 14,100 (of 22,219 total)