JustMarie (10/15/2015)

---

Wow. Just wow. I wrote that over six years ago and it's still helping people.

I'm kinda choked up right now. And I'm also glad that I...

JustMarie (2/18/2009)

---

OK - here's the short answer on how I did this.

Create a Derived Column transformation, create a new column, and put this in the expression field. Use your...

Well darn. I trusted Books Online instead of testing it out for myself. Good to know. Thanks Andy.

Nice practical example. Thanks Steve.

Interesting behavior for sure. Thanks for the question.

Interesting question. I was sure it would give an error.

I was so sure I was going to get this right. Should have made sure things were the same in 2012 and 2014.

Nice question, Naveen! A good example at the importance of choosing the correct datatypes. Thanks.

Xavon (7/15/2015)

---

The answers should have been a little more varied; as soon as one recognizes that restrictions 1 and 2 are both true, then 3-5 do not matter because 'all...

Nice question Pramod! I'm looking to install a test copy of 2016 sometime soon and I may have to play around with this feature.

I presumed there was a typo too and got it right. I still reviewed all of the choices 5 times though before choosing the one that appeared to be the...

Nice question on something I haven't really looked into yet. When I heard about this before I thought it would be a partitioning option to store data in Azure instead....

Nice question Tom. I haven't used the STR() function before.

Nice and easy for me. One of the many benefits of writing out all of my create/alter/drop statements versus using the designer in SSMS is that I am very familiar...

Easy one for a Friday. Thanks!