Viewing 15 posts - 15,571 through 15,585 (of 22,227 total)
rambilla4 (4/6/2010)
We have SQL Server 2005 EE x64 with SP3 and have the storage on SAN with RAID 10 configuration
and have the below drives:
C- OS
D- Data
E- Log
T -TempDB
Z- Backup
Total...
"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
April 6, 2010 at 6:00 am
2008 does offer the query governor as a mechanism for preventing long-running queries. You can also set a a remote server connection timeout setting for the server, however, this 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
April 5, 2010 at 7:53 am
To be completely honest, one of the best things you can do is learn to operate the search routines either on google or here at SSC. For example, your question,...
"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
April 5, 2010 at 6:27 am
Steve Jones - Editor (4/2/2010)
WayneS (4/2/2010)
where the MCITP is geared towards a specific version, I agree that this certification should be Version specific.
Definitely version specific, though I'd also add I...
"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
April 3, 2010 at 2:04 am
CirquedeSQLeil (4/2/2010)
Grant Fritchey (4/2/2010)
Lynn Pettis (4/2/2010)
Recertification should include testing, presenting original material at users groups/conferences,...
"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
April 2, 2010 at 12:44 pm
Lynn Pettis (4/2/2010)
Recertification should include testing, presenting original material at users groups/conferences, attending appropriate conferences...
"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
April 2, 2010 at 11:58 am
johnhectar (4/2/2010)
Thank you and how can i execute a procedure......
Well that depends on the context. Depending how you are connecting to the database server, different rules are going to apply....
"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
April 2, 2010 at 11:55 am
CirquedeSQLeil (4/2/2010)
You make a good argument against the Time in Service.
If we drop the time in service, would we implement more tests? I see more tests as a 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
April 2, 2010 at 10:35 am
TheSQLGuru (4/2/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
April 2, 2010 at 8:00 am
I think the time in service, as part of the bridge between MCTIP and MCM, actually adds unecessary overhead that is simply going to be gamed anyway. I'm assuming this...
"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
April 2, 2010 at 7:51 am
WayneS (4/2/2010)
Grant Fritchey (4/2/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
April 2, 2010 at 7:36 am
Sorry, test failed. Please try again.
"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
April 2, 2010 at 6:28 am
I saw this question over on ask.sqlservercentral.com as well. I don't understand what you're trying to achieve with this information. Most of it is survey type questions, not questions regarding...
"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
April 2, 2010 at 6:27 am
That's the problem with bringing titles and time in rate to the equation. One of the best DBA's I know isn't a DBA, she's a developer; Gail Shaw. I think...
"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
April 2, 2010 at 6:20 am
Using a number does make sense, but I wouldn't suggest you use NUMERIC. The NUMERIC(12,0) suggested is 9 bytes in size. An INT is only 4 bytes and covers 10...
"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
April 2, 2010 at 6:05 am
Viewing 15 posts - 15,571 through 15,585 (of 22,227 total)