Cheers Grant.

My problem with these so far (this is really my first time using them in anger rather than in theory) is I am finding it hard to see what...

Cheers Courtney

Thanks again, Grant.

I've not got around to testing it yet, but just had a thought - will this still work with prepared statements? The application is prepared statement heavy.

Cheers

Alex

Aye, sorry, I just meant restore up to the marked transaction, so be that a full+diff+logs -- but my typing was being lazy.

Ahh I see! Cheers Grant.

So should I:

Create a marked transaction

Start a trace for N hours

Restore last full backup up to the marked transaction

And then run in the trace file?

Can...

Thanks All, I am making good progress on the development copy because of your replies. Going to leave it soak over the weekend with the simulator running against it, and...

Thanks Chris, this is excellent, I particularly like this:

SET @NextID = NextID = NextID + @IncrementValue

I've never seen such an assignment!

Douglas, thanks! Yes they have had the problem for years, since buying it. Their solution until I joined was to have processes to kill lots of spids that 'seem' to...

Edit: The SNAPSHOT and Cross Database Query aspect of Hekaton eliminates the use of that. Damn.

Hiya!

Yes, Enterprise Edition, currently 2008R2 but soon to be 2016/2014 Enterprise.

Row Count this morning is 94Million Rows

Modification, is done by the legacy app, mostly inserts but seldom updates where it...

Thanks all for the replies, as some new info has come to light, I think this situation can only lead to dead ends:

Multiple users login from the same desktop in...

Unfortunately that is giving the IP of the Application Server running the Service.

It's 3 tiers, User -> AppServer -> SqlServer

I can't get back to either domain user or the PC...

I have edited the original post for completeness, but to point out in case anyone doesn't re-read the original thread that table in question is actually 2.3TB not 500GB like...

To add more detail:

There are two main queries that will be run against -- lets call it the reporting query (its not an actual report per se, as its used...

Oh. Very interesting. You are changing my mind.

There are a couple of reasons for considering partitioning, Jeff - as follows:

1. Performance whilst not the focus it's also not lightning quick...