Hi Phil, if you're looking to minimise the down time I'd suggest partition switching

Ah, so I was on kid of the correct lines with where you'd put the data then 🙂

No worries, glad you sorted it and glad if you learnt anything from...

Ah DATES! right, you're probably running into the dreaded language / dateformat / @@DATEFirst issues.

Have a look at my below blog post and it should probably start to make some...

Ok no worries, can you provide the actual SQL as you are running in management studio and also as you are running in the report (this will be slightly different...

Ok so lets start with the basics as generally its the simplest things, so please excuse if I am stating the obvious.

Firstly are you 100% sure the two queries are...

Hi PSB,

Try something like:

;with Active as

(

select Location

from dbo.Listing

where status in('Active','Repeating Active')

...

Hi SomeDude,

The fact that you're hitting this table so hard is really the cause of your issue. The problem is, the engine has to do a sort operation for each...

I'm not sure if this is the best way but you could run profiler then generate the report, this will give you the sql thats been passed to the server

"The requested OLE DB provider Microsoft.ACE.OLEDB.12.0 is not registered -- perhaps no 64-bit provider is available"

This indicates it's expecting a 64 bit driver?

my head hurts 🙂 I was agreeing with you and was meant to be commenting on Jesse's post.

Yeah sorry quoted the wrong post, my bad 🙂

Take a gander at the post, its a count(). What you've said is obviously correct but wasnt the question that was asked 🙂

I've got to say I'm really shocked at some of the stuff people have said here around a very basic subject. (select * excluding nulls, count(1) and count(*) being different...

Hi, have you moved it to a new box or just upgraded the existing one? I appears that you are missing the access jet database engine dll on that server....

Hi, have you checked that SSRS is actually removing these characters and it's not just something like you're using a table without autogrow set to false?

Maybe whack it into a...