I sure did a smart thing by adding the SQL SERVER 2008 R2 reference. Once again the question section works for me not in form of answers but the discussion...

WOW! This discussion is getting a lot of interesting replies and in depth analysis. I just hope that the OP is getting as much knowledge out of this as I...

Koen Verbeeck (11/18/2014)

---

Great, so you just copy pasted a response from Celko. Now I...

I'm not saying money is the best thing ever and it sure has it's issues, but just to go around declaring it should never be used is one step too...

Here is the MSDN reference:

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/de0e5cfe-b984-4700-b81f-a0478a65daf1/difference-between-numeric-and-money-data-type-in-sql-server?forum=transactsql

I hope this helps in further clarification regarding money data types.

Disadvantages of money datatype:

It is proprietary, so porting it is a pain. It is one of the many "Sybase Code Museum" features from decades ago. Remember the early versions of...

First of all using money data type is not recommended because it is not precise. Instead use numeric column. You can always append currency symbol at UI level of reports.

Now...

I faced a similar issue a while back. In my case there was a dynamic SQL block in the proc which was creating problems due to creation temp tables.

One way...

Good Question. Easy One.

Once again an example of badly phrased question. Makes me think that an option to rephrase or un-publish should be provided.

Rune Bivrin (11/14/2014)

---

Minimum:

Express Editions: 512 MB

All other editions: 1 GB

Recommended:

Express Editions: 1 GB

All other editions: At least 4 GB and should be increased as database size increases to ensure optimal...

Ah! Read the options in a hurry and ended up selecting the incorrect answer.

Next time I will will count to 10 slowly before answering.

Nice question.

This trace flag has existed for some time but was documented only in SQL 2008.

It works for SQL 2008, 2005 and 2000 SP4 (not tested) update.

Here is the source with...

Raghavendra Mudugal (10/22/2014)

---

Thank you for the post, really eye opening.. And really had no idea what this was.

I read it and without any research, i selected the choice and got...

The question is phrased wrong.

How many rows will be return from using this UNPIVOT query?

How many rows affected [Answer = 3]

VS

How many rows returned [Answer = 2].

As per the...