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...

EDIT: removed, posted in wrong thread.

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,

...

Lynn Pettis (9/14/2012)

---

/****** Object: UserDefinedFunction [dbo].[DelimitedSplit8K] Script Date: 09/14/2012 09:43:51 ******/

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DelimitedSplit8K]') AND type in (N'FN', N'IF',...

SELECT

TimeFrame / 100, CAST(TimeFrame AS int) % 100

FROM dbo.TimePeriod

WHERE

model= 'A1' AND

TimeFrame / 100 = (

...