Viewing 15 posts - 16,381 through 16,395 (of 22,226 total)
Or, instead of running in SSMS in sqlcmd mode (great idea, btw), just go and run the scripts in sqlcmd directly.
"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 7, 2009 at 7:14 am
Definately not. The key is the key is the key. Whatever you have as the primary key in the parent table, that should be the foreign key in the related...
"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 7, 2009 at 7:04 am
They almost describe themselves. A SQL Login is a login defined within the SQL Server system itself. It doesn't have existence outside of the SQL Server instance on which it...
"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 7, 2009 at 6:59 am
GSquared (10/6/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
October 6, 2009 at 9:13 am
Lynn Pettis (10/6/2009)
Grant Fritchey (10/6/2009)
RBarryYoung (10/5/2009)
Now all I need to do is to keep this up for three years... And for at...
"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 6, 2009 at 6:53 am
Bob Hovious 24601 (10/6/2009)
But I haven't started using dinosaur names...
"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 6, 2009 at 6:51 am
RBarryYoung (10/5/2009)
Now all I need to do is to keep this up for three years... And for at least four people 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 6, 2009 at 5:30 am
What everyone is trying to say, just not in so many words, is, you need to look this stuff up for yourself. SQL Server comes with documentation. It will supply...
"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 6, 2009 at 5:29 am
You've got two choices. First, and probably best, you need to leave all your databases in 8.0 compatibility mode until the production upgrade is completed. That way, none of your...
"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 5, 2009 at 8:15 pm
David Webb-200187 (10/5/2009)
I've heard a lot of people who should know better ask for this option. If MS ever implements it I think it should be:SET CORRUPT_MY_DATABASE_AT_THE_WORST_POSSIBLE_TIME = True
Ha!
Good...
"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 5, 2009 at 6:38 pm
rhunt (10/5/2009)
Two things I've...
"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 5, 2009 at 1:34 pm
CPU usage within Profiler would not be a good measure for overall CPU use within the system. It's only going to give you information about the execution of the procedures...
"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 5, 2009 at 1:20 pm
It's also a lot faster to learn the TSQL. Once you know how to type out the RESTORE statement, you'll find that it's quicker than trying to click your way...
"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 5, 2009 at 1:16 pm
The management pack is an XML definition. You can read through the XML directly to see the list of rules & monitors. I meant you could go there.
I tried searching....
"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 5, 2009 at 10:50 am
Performance Monitor (perfmon) and dynamic management viewws (DMV's) are best. You can also browse the trace events from a server side trace on the client machine using Profiler. I would...
"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 5, 2009 at 9:38 am
Viewing 15 posts - 16,381 through 16,395 (of 22,226 total)