Grant Fritchey (6/1/2016)

---

jasona.work (6/1/2016)

---

You know what's annoying?

When you're reading something, think of something (maybe related, maybe not) that you want to look up, and in the time it took to...

Jeff Moden (5/31/2016)

---

"SQL Fertilization" is when you go crop dusting in the server room. 😛 Gives new meaning to the term "It Depends". 😀

Either that or it's a "code...

You people must have been very lucky or very unobservant.

In...

Mighty (6/1/2016)

---

Choose the "correct" answer by eliminating the ones that were definitely correct.

Agree with the rest, code is working and no error occurs. A bit strange though, because according...

I looked at the code and there was obviously nothing wrong with it. 😎 So why say there was an error ?

I looked at the options -...

sabinweb (5/28/2016)

---

One remark:

`... and varchar defaults to 30 if not specified` ?

Default value is 1 for the char and varchar data types

Default value is 30 when the char or varchar...

I guess you might think "brandewijn" is...

Never heard of this command before, didn't find any documentation on it, so I created a database to try it one (not wanting to risk doing something horrid to any...

Nice question, but the reference chosen (https://msdn.microsoft.com/en-us/library/ms188371.aspx, the "GRANT Object Permissions (Transact-SQL)" page) was an unfortunate choice, because it still omits the important statement that column level grant overriding table...

jasona.work (5/18/2016)

---

I'd honestly expect smaller businesses to be the ones that will take longer to move to automation like this, for several reasons. One would be the most obvious,...

Chance

The trick for counting CHAR(0) in a string is to count the number of length one substrings that are equal to CHAR(0). Gloriously inefficient, of course, but I don't...

Jeff Moden (5/14/2016)

---

IMHO, no. It shouldn't return a NULL when the delimiter is NULL. It didn't find any NULLs as delimiters and, just like not finding a comma...

It means that you work for things that need you and you want to help, instead of for things that pay you.

I'll be a...

Hugo Kornelis (5/13/2016)

---

....

But here's another picture. Imagine a transgender. Born a boy, but feeling a girl inside. After a long period of mental pains and uncertainty, decides to start the...