Viewing 15 posts - 1,951 through 1,965 (of 4,745 total)
If you want maximum performance, separate out .mdf, .ldf and backup files is the normal base setup.
Do not bother separating log and data files for your system dbs though.
If...
February 12, 2011 at 12:40 pm
re the nadabadan thread - I think you are all overthinking this, if it looks like a troll, smells like a troll and acts like a troll - its a...
February 12, 2011 at 12:32 pm
set recovery mode to simple
issue a checkpoint
set recovery mode to full
take a full or differential backup
The last step is vital because you have broken your log chain and will not...
February 11, 2011 at 3:30 pm
yes you remove this SP via add/remove programs. Make sure you have the 'include updates' box ticked.
I have not heard of any issues removing it.
February 10, 2011 at 3:33 pm
LutzM (2/10/2011)
We had some SS2K and SS2K5 versions when we decided to replace the SS2K with SS2K8 and leave SS2K5...
February 10, 2011 at 3:15 pm
Steve Jones - SSC Editor (2/10/2011)
george sibbald (2/10/2011)
February 10, 2011 at 10:08 am
steve, are you saying MS will not even supply you the fix for a KNOWN bug without extended support or a one off payment?
February 10, 2011 at 8:28 am
for me when it goes out of mainstream support is not as important as when it goes out of extended support, which is not for another 5 years. So I...
February 10, 2011 at 6:55 am
paul.knibbs (2/10/2011)
February 10, 2011 at 6:46 am
Now we are into a different question Pam, your original post just showed agent xps starting up.
so this is not happening on startup and stop of SQL?
Run a profiler trace...
February 7, 2011 at 3:52 pm
I am not in work today so cannot check but i am fairly certain those messages are standard on startup of single server. SQL agent does not come online until...
February 7, 2011 at 8:57 am
did the interviewer give a solution?
Beats me where the case statement would come into it but this would do it:
select top 1 yourcolumn from yourtable order by yourcolumn desc
February 6, 2011 at 2:43 pm
aaah, of course, I see. thanks.
February 3, 2011 at 3:22 pm
would not the fact that a function is being used for the join mean this is not SARGable and therefore this would always table scan?
February 3, 2011 at 9:20 am
M A Srinivas (2/3/2011)
Practically this is not possible. In production you can not stop and start the service everyday and changes occur to master database every day .
you would...
February 3, 2011 at 3:53 am
Viewing 15 posts - 1,951 through 1,965 (of 4,745 total)