Stuart Davies (2/3/2016)

---

GilaMonster (2/3/2016)

---

jonathan.crawford (2/2/2016)

---

Now it's not a db design class, but still, we should at least be attempting to teach students rather than handicap them, right? They'll screw up...

Coruscant

Heh - I was so busy thinking about the endpoint that I forgot to click the database. A lesson to always think about the whole problem and not just focus...

Brandie Tarvin (2/3/2016)

---

Jo Pattyn (2/2/2016)

---

To the experts of DBCC TIMEWARP

Why can't system databases be restored "with move" like the others?

Example: RESTORE database model with move -> The system database cannot...

I love learning something new, so thank you.

Personally, I love the EXECUTE AS both when creating procedures and also to impersonate to troubleshoot permissions. Good question.

GilaMonster (2/3/2016)

---

You can't do an in-place from 32-bit to 64-bit iirc. You'll need to either install a new instance and move the DBs across or uninstall the old and install...

djj (2/3/2016)

---

Jar...

curious_sqldba (2/2/2016)

---

Practically you...

ramana3327 (2/2/2016)

---

We have SQL Server 2005 SP1 with 32 bit

Microsoft SQL Server 2005 - 9.00.5000.00 (Intel X86)

Planning to upgrade to SQL 2008r2.

Do we need to select processor Type...

Jason, I don't know if you've worked with SQL 2012 R2 much, but let me tell you it's been great for me. While the metro interface takes some getting...

Amadala

Hugo Kornelis (2/2/2016)

---

Note of warning to ramachandran narayanan:

The solution posted by chalam87 (which is about equal to a solution posted to one of the other locations where you asked this...

Luis Cazares (2/2/2016)

---

Ed Wagner (2/2/2016)

---

Luis Cazares (2/2/2016)

---

That's certainly interesting. I've never heard of %%physloc%%...

Luis Cazares (2/2/2016)

---

Sean Lange (2/2/2016)

---

Luis Cazares (2/2/2016)

---

<rant>

I'm not sure what's worse. An article promoting RBAR code or comments arguing that the code in the article won't work even if it...