colin.s.allen (12/25/2012)

---

... another time this happens is when you have Enterprise edition and have concurrent scans running, the second scan will piggy back on the first scan then backtrack to...

Bob-444665 (12/24/2012)

---

The ordering of the data is not physically written or rewritten in some order when a clustered index is added or removed. This is a persistent myth on...

Great definition and clarification of terms for beginners! You explained it very well.

I'm sorry, but which part of "remapping users is BAD" is confusing for you? Why would I help you do it the wrong way when we've already told you how...

Delete means "remove" or "get rid of". Don't remap logins. That's bad. Create the logins correctly and there will be no need to remap anything. Use the script I gave...

I don't know all of the requirements, but I know a couple of them.

1. The test center must be highly secure. Most centers don't have enough staff to actively monitor...

There are 2 in the UK and one in Berlin, Germany currently. Sadly, the number of test centers has only decreased. When I left Microsoft Learning, we were working on...

Agreed. Probably is the same.

Repros for me too. Definitely seems to be a bug.

saidapurs (11/23/2012)

---

Hi,

1st you execute

ALTER DATABASE Dbname SET PARTNER OFF

Then you execute below query

RESTORE DATABASE Dbname WITH RECOVERY

It will...

kapfundestanley (11/23/2012)

---

Basically am running two statements:

1.alter databasename set partner off

2.restore databasename with recovery

It is the second statement that is failing,so are suggesting that after restore databasename with recovery gives an...

Actually, that's not an accurate statement. This column...

Sorry. Try this link: http://www.idera.com/Action/RegisterWP.aspx?WPID=43

Gail wasn't advocating not using a SAN. She was merely saying not to count on the SAN's redundancy to save you in a disaster. If the whole SAN goes down,...

Congrats Simon! I look forward to seeing you join our group? Are you at the PASS Summit by any chance?