I think that's what I'm going to do

Ran this

RESTORE HEADERONLY FROM DISK='C:\cpsDEMO\democps10sp2.bak'

Back up name was incomplete and the rest of the columns are NULL

Double checked it is coming from 2008 r2

This is what I got.

Msg 3241, Level 16, State 13, Line 1

The media family on device 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\LeeAnnCPS12.bak' is incorrectly formed. SQL Server cannot process this...

I tried the other .bak file to see if it was a fluke about it working. It still works no errors. So I thought maybe the other two were corrupted....

Thanks for the advice its appreciated. Going to give it a shot after hours today. Local instances make coding so much faster without network lag.

I have not tried that. But I will give that a shot!

I made that into a permanent table and populated dates of birth all the way back to 01/01/1900 and then ran the Itvf against the computed column. The execution plans...

Lynn, if you haven't been told before "Your Amazin" 😀

Lynn Pettis (7/11/2014)

---

I am assuming that you are not talking about a persisted calculated column. That calculation, iirc, is done once and then stored. It isn't updated unless...

Nevermind

jcrawf02 (7/1/2014)

---

Grant Fritchey (6/30/2014)

---

If you're interested in query tuning, you might want to hold off purchasing a little while. I should have my 2014 update of the query tuning book...

I did this but now I'm embarrassed at seeing how short and sweet your guys is.

;WITH COLOR_CTE AS (

SELECT DISTINCT u1.Userid,u1.Name,

COUNT(uc.Colorid) OVER (PARTITION BY u1.Userid) AS UserCount

FROM USER1 as u1...

I'm getting that as well I actually decided to do both those and another one I stumbled on. So I will have 3 new books that should keep me busy...

Sounds like a purchase. Going to order it then, can't wait to read it! Thanks Jason:-D