Thanks for this, I was just looking for some way of reversing the varbinary to SID. Trying to see just how much work I need to do as part of...

I had an instance once where we were being pushed to deploy a small website internally with the SA password in clear text in the page and hence clearly visible...

We set the same exclusions, however it looked like the AV was actually scanning the network traffic that was comming into the SQL Server exe. Rather frustrating.

Pual

Those are some useful DMV's, cheers for the pointers.

In response to some of your queries;

Querying dm_exec_requests the current percent complete is sat at 0 and showing an estimated completion time...

Thanks for the insight.

We suspected as much with the threads being hung, we have tried stopping and starting DTC but alas it has not worked.

It is looking more and more...

Cheers for that, I know I can't kill a rollback. Rather trying to force the damn thing to get a higher priority so that it actually actions. We are indeed...

That is what we were thinking, the fact that there is no compatability mode for 7 on 2008.

Cheers for the comment on BULK INSERT, nice to know that others are...

Cheers for that, I had not thought about using the script task to do that. I'll have to explore things a bit more.

🙂

How big are the tables that you are looking to partition, also what are the typical quieries that are being run against them? To be reaching the limit of BIGINT...

Cheers for the ideas.

In the end I chose to break things down and did things in the following manner

1. Create partition function & scheme

2. Rename data table with sp_rename

3. Create...

My personal preference in this situation would be to break things up with multiple files/filegroups and only use hardware RAID.

You can find a bit of information at the following link...

Don't suppose you could send me the RDL so that I could have a quick play with it.

I have done a load of stuff with default/refreshing parameters recently, just finding...

In the end I convinced the powers that be on a different drive configuration, basically haggled the hardware vendor down enough to get the number of drives for a good...

Correct me if I am wrong but does AX 4.0 use filtered views to pull data back when used with SSRS.

In AX 2009 you retreive data from the AOT Query...

I found out that the chain was being broken by out Sys-Admins taking system snapshots with BESR by symatec even though it was not activly backing up the databases with...