Sean Lange (5/18/2015)

---

Michael L John (5/18/2015)

---

Jeff Moden (5/18/2015)

---

andrew gothard (5/18/2015)

---

Jeff Moden (5/14/2015)

---

This one is actually true.

Me, the interviewer: As the Lead Developer on this project, we're very interested in...

When initially creating a stored procedure, I'll sometimes copy / paste text from the functional specification into the header comments.

Also, it helps to include the RFC# or equivalent when...

Jeff Moden (5/16/2015)

---

I was interviewing one person who claimed over 10 years working as a Senior DBA and "tuning experience". Here's how the clustered index segment went.

Me: Tell...

David Webb-CDS (5/15/2015)

---

Your customer comes to you and says the query he has run daily for the last two years is suddenly taking hours instead of seconds. You gather...

Sean Lange (5/15/2015)

---

Luis Cazares (5/15/2015)

---

It's important for us that you'll be a good fit in our team, so the following question will define if you get the job or not.

Leading...

Luis Cazares (5/15/2015)

---

It's important for us that you'll be a good fit in our team, so the following question will define if you get the job or not.

Leading commas or...

Grant Fritchey (5/15/2015)

---

Eric M Russell (5/15/2015)

---

Grant Fritchey (5/15/2015)

---

Question: Can you outline for me how to best design a system so that I can move it between Oracle, SQL Server, MySQL,...

Stephanie Giovannini (5/15/2015)

---

Real interview question that I asked during a tech screen for an entry-level programmer position:

Q: Where do you see yourself in 5 years?

A: CEO!

Background: This young fellow, an...

Here are a handful of approaches, listed from what's generally fastest (select / into) to slowest.

Select into a new table (ie: SELECT * INTO B FROM A).

Select into...

Alvin Ramard (5/15/2015)

---

Eric M Russell (5/15/2015)

---

Grant Fritchey (5/15/2015)

---

Question: Can you outline for me how to best design a system so that I can move it between Oracle, SQL Server, MySQL,...

Grant Fritchey (5/15/2015)

---

Question: Can you outline for me how to best design a system so that I can move it between Oracle, SQL Server, MySQL, DB2, Couchbase, DocumentDB, Hadoop, Redshift,...

Consider replacing the "SELECT TOP 1500" with "SELECT TOP 0".

Luis Cazares (5/14/2015)

---

You receive a late call during the night to inform you that the server is down and must be working correctly before everyone arrives in the morning. How...

Define "working correctly".

When using a local or development envisonment to troubleshoot a performance issue in production, I focus my efforts on reducing logical reads or maybe CPU.

A small box with 2...