Ed Wagner (12/1/2015)

---

Even though it looked horrible, I'm not surprised by the answer. I must admit I liked Hugo's answer: Someone would get fired. Well, perhaps at least...

I got the answer right, but with the wrong (or different?) theory...

I was looking at the size of the CHAR value... I figured that because it is lower, it'll use...

You should probably demonstrate your database structure and the type of queries you are running.

As a Data Warehouse company with a 3TB database, we installed SQL Server 2014 and configured...

If there is one thing I've learned from SQLServerCentral is that you should always...

Very nice article and it clearly explains what Apply is used for!

I feel that you should've included some "tricks" to improve performance on big queries to see the real benefit...

wow what a complex way of doing it.

I'm usually just doing this 🙂

DECLARE @tmpString VARCHAR(MAX)

SELECT @tmpString = COALESCE(@tmpString + ', ' + productname, productname) FROM Header

SELECT @tmpString

Maybe add to the explanation that SMALLDATETIME is 1900-01-01.

Maybe some people doesn't know the ranges are different

Would the first query not use the clustered index?

It makes no sense why it would even consider the non-clustered index

+1, didn't really know its possible (well just never thought of it)

Are...

I think the explanation need some work.

CTEs doesn't ALWAYS need a semi-colon in front.

This for example works fine:

DECLARE @tmpVariable INT

WITH cte

AS

(

SELECT 1/0 as 'Result'

)

SELECT *

FROM cte

I'd...

pmadhavapeddi22 (8/6/2014)

---

Hany Helmy (8/6/2014)

---

Easy, another fast way (but maybe not the fastest), just highlight the table then press Alt + F1 will give you all table structure, definition, columns names,...

lol.. I got this by accident.. I was assuming a print function won't fail the query and didn't even notice the string is longer than 15 chars.

Bhuvnesh (11/6/2013)

---

Tej_7342 (11/5/2013)

---

There are 2.2 billion records in the table and we want to only keep 2 weeks data, as of now we are lagging behind so we want to...

Why not consider running the job daily then instead of weekly? ...

I wonder what was the thinking behind the third answer?

Why would someone think '10' will be returned if you entered '40' at the insert?

Maybe I was just clever to read...