Thanks guys, that gets the job underway...

Cheers, Peter

Hi,

Wow - what a prompt response - very much appreciated.

"Can't you do what you need to do on all affected records at once" - I guess this is what I...

Yep - we have been down this path and have actually achieved it using real .Net enums (as used in our app) within SQL Serevr 2005.

We use an excellent, i.e....

Hi Claudia,

Yes, we are currently using vertical filters - this is what seems to be causing the problem. The standard sp_msupd, del & ins stored procedures are created from...

Yes - this was a bit of an issue trying to sus out the best approach. What we do now is the following. Obviously all users are logged off.

Backup the...

We went the replication route and are very happy with it. We have two servers (Data and App). Suprise suprise, Data just runs the database and App the application. We...

Hi Guys,

Thanks - these are great generic tools that look like they will fix the problem and I can already see other uses for them.

Cheers, Peter

Hi,

Sorry, forgot to mention - it is Push replication.

The status of the jobs is: "closed down successfully" which seems to indicate its not a failure as such - the shutdown...

Mama mia - brilliant advice.

Have changed my FromDate_LU to Convert(DateTime,@FromDate,120) and have supercharged the app. A 57 seconds query now runs in...

Take a look at the fine articles in this forum on why it is 'very bad' to use cursors. I haven't looked at your SQL at all other than to...

Hi,

FWIW just be aware that the TIMESTAMP data type isn't a time stamp at all - just a number that SQL Serve ensures is unique in each database.

Cheers, Peter

Hi,

I has the same concerns. We have a backend database and an app server. Both are single Xeon machines with 2Gb memory.

We used push transactional replication from data server to...

Hi,

This is slightly off topic but why is using a GUID for a PK considered bad practice?

We use replication so GUID's as PK's (not clustered) are the way to go...

Hi,

I'll just relate an incident from just a couple of days ago. I had a 10 second proc that ran < 1 second in QA. Took me a while to...

Hi,

Thanks for the hint - I hadn't noticed that Profiler just has Recompiles and not Compiles so I wasn't comparing like with like.

My staus is both SysMon and Profiler agree...