Good Deal, learned something this morning...

Just a side note, it could be NO if SQL's default collation is not used.

CREATE TABLE mytable ( myid INT <-------------------

SELECT COUNT(MyID) <-------------------------------

SELECT COUNT( DISTINCT MyID) <--------------------

The select statement will...

Interesting, learned about the Y2K38 bug today.

Happy New Years Everyone!!!

Interesting, but I learned two things.

Tested on SQL 2005, and received the following error message:

Msg 2715, Level 16, State 7, Line 2

Column, parameter, or variable #5: Cannot find data type...

Interesting Question, thanks!

Happy Thanksgiving Everyone!!!

Yea, the United States has taken the day off...........again....;-)

Maybe its me. Once I had BASIC loaded on my Altair 8800, I can not seem to remember anything before that (like my wedding, children being born, Jets winning...

I could swore that it was sometime in 1975?

It is better to be lucky then good...

I knew they were all functions, but this morning I guessed correctly.

Interesting questions.

If you asked the question: "What is recommended memory requirement for SQL Server 2012?",

why is the link that you provided go to the web page titled "Hardware and Software Requirements...

Interesting Question, I ran it a couple of time to see the different results...

Good Question, thanks!

Learned something new...

It is an interesting question, it just needed some testing before it was published.

Good Question, learned something...