Looks pretty good. I like the approach of defining the problem space and then talking about how you'll present solutions to that problem space. I'd say it needs one more...

There's been tons of discussion around this. Coding Horror has an article[/url] about one of the best articles on ORMs, that and all the links are worth a read.

I've worked...

Just looking at pictures of execution plans and not able to see the properties, this is a bit of a guess, but I'd say it's probably bad parameter sniffing.

When you...

I'm not an expert on sp_prepare, but I'm pretty sure you're not supposed to set the value to a particular number, you're supposed to capture that value in the output...

Why try to open it through a SQL query? Why not just use a command line utility like PowerShell or sqlcmd.exe? Either of those can read the file and execute...

Most of the migration projects I've been on take 6-9 months to move stuff over. With that in mind, I usually always suggest going to the latest release because we're...

Cody K (4/10/2014)

---

How does this come about in real life?...

Which will check just the header unless your backup is...

Although, there are degrees of "simultaneous." Is everything going to the same disk? Then you'll be seeing alternating writes, not simultaneous, depending on the number of disks, controllers, all that...

If you want to test the whole system, disk, memory, etc., you really do have to retrieve the data. If you're on a 2012 system, I'd suggest looking at distributed...

Try this one.

Create a foreign key between the columns that map between the two tables. Here's the documentation on that.

I'd suggest looking into using Michelle Ufford's scripts for maintaining your indexes. That way you don't have to write something yourself.

j.b.shteyn (4/9/2014)

---

Three people were there for the pizza, the rest for the presentation - none were there to mingle. I did talk to one person though, he...

Cody K (4/10/2014)

---

I don't think that's what certifications are for, so I'll pose this question: if you have two roughly equivalent applicants for a role:

- One has experience, and says,...