haha - never mind then, we'll leave it there 😉

I've already changed my code and there are no errors in my job either, but thanks for yours as

well.

Righto Lynne, thats not the point I was making though - any comments on the SQL agent information?

Thanks for the input!

There wasn't actually anything wrong with the stored procedure, except when I called it from SQL agent...

Interestingly its not a well known fact but there were only...

Upgrade to W2k8, it sorts the alignment within the 0S...apparently ;-0

Upgrade to W2k8, it sorts the alignment within the 0S ;-0

Let me guess, the SAN admins also said to not worry about RAID 1, RAID 5, RAID 10 etc - since its a high speed SAN it does not matter?

Don't...

Thanks very much, its actually working out easier this way since the composite clustered index was designed for the selectivity of the queries against it in the first place

so makes...

I have 250 million row table that I wish to partition 10-15 ways in SQL2K8, single filegroup if possible.

Problem am facing is that I have a unique composite clustered index...

Same this side, can connect from SSMS on desktop but not on server logged on as service account.

Any results?

Yes the row counts and execution plans are the same - dev is refreshed overnight, agreed on the report time - it has to get faster quickly.

Agree with most if...

Certainly an option to consider - however prior to then am toying with the idea of stored the calcs as persisted in temp/permanent tables...indexed where possible.

problem I'm having is the...

Jeff, thats exactly it however the execution plan pretty much the same in the dev environment and it runs in 50mins which has been difficult to explain to be honest...

obviously...

Very relevant questions, unfortunately I've only just started so can't comment on row counts, changes in workload etc.

It was exactly the question I asked though and I've been told the...

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

Create function [dbo].[GMT.Calendar.IsPeak]

(

@date datetime -- This date should always be in country's local datetime

,@countryId int

)

returns bit

as

begin

declare @Result as bit

set@Result = 0

if (@countryId in (0, 230))

begin

if (datepart(hh,...

Apologies Gail, I've only just read the article...busy day.

You'll notice a distinct lack of indexes on the inserted table ( amongst others)...have experimented on dev and this has had no...