Even the best protocol can be poised with poor practices.

The problem with this solution is that the UDF assumes the same order of rows as the substrings in the input string, while the documentation for string_split says the order...

IMHO, that kind of person can't...

This works with sql server 2008 too.

create table #dates

(

RecordId int primary key clustered

,RecordDate datetime

);

insert #dates

...

Paul Hernández (4/22/2015)

---

Hi Tom, thanks for your answer.

Please forget my first post, I copied and pasted the query that SSAS issues, therefore contains this weird aliasing.

Here is a better...

Good article. It highlights the most common mistake made in triggers by developers coming to sql server from other databases which usually have row level triggers.

However, the example is strange....

Toreador (3/6/2015)

---

chgn01 (3/5/2015)

---

Sorry for the error on choice d). I did test for each choices. Not sure how it happen. Could Steve Jones please change it from...

What's wrong with output to a file/device/pipe?

It was a common practice in the age of dos.

It's still a common practice on unix systems.

Most modern windows users have the black-textmode-window-fobia....

Should be in humor category. 🙂 It says "select 5", 6th is so amusing that the correct answer is obvious even if you know nothing about the answers.

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