Figured there had to be a trick to this, but no, it was as straight forward as it seemed.

free_mascot (4/15/2015)

---

Carlo Romagnano (4/15/2015)

---

Hugo Kornelis (4/15/2015)

---

But note that supplying an offset only produces the expected results if you can be sure that there is exactly one row per month in...

Doing a comparing to development is frequently untenable. It is development, it is where the developers go to play, and frequently forget to clean up after themselves. Not...

Stewart "Arturius" Campbell (4/1/2015)

---

actually,...

Personally, I have never been a fan of online VCS. The human aspect of public vs private aside, it has always just seemed less secure to me.

But it's the...

What's interesting to me is the usage of 'most'. I suspected c was right (since a and d were both wrong), but went looking to prove it. And...

SSMS mostly; haven't even tried SSDT.

Ed Wagner (3/26/2015)

---

Yeah, it's a poor question with a wrong answer. Granted, someone will always misinterpret the question, but doesn't this mimic real life? I get requests all...

This one may or may not be a bad comment. It appears to be a reference to a tracking ticket. And rather...

One thing I would like to add to this:

namely:

"or is saddled with requirements...

RLilj33 (3/9/2015)

---

This one threw me off. Can someone explain BOL (https://msdn.microsoft.com/en-us/library/ms189838.aspx):

"data_type

Is the data type of the identity column. Valid data types for an identity column are any data types...

My company uses Express on remote terminals (a couple hundred of them) that replicate up to Enterprise edition on our main server.

I have found the challenge and money are often mutually exclusive.

Large, established companies are frequently already set up well. The day to day business is fairly stable...

Nah, just declare DECIMAL(8,8). And get a really big hard drive.

:hehe:

Ah, but the space at least (and tab would be another one) is visible if you highlight the text. ...