I'd suggest going to the logs to read what they have to say about it.

You'd need to run the restore... which is probably going to take quite a while. 96gb is a reasonably large number of open transactions.

Perry, really? I've seen more issues with CPU and memory from VMs since those are the shared resources. Not arguing, just requesting more information.

The core concepts of relational data storage and database administration are the same. So tons and tons of your knowledge is going to transfer pretty easily. But, the devil is...

Thanks for bringing up the book. For execution plans though, I'd recommend this one....

milos.radivojevic (3/21/2014)

---

You cannot say in advance if Key Lookup is good or bad. If your query needs to return several columns you cannot avoid it (or you can if you...

In general a key lookup means that the index used didn't have all the columns available so it had to go to the clustered index to get those missing columns....

Yeah, I'm with Luis. Most tables should have clustered indexes. Since it stores the data, it should generally be the primary path to the data. That's not necessarily the primary...

Availability Groups are a mechanism for setting up the ability to fail a database or a set of databases from one server to another. With this setup, there is nothing...

You can run Hadoop on Windows just fine. I've done it. Micrososft does have a port of it available in Azure called HDInsight. Here's a link to check it out[/url]....

roblew 15918 (3/21/2014)

---

Thanks,...

Backing up Gail, piling on and reinforcing this one.

REPAIR_ALLOW_DATA_LOSS is extremely dangerous. It will attempt to fix the database without any regard to your data at all. You could lose...

If you don't mind spending a little money, Red Gate SQL Prompt[/url] is a tool that I can't live without. It formats your code. And it provides code completion way...

If, logically, you need all the rows from one table, but only the matching rows from another table, then some type of OUTER JOIN is necessary. They're not inherently evil.

VMs are pretty solid and work quite well. Just as well as physical machines these days if they're properly set up and maintained. But, performance could be an issue there...