Not at all.

As Richard says, you'll...

Honestly, I can't.

How much CPU does each of those servers use? If one is maxed out on memory, we probably don't want to put it into a VM, but from...

I have to ask, how, possibly, from a listing of servers could I tell you which of the databases on those servers would need mirroring? How could I? Possibly? Further,...

The restore won't change the compatibility level, you have to do that as a second step.

Even if you create the database in 2012, when you restore the 2005 backup, it's...

chandan_jha18 (12/17/2013)

---

Grant Fritchey (12/17/2013)

---

And ditch the NOLOCK hint.

If the table has 100K of records, this looks like it's also returning over 100K of records. Is the WHERE clause not filtering...

In short, homework.

Here's how it's done. Think about each of the objects you've just defined. There's a school, a student and student grades. Now think about how those objects relate...

And ditch the NOLOCK hint.

If the table has 100K of records, this looks like it's also returning over 100K of records. Is the WHERE clause not filtering at all?

Please don't cross post questions between forums. As you can see, we all go to many (most?) of the forums to answer. Cross posting just confuses the conversation.

Nope. No maintenance wizard, no SQL Agent, so to maintain Express editions you'll need to have some type of scheduling service and create T-SQL scripts for all the maintenance.

Gotta land on the other side on this one.

I spent close to 10 years as a DBA for a major insurance company and most of that time I did not...

It's certainly possible, and yes, it would matter. For example, you may have an application that knows it has issues with statistics, so as part of the install it creates...

SQL Server Availability Groups were introduced with SQL Server 2012. But there are other types of "high availability" options that are there in other versions of the product, as were...

Yikes! Not good. A consistency check should be run on the database right away. I hope you have good backups in place.

Replication is also supported in Standard. Mirroring is also supported by Standard (although a slightly reduced version). You can see the versions here.

Or you can set up mirroring or log shipping or replication... None are easy, but all can be done in such a way to get a read only copy of...