Viewing 15 posts - 13,276 through 13,290 (of 22,219 total)
If you can, while this procedure is running, run a select statement against sys.dm_exec_requests. You should be able to see the procedure (if not, combine it with sys.dm_exec_sql_text and use...
"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
February 14, 2011 at 5:43 am
But, you only get one primary key per table. You can have multiple unique keys, but only one primary key.
I'm with everyone else, what exactly are you looking for here.
"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
February 14, 2011 at 5:40 am
Personally, I'd want to have a chat with the interviewer. Most of the time, and by that I mean 99.several nines, you have something wrong in the query that 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
February 14, 2011 at 5:18 am
150gb should restore fairly quickly. What was the command you used to do the restore?
"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
February 14, 2011 at 5:14 am
Craig Farrell (2/13/2011)
One of the things that will help...
"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
February 14, 2011 at 5:08 am
george sibbald (2/13/2011)
Grant Fritchey (2/13/2011)
SCOM from MS is good, and certainly enterprise ready. You can get Management Packs that do most of what you're asking about right out of 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
February 14, 2011 at 5:07 am
WayneS (2/13/2011)
Grant Fritchey (2/8/2011)
"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
February 14, 2011 at 5:01 am
paul.knibbs (2/14/2011)
Silly question: why not just configure SQL server to send job failure etc. e-mails to the e-mail account linked to your Blackberry?
Not a silly question you can 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
February 14, 2011 at 5:00 am
m--S3qU3L (2/13/2011)
But my query is for the courses on networking, SAN, AD, etc (other than SQL). Will it benefit me in the long run in my DBA...
"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
February 13, 2011 at 10:35 am
Wow! Sounds like a bit of a mess. I guess it depends on what you're moving where and why. Any of the tools you mentioned will help, depending on 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
February 13, 2011 at 8:21 am
It kind of depends on how you learn, but sure, taking a course will absolutely help you increase your knowledge and your skill set. Now, there are courses and there...
"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
February 13, 2011 at 8:18 am
A backup that large directly to tape is going to take forever. Do you have multiple file groups you can backup from? That would probably work better.
At your size 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
February 13, 2011 at 8:15 am
I'd like to repeat exactly what George said...
Well, OK, I'll ad a little. If you can, seperate the OS from the mdf from the ldf. After that, it gets into...
"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
February 13, 2011 at 8:13 am
There are a lot of products out there that will do this. I've used four with varying degrees of success: SCOM, Idera Diagnostic Manager, Confio Ignite, and Red Gate SQL...
"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
February 13, 2011 at 8:05 am
Yeah, I've done it from a Blackberry in the past.
Now I use my iPad and my Droid. There are different ways you can do it with 3rd party tools. 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
February 13, 2011 at 7:57 am
Viewing 15 posts - 13,276 through 13,290 (of 22,219 total)