Depends.

From info you posted it appears you have a denormalized entity with property names and activity => no activity means no record in table, so right join to a calendar...

Definitely agree.

Writing tests (and documentation) is also a "simplicity test". If a feature can't be tested in a simple way, it's probably a good moment to rethink and redesign the...

webrunner (9/3/2013)

---

Fascinating idea. Does anyone have any suggestions for sites or books that discuss how to integrate a sensor and a SQL database? Sounds like that would be fun to...

There is no resultset. Procedure returns just an integer. There is a huge difference between no resultset and empty resultset. Since there was no such answer, all answers are wrong....

Well, nice one.

To all those complaining about losing points... If you answer correctly, you just get the confirmation about your knowledge and are awarded with a point, if you fail,...

L' Eomot Inversé (4/30/2013)

---

After that I'll maybe revert to my old question style and submit things that test knowledge and not ability to execute code in one's head (instead of...

The idea for qotd is OK, but a script is too complicated to figure out the result within few minutes I'm willing to spend on it.

There are a lot of...

BLOB can store anything, CLOB stores char data, some additional info like charset and supports some char operations like search, so it's subset of BLOB.

I've worked with CLOBs on oracle...

Lynn Pettis (4/15/2013)

---

I think you are thinking of BLOB - Binary Large OBject or CLOB - Complex Large OBject.

I have used the term LOB - Line Of Business for many...

The statement is ok, but using identifiers (column names) with spaces and braces usually brings a lot of troubles.

First choice with such questions is in most cases google, then wiki, then forums, just because you have a high probability to get an accurate answer immediately.

OLTP = On-line Transaction...

Sergiy, you made my day lighter 😀

SQL Kiwi (12/3/2012)

---

It seems you wrote a test script that did not cover the full range of possibilities. Include CHAR(198) and CHAR(230) in...

I checked this: @@version=

Microsoft SQL Server 2008 R2 (SP1) - 10.50.2811.0 (X64) Apr 6 2012 01:59:29 Copyright (c) Microsoft Corporation Data Center Edition (64-bit)...

It's a lot more complex problem.

In a well designed database there should be no duplicates.

The simplest solution is to have proper constraints (primary, unique key) and have trigger validation on...