Forum Replies Created

Viewing 15 posts - 1 through 15 (of 25 total)

  • RE: Convert binary SID to string

    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...

  • RE: Running as SysAdmin

    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...

  • RE: SQL Server and AV

    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.

  • RE: Kill and rollback issues

    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...

  • RE: Kill and rollback issues

    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...

  • RE: Kill and rollback issues

    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...

  • RE: BULK INSERT in SQL 2K8

    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...

  • RE: SSIS in multi domain network

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

    🙂

  • RE: Building a good Partitioning-Key

    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...

  • RE: Index & Partition advice sought

    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...

  • RE: Windows Dynamic Drives for SQL Server

    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...

  • RE: SSRS Parameterization

    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...

  • RE: RAID configurations

    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...

  • RE: Dynamics AX 2009 SSRS

    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...

  • RE: Differential Backup Failures

    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...

Viewing 15 posts - 1 through 15 (of 25 total)