Viewing 15 posts - 631 through 645 (of 931 total)
How regularly are you seeing this pattern. Based on that, we could give you some better inputs.
Have you tried to find out if there is any query running on the...
March 7, 2011 at 11:54 pm
Thank you Ron. Seems to be easy, most of them got it right 🙂
March 7, 2011 at 11:41 pm
Below link should answer your question.
March 7, 2011 at 4:29 am
Just curious, what is the intention. Are their any plans underway to implement a new log shipping strategy? 🙂
March 7, 2011 at 4:25 am
Just curious, is compression recommended in log shipping if we are using third party tools like SQL lite etc for backup/restore.
March 7, 2011 at 4:18 am
What are you planning to audit.
By the way, in SQL Server 2008 there is a new cool feature called AUDIT.
You will find it in Management Studio. You could plan...
March 6, 2011 at 11:34 pm
This is a great question. Even though I knew SQL Server will re-arrange fixed width columns first and the variable columns last, I was unable to get this right.
March 6, 2011 at 11:29 pm
Thanks for the question. I took a chance and got it right 🙂
There were conflicting answers on the net.
Learnt something as well through QotD.
For RAID5 minimum number of...
March 4, 2011 at 1:54 am
What does the step 1 do?
If possible, could you also add an error log to the job step so that we could see more descriptive errors
when the DTS job...
March 3, 2011 at 4:56 am
Another good question. Questions are getting tough to crack these days 🙂
March 2, 2011 at 11:29 pm
You may also refer to this book.
http://www.amazon.com/Knights-24-Hour-Trainer-Integration-Programmer/dp/0470496924
This is pretty simple to understand for beginners as it comes along with DVD.
March 2, 2011 at 10:02 am
How did you capture this information. What is the command?
It appears to be some activity on tempdb.
March 2, 2011 at 7:56 am
Basically, it wouldn't be needed. You may need to run a dbcc checkdb regularly on system databases to verify the integrity of the system dbs. But regarding rebuilding indexes on...
March 2, 2011 at 7:53 am
Why are you changing instance name
March 2, 2011 at 4:42 am
What is the number we are looking at?
Doing manually would be tough for each instance.
You could go for third party tools or build your own solution which would give...
March 2, 2011 at 12:53 am
Viewing 15 posts - 631 through 645 (of 931 total)