Yes, in small companies the IT department is...

TrailRunner (5/13/2015)

---

I work for a regular company. They are just on a crusade to move things to the cloud and go with everything possible with open source (community editions only),...

Post DDL for the table, including the constraints, defaults, and indexes. Also the insert statement.

Real DBAs hand code...

I've never installed SQL Server in a production environment, but I've installed it at dozens of times on my work PC, laptop, and in development. There are several points in...

I googled, and it appears that the Default Trace can be used to track several types of changes to login properties... but not a password change, which would seem to...

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