Forum Replies Created

Viewing 15 posts - 91 through 105 (of 813 total)

  • RE: Log file data transfer amount (MB) vs data file trasfer anount (MB)

    Take a look at what your app's doing.

    I checked one of my apps; for mostly small DML in tiny transactions, I can see log files with many times the data...

  • RE: Bitwise OR function

    From what it sounds like, you're not going to be indexing these values, just doing things based on the results. If there really are only 12 bits (months), then...

  • RE: Privacy and Data

    PHYData DBA (3/20/2014)


    In the last ten years I Have had the pleasure to work.

    With at least four different offshores that demanded real copies of databases to use in the development...

  • RE: TEMPDB on RAM

    sql4gnt (3/17/2014)


    Yikes. I did 9 passes with CrystalDiskMark on 2GB files. What options did you use? My screenshots for this test are at http://www.codepimp.org/2014/02/cache-money/

    What options...

  • RE: TEMPDB on RAM

    sql4gnt (3/17/2014)


    We ran some tests just at the storage level and the RamDisk was 13x faster. Here are the CrystalDiskMark results

    8x15k SAS Drives configured as RAID 1+0 and 100...

  • RE: TEMPDB on RAM

    Jeff, did you find IMDisk[/url] or one of the many other RAMDisk products? I'd really be interested to see the difference between a RAMDisk and a really good SSD...

  • RE: How Many Passwords?

    I've got some hundreds of passwords total, mostly in http://keepass.info/ after going into File, Database Settings, Security, hitting the "1 second delay" option under "Number of key transformation rounds", and...

  • RE: Who modified the JOB?

    In the past, you can't tell.

    For the future, the usual DML triggers on the msdb job tables can record this information. As always, beware of impersonation (i.e. ORIGINAL_LOGIN() may...

  • RE: NUMA & MAXDOP setting

    For diagnosis, try a few runs with different query hints - I'd usually try MAXDOP 1, 2, 4, and 8, then perhaps even 5 (just enough to guarantee crossing nodes).

    Also,...

  • RE: Best way to store images

    TomThomson (2/17/2014)


    But I can see cases where I would want to have binary data involved in transactional consistency with other data;

    To me the critical question is: Do changes/adds/deletes to the...

  • RE: Move SQL Server Machine to another Domain

    Markus (2/17/2014)


    Service ID for SQLServer will need changed on the Configuration panel...

    UserIDs: Need to give that service ID on the new Domain 'sa' rights...

    All users using their domain ID...

  • RE: The Security of Interconnected Systems

    Yes, we have newer rules to add to the old "never reuse your password" and "never reuse your security question" rules - "never reuse a credit card number".

    Non-refillable Visa gift...

  • RE: Prevent overlapping of time events with an indexed view

    adrian.facio (2/17/2014)


    Hi Nadrek,

    I'm really sorry for responding so late. I looked your function andI liked it, I'm also interested in the performance comparison, I have the feeling mine will be...

  • RE: Time to Retire

    Luis Cazares (2/17/2014)


    Nadrek (2/17/2014)


    Word without the ribbon = LibreOffice.

    Solitare is under Games - after you use the Package Manager to search for it and install it, along with a bunch...

  • RE: Time to Retire

    Luis Cazares (2/17/2014)


    Nadrek (2/17/2014)


    Luis Cazares (2/17/2014)


    It's easy to take family members off of WinXP. Not so easy for companies that need lots of licenses and testing time to make sure...

Viewing 15 posts - 91 through 105 (of 813 total)