I think you're looking at PLE from the wrong side - it's a measure of what has happened on your system, not what will happen.

if exists (select OrderDate from Order where OrderDate = CAST(Getdate() AS DATE))

Begin

...some code...

End

Note with this code, the if check will evaluate to true if any value of OrderDate in the...

Although it does occur to me - what's wrong with installing evaluation version of Enterprise edition? It's good for 180 days.

SQL Server Express with Advanced Services is free and comes with SSRS.

For SSIS/SSAS you're probably have to get hold of developer edition if possible - it's about £50.

MS used to...

Hi Mike,

What are the autogrowth settings on the log file?

I think you can get that if the log file is full & can't grow quickly enough for the query that...

All looks fine. If you're only using 6 or 7GB then you're not experiencing memory pressure?

SQL does use some memory outside & above the 4GB limit you set, other usage...

Nice question, thanks

Lynn Pettis (2/13/2013)

---

Gazareth (2/13/2013)

---

Hi,

Don't think it's that - things to check are all dates surrounded by single quotes ' (best practice would be to use ISO format - 'yyyy-mm-dd') and...

Hi,

Don't think it's that - things to check are all dates surrounded by single quotes ' (best practice would be to use ISO format - 'yyyy-mm-dd') and the column datatypes...

It's the 'StartDate 2011' bits - I intended that you'd put in the actual start/end dates for 2011, 2012 etc. Sorry if that wasn't clear.

Note I'm also assuming on your...

Ditto. Love randomly finding a thread with great information in!

No worries. Just noticed these are your first posts on the site - welcome to SSC!

wafw1971 (2/13/2013)

---

Thanks everyone, I have sorted it now with your help (See below for final code), however I now need to populate the table with 4 more years worth of...

Thanks

Still trying to tell what the CASE statements are intended to do. Given that data,

(SELECT SiteWeighting FROM Site WHERE SiteWeighting=1)=1 will always be true, so you'll always get 01/05/2010...

No worries, not a trace flag I've used before but not sure it'll help with date fields.

Out of range datetimes was about all I had for this - hopefully someone...