Thanks for this easy question. I faced this problem on the last month , I tried and it worked.

Nice and easy question. I was able to answer because I have some search about the meaning of the n parameter and the impact of the compression when it...

Arnie , happy Christmas for this beautiful Christmas tree.

A solution more complicated than the Steve' one but to see it is a pleasure , I have to have a look...

Merry Christmas for you , Steeve and for every posters on this discussion.

Knowing Steve's humor , I have only 2 possibilities ; the Christmas tree and the reindeer, the...

Excellent question Steve except that it is depending if the language is case sensitive or not.

I remembered a similar question on a MSDN forum and the explanation was : be...

Thanks for this nice question.

I have been able to answer it only because , as I am more a C# programmer , I have used it as a method of...

Steve Jones - SSC Editor (12/16/2015)

---

#1 is correct.

If I have a table and do this:

CREATE CLUSTERED INDEX ix_mybigtable ON dbo.mybigtable (id, largechar) INCLUDE (largechar2)

I get this:

Msg 10601, Level 16, State...

Jeff Moden (12/20/2015)

---

patricklambin (12/20/2015)

---

Nice question about a topic I have not used. But I have attended last year a session about Azure and SQL Server and the speaker explained how...

A good question and I was lucky to find the good choice ( maybe the other choices did not seemed very attractive ).

Thanks for it and for your explanations (...

Nice question about a topic I have not used. But I have attended last year a session about Azure and SQL Server and the speaker explained how to use the...

helenlu7 65408 (12/17/2015)

---

*= or

=*

Have been depricated since SQL 2005? long time ago ....

They were part of MS dialect of T-SQL, not compliant with Standard, so they had...

Thanks for this easy question ( not surprising as it is the week-end ).

Just a little remark : this question was treated 3 years ago in a session by an...

Thanks for this interesting QOT which proves me that even having spend more than 40 hours to study the operators , I have always a long way up to understand...

Hugo Kornelis (11/24/2015)

---

The correct answer is missing: "The table doesn't have a primary key". It's also suspect that all columns are nullable.

From the answer options I deduced that I needed...

Thanks for this easy question but I have a surely stupid question : why is it written " for a SQL Server 2014" ?

I have written many creation scripts for...