If SQL 2008 was part of the choices, my guess would have been wrong as I decided to choose the newest of the three.

Basically, page 3 blew me away 😀

This is...

I read up what is the definition of count_big before I answered half-blindly. I never used it before and I may use it only years from now, since our...

To the ones who posted the redone (one concise, another well-defined) , I can say your versions were well thought-of.

Here's to hoping the QOTDs will be much better with the...

This discussion may have ended a few pages ago if those who complained gave a specific makeover of how the QOTD could have been.

When members feel there is a better...

I think this was about cross join?

I use these kind of statements to generate the possible valid sales of products against a table of customers. The generated table/view becomes...

Question?

I followed an advice when formatting hard disks for SQL servers, I should choose the allocation unit size to match the SQL extent size is 64KB (another reference: Disk Partition...

I have never been so glad to be wrong! I think some of my SPs with temp cursors may meet an end.

Thanks! I hope I got this right: if the WHERE clause will create a result or boolean TRUE (1), then the SELECT part makes a change, if the SELECT...

I got the answer right because I was looking at the logic, 'where 1=0'.

But when I changed it to 'where 1=1', the output came out as 0.

If a 'A SELECT...

Technically, the laptop was a good choice given you wanted years of use. I personally bought a Lenovo laptop also.

Question: what was the OS? Was it Win7 64-bit?...

i am finding a relation over time between cross-experience and degree of closed mindedness, as well as amount of respect towards other people, or self-respect since it all starts within...

the content inside a can, cannot know the content outside the world. 😀

intEmployeeID vs. EmployeeID, nvarcharCustomerCode vs. CustomerCode ?

mine is based upon a variety of experience, but i do not...

in databases where i have to make a front-end vb.net application, i find it easier to tibble the column names. but maybe this was because i was under the...