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 = (

...

Btw, yes, PRINT is exceedingly slow. Use it only when absolutely necessary.

ChrisM@Work (9/14/2012)

It's quite common for a product to "evolve" over time without its' stock code changing - it's rampant in the fashion world. Clients, agents, reps all know an item...

stanlyn (9/13/2012)

---

Hi Scott,

Running your script, it returns:

Which begs the question on why the Page table has 3 PK_Page_Identity indexes, as it should have only one. That's the only thing...

Is the PK also a clustered index?

Is the identity column used in any another index?

Please post the DDL for the filtered index.