In my youth, I loved getting involved with online arguments. For some reason, as I've aged, I just walk away from the goofy things. To a degree, this feels like...

inevercheckthis2002 (12/17/2013)

---

The google articles I see show how to recover to a point in time using backups. I am asking about a case where the transaction logs exist.

I thought...

I'd suggest getting a copy of my book. I go through all the information you're asking in great detail. The 2008 version is more applicable for your 2005 instance, but...

defyant_2004 (12/17/2013)

---

I am still not seeing what functions on the server they would need. If they can work in SSMS from their machine, why do they need to login...

I know there is a way to do it, yes, but I'm not familiar with it. It's actually something I need to spend some time getting my arms around and...

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...