Yes. you can have one without a primary, however I've never seen it in the wild. You can also set both up as primary. Reminder, moving nodes will cause a...

In that respect, you are correct. If he is not allowed to view any other database through activity monitor, then this would not work. I don't know if you can...

That is 100% correct. It will however, allow them to view the activity monitor (all items). so with your permission change to allow them to own that specific user database...

would this not work? I have a user who does not have SA on the box and granting them view server state allowed them to use activity monitor.

GRANT VIEW SERVER...

I'll have to look into that. I'm not familiar with those. Thanks!

I agree, though we cannot add...

Correct me if i'm wrong, you could also use the below script to trace back to what's being blocked by whom.

select * from sysprocesses

order by blocked desc

Then run the below...

Sorry SSCoach, I'm sure you can give a much better answer than a link to an article, but I found this link rather useful in understanding what all is going...

http://www.sqlskills.com/blogs/paul/post/misconceptions-around-the-log-and-log-backups-how-to-convince-yourself.aspx

"There's still a widely held misconception that when properly in the FULL or BULK_LOGGED recovery models that full or differential backups can truncate the log. No. It *NEVER* happens. This...

i can see that, you automate your full backup and you take a second one. if you're taking one, once a day anyways, why not change your automated one to...

we run a differential every 4 hours on schedule, a full back up every night at midnight and a transactional log backup every hour on the hour. Is there a...

Is this database in full recovery mode?

it would be nice, but as DBA's we don't have a test bed. And even so, we'd need a substantial system to test on.

George M Parker (12/20/2012)

---

The primary difference is internal fragmentation versus external fragmentation. The Reorganize fixes external fragmentation when the 8k pages are physically out of sequence. The Rebuild fixes internal...

yes, except certain scenarios, shrinking is bad. ^.^; I'm more wondering why you would rebuild vs reorg first? Every week on our full backups, all statistics are updated, as well...