He's clearly testing Redgate's new temporal compression module for the toolbelt.

How else are we expected to provide solutions yesterday for the tasks we won't get a spec for until tomorrow?

In that case you seem to be reading a different question from the one I'm reading. The question I saw was about testing specific queries using the new cardinality...

TomThomson (5/15/2014)

---

sknox (5/15/2014)

---

Setting aside the trace flag issue (I don't blame the question writer for Microsoft's inability to write proper documentation) the only problem I have with this question is...

That will work if you are certain that your source string will ALWAYS contain at least one comma. If you cannot...

Toreador (5/15/2014)

---

Whatever the truth about the trace flags, I disagree with the answer.

In my opinion, the best way to test the behaviour of a particular database version is on a...

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

---

I'm torn here. I think good solid basics in an area are important. However I'm not sure to what depth someone needs relational knowledge. There...

Gary Varga (5/13/2014)

---

I think that the problem is twofold:

1) Graduates with Computer Science degrees have little understanding of applying what they have been taught in the real world.

2) Non-Computer Science...

trevelvis (7/7/2011)

---

I also had this challenge (in italics), so I changed to colour coded connections http://sqlfool.com/2009/03/ssms-server-settings/

Red for production, green for development, amber for testing...etc

I also make use of Local Server...

eseeweb (4/30/2014)

---

hi

I just have an update that we don't need to delete the record from the table as long as every time a record inserted can be write to a...

Wouldn't creating a new DEV instance with server collation matching that of your production server be easier.

I assume you have checked that the message sent on the Success condition hasn't just been copied unaltered from the one sent on the Fail condition.

downloads on MSDN are the same as the commercial versions so I would have though this would just need you to update the licence key assuming you aren't using an...

K. Brian Kelley (3/19/2014)

---

I don't think you're going to find a function with just distance. Maybe with a point. The reason I say this is in 2D space there would...

well the surest way is to run the code in the environment it is intened to be run but where that environment is producion it should be obvious as to...

I found the original B/W version much...