Viewing 15 posts - 16,696 through 16,710 (of 22,219 total)
Also, you need to know, tempdb is used for a lot more than just temp tables. It's used for sorting data, frequently from ORDER BY statements. If you're using snapshot...
"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
August 20, 2009 at 6:50 am
To get them execution permissions, I'd suggest giving them execute on the schema:
GRANT EXECUTE ON SCHEMA :: Dude TO Somebody;
In order for them to create procedures, you have to give...
"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
August 20, 2009 at 6:45 am
GilaMonster (8/19/2009)
GSquared (8/19/2009)
Or video it, and review the video yourself. It's amazing what you'll note when you watch yourself in action. Sounds narcisistic, but it's really useful.
Do that...
"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
August 20, 2009 at 5:44 am
GilaMonster (8/19/2009)
Jack Corbett (8/19/2009)
GilaMonster (8/19/2009)
*Woot* Just got TechEd evaluation scores. Bar one comment, very nice!Congrats, but of course exactly what I'd have expected for you, barring the one negative comment.;-)
Comment...
"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
August 19, 2009 at 10:53 am
GilaMonster (8/19/2009)
*Woot* Just got TechEd evaluation scores. Bar one comment, very nice!
Congrats
"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
August 19, 2009 at 9:09 am
I would say there's no advantage. The normal backup process is very light-handed. It's transactionally aware, so you get good, clean backups, all without interrupting user access. Why on...
"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
August 19, 2009 at 7:58 am
I'd be willing to do it. I like the general concept of a contract-to-hire position.
"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
August 19, 2009 at 7:52 am
I don't have a clue. It'd be fun to have that problem though.
"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
August 19, 2009 at 7:42 am
In addition to the server side trace, you can also, in real time, query the information about procedures and their behavior from dynamic management views such sys.dm_exec_query_stats.
"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
August 19, 2009 at 6:31 am
I wouldn't say there was a "right" solution to this question, but, I'd lean towards option 2 above, or, possibly, depending on your system, a third option:
Data & Logs for...
"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
August 19, 2009 at 6:27 am
I'm pretty sure cold backup is an older term no longer in use for backups. Our Oracle DBA's were performing these things up until last year (don't ask). In them,...
"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
August 19, 2009 at 6:22 am
Use SQL Agent to create a job with a schedule that automatically backs up your databases.
"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
August 19, 2009 at 6:20 am
Is that two drives in addition to the operating system and server files location? If not, I'd put the OS on drive 1 and everything else on drive 2. Obviously...
"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
August 19, 2009 at 5:33 am
There are probably (and we're unlikely to ever know) signal processing databases in the NSA that make WoW, YouTube & Google look like rinky-dink Access db's. Just the indications of...
"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
August 19, 2009 at 5:31 am
RBarryYoung (8/18/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
August 18, 2009 at 2:23 pm
Viewing 15 posts - 16,696 through 16,710 (of 22,219 total)