Eric M Russell (5/9/2014)

---

Andy,

I'm curious about why you chose the title "Datatypes In Your Mind".

Did you expect this TinyInt vs Bit question of the day to create some controvery...

Andy,

I'm curious about why you chose the title "Datatypes In Your Mind".

Did you expect this TinyInt vs Bit question of the day to create some controvery and debate?

Obviously running ad-hoc queries against unstructured data is a use case for a NoSQL database, and MongoDB is good for that. This would include things like ecommerce shopping carts and...

In some sense the DevOps movement is built around merging these two frames of reference into the minds of all those involved. I hope that movement continues to grow and...

Tinyint is an underappreciated datatype. I leverage it a lot for small range keys like marital_status or for things like service_years. A lot of developers punt and always use 4...

Usually when we interview candidates, the recruiter has already required them to complete a standard technical assessment exam and HR has qualified them based on their education and visa status....

homebrew01 (5/5/2014)

---

What type of SQL Database questions would you ask of a prospective junior PHP web developer. We know he is fairly new at it, so no tricky "gotcha" questions....

Sorry - you were wrong

Correct answer: TinyInt

Explanation: There are four data types that are integer/exact number: bigint, int, smallint, and tiny int. The ranges of...

That's one the biggest database design mistakes. First, there are a...

So we know what you're suggesting, show...

Jeff Moden (5/5/2014)

---

Steve Jones - SSC Editor (5/5/2014)

---

Jeff Moden (5/3/2014)

---

I think a much better question would be, "What determines what will be the first (top) table (according to books online)...

Robert.Sterbal (5/5/2014)

---

Eric M Russell (5/5/2014)

---

I'd say that Chipotle Mexican Grill is good, fast, and cheap. However, as with any application, whether it be software or a restraunt, how the end...

What method did you use to port the database?

Remember to use a schema comparison tool to insure things like indexes, table options, statistics, constraints, plan guides, etc. are all the...

I'd say that Chipotle Mexican Grill is good, fast, and cheap. However, as with any application, whether it be software or a restraunt, how the end user perceives "good" is...

So, [widgets] looks like an EAV (entity attribute value) table. This is similar to the common scenario where users request a query containing CustomerID, HomePhone, CellPhone, WorkPhone and all phone...