Lynn Pettis (9/17/2012)

---

I still doubt that ecommerce sites use your email address as a primary key. This is a volitale attribute subject to change, and isn't one I would...

I'll assume you want to count them separately. If you want a total...

DECLARE @year int

SET @year = 2012 --<<-- chg as needed

SELECT

month_start,

--'19000106' is a Saturday, so DATEDIFFs below count Saturdays:

...

GSquared (9/17/2012)

---

ScottPletcher (9/14/2012)

---

Code below has fewer calcs and does not depend on any SQL date settings.

DECLARE @year int

SET @year = 2012 --<<-- chg as needed

SELECT

month_start,

...

ben.brugman (9/17/2012)

Here ScottPletcher is the winner, but he used 'extra' intelligence to solve the puzzle using reasoning he solved part of the puzzle, if that is allowed, some more reasoning...

This is an old programming trick. When New York State used Social Security Numbers for student ids, they forced students to get an SSN or they assigned a dummy number...

ScottPletcher (9/14/2012)

---

SQL Kiwi (9/14/2012)

My guess is that there is no special cache for definitions; the pages of sys.sysobjvalues are cached in the buffer pool just like the pages of any...

Hmm, no good reason is materializing in my mind right now.

What method did you use to determine the freespace (change)?

SQL Kiwi (9/14/2012)

My guess is that there is no special cache for definitions; the pages of sys.sysobjvalues are cached in the buffer pool just like the pages of any other...

SQL Kiwi (9/14/2012)

It's always available from disk of course. Must be cached? No. Might be cached? ...

Better still, just always use 'YYYYMMDD[ 24h:mm:ss.sss]', which always works, regardless of SQL settings.

'20120427'

SQL Kiwi (9/14/2012)

---

They take up no space in the plan cache. The plan cache is...

A company I worked for produces clothing catalogs... They now have multi-part keys into almost all their other tables (Brand, Year and catalogue code) which slows down development, testing and...

Peter Brinkhaus (9/14/2012)

---

ScottPletcher (9/14/2012)

---

I never stated, or implied, that the comments would affect the execution time (I said "procedure cache", not "plan cache"; I know some people use them interchangeably,...

I never stated, or implied, that the comments would affect the execution time (I said "procedure cache", not "plan cache"; I know some people use them interchangeably, but I don't...