What is the *REAL* question here?

My mistake , easy 1 point for the question 🙂

An easy question can be very tricky especially in the morning 😀

Easy 2 pts 🙂

Hi, looks like a task for an exam 🙂

It is just a math - it has nothing to do with SQL Server

as the data could be stored in a flat...

Could be here:

sum(case when Day (Tran_Dt)= Day (GetDate()-1)and Tran_Typ = 'DT' Then MRP End) as 'MRP'

maybe you should add also ELSE phrase?

And in where:

Where CAT in ('CDMA')

Why just...

Well - you could use ROW_NUMBER() to remove dups howerver I am not sure whether you can use it in the mentioned case - it is too early to think...

I chose YES as the "second " sentence was OK 🙂

Hence the "first" question should has answer to "NO"

Of course it is possible - I must have been blind in the morning 🙂

Hugo Kornelis (10/16/2009)

---

If, and only if,

a) the average length of data is only...

cengland0 (10/16/2009)

---

This one got me again. Another trick question.

The question asked, "Which of these data types will be more efficient?"

Had it asked, "Which of these data types take less...

There is one more interesting thing. Fixed length columns are placed in the same place in the row, whilst all columns like varchar, nvarchar etc are at the end of...

hodgy (10/14/2009)

---

arghh!! I spent a few minutes playing with a spreadsheet to mock up the bitwise AND and OR functions (a happy little diversion) and i missed the data type...

Tricky question especially in the morning 😀

This is common question I have seen many times on various newsgroups :).

But - have you ever used the option - lightweight pooling set to on? There are not many...