Not much of a hike then. Bray, home of the Fat Duck. I...

Are you working in Maidenhead, Rod?

My head was spinning like Dwain Camps's in a sweetshop...

dwain.c (3/4/2014)

---

I can do it with just two date function calls:

SELECT DATEADD(dd,DATEDIFF(dd,0,GETDATE())-1,'18:00')

I can also name that tune in...

This is an estimated parallel plan - estimating over 600 million rows output.

Are your stats up to date?

Any chance of an actual plan please? - just the SELECT. Ensure your...

I don't see the full plan when I load it here, it gets chopped at this point:

INNER JOIN Database_107.dbo.tblDatabase_107ExchangeRate AS XR WITH (NOLOCK)

ON O.Column_39 = XR.XRateCurrID

AND XR.XRateTypeID = 1

AND XR.XrateColumn_5...

IIRC SQL Sentry Plan Explorer has an "obfuscation" option designed with you in mind, Pete. It would help us a ton if you can do it.

GilaMonster (3/5/2014)

---

ChrisM@Work (3/5/2014)

---

GilaMonster (3/5/2014)

---

ChrisM@Work (3/5/2014)

---

If I script out the nc index containing the cluster key as an include column from the code I posted above, the cluster key column...

Can you post the estimated execution plan as a .sqlplan attachment please? And when you get the opportunity, the actual plan too.

GilaMonster (3/5/2014)

---

ChrisM@Work (3/5/2014)

---

If I script out the nc index containing the cluster key as an include column from the code I posted above, the cluster key column still shows...

SSISDB incorporates cascaded deletes and MS release it without including indexes for the fk's in the child tables. As a result, heaps of people (we don't have clustered indexes) saw...

GilaMonster (3/5/2014)

---

Not 'cannot be specified twice', actual 'cannot be present twice', so precluding SQL putting a...

Yes I know but...

If a column is...

GilaMonster (3/5/2014)

---

CREATE TABLE ReallyStupidTable (

ID CHAR(100),

OtherID INT

)

GO

CREATE UNIQUE CLUSTERED INDEX idx_Silly ON ReallyStupidTable (ID)

GO

INSERT INTO ReallyStupidTable (ID, OtherID)

SELECT ANumber, ANumber FROM (

SELECT TOP (5000000) ROW_NUMBER() OVER (ORDER...

GilaMonster (3/5/2014)

---

ChrisM@Work (3/5/2014)

---

If a multi-column clustered index includes a GUID, a nonclustered index which incorporates that same column either as a key or include column is going to be...