Forum Replies Created

Viewing 15 posts - 391 through 405 (of 814 total)

  • RE: Remote login to SQL Server

    While the other answers will help you do what you're currently doing, I would suggest that what you're doing is a horrifically bad idea security-wise.

    What I would suggest instead is...

  • RE: TempDB Nightmare

    Open up a separate copy the saved tempdb.mdf in a hex editor (like HxD[/url]) in read only mode, and see if there's anything you recognize in it!

    Alternately, for those that...

  • RE: SQL Server Browser & DAC

    L' Eomot Inversé (6/13/2012)[hrI suspect the point he is attempting to make is that a competent administrator will succede, not fail, because if he knows the port numbers he can...

  • RE: Keep Track of 10 Password's History Table.

    Given the LinkedIn+eHarmony+Last.FM breach bring people's awareness back to password choices, I'll link to my long prior post in the below thread:

    Should we outsource identity management

    It boils down to: to...

  • RE: Random run duration for a SQL job

    elaelian.prelani (5/10/2012)


    In general, this package has to import some tables from several databases hosted by different server to my database hosted on my own server.

    Set up steps to record...

  • RE: Avg Disk Queue Length

    htt (5/9/2012)


    Hi guys,

    I ran perf monitor and saw the number for PhysicalDisk:Avg Disk Queue Length is 2.93 during an one (1) hour period (interval is 15 seconds). This is...

  • RE: sp_Find2

    magnus.eklof (5/10/2012)


    It was prob a little fast in the making... in the comments it says sp_Find4, and whole chunks was missing from the 'else' statement I noticed it did not...

  • RE: How do you back up a 3TB database

    Tim-153783 (5/8/2012)


    Have you tried to just backup to the NUL: device to test out how fast you can read?

    Have you tried to benchmark how fast you write?

    I hate...

  • RE: Mobile Password Protection

    LadyRuna (5/7/2012)


    From examining several phones belonging to various people, I have determined that the "fingerswipe password" is essentially useless as security. It can perhaps prevent someone from accidentally opening your...

  • RE: Mobile Password Protection

    Steve Jones - SSC Editor (5/7/2012)


    Few, though some companies will do it in a relatively short time. An hour or so if you've lost control.

    I assume that's at most an...

  • RE: Mobile Password Protection

    This is simply a specific instance of the generalized case of offsite remote access/offsite data storage, combined with what are often some of the least useful "security" measures every kludged...

  • RE: RAID and Its impact on your SQL performance

    rbarbati (5/2/2012)


    This is a nice article, but possibly a bit dated and not really considering higher-end enterprise-scale subsystems that are available and more common these days, where RAID is not...

  • RE: RAID and Its impact on your SQL performance

    tony.turner (5/2/2012)


    Sounds suspiciously like your hosting company has been listening to their EMC salesperson. EMC apparently is strongly in favour of RAID 5 for SSD, thus the loss of a...

  • RE: RAID and Its impact on your SQL performance

    piotrka (5/2/2012)


    Thanks Nadrek for your response. It was my understanding that RAID 10 is superior over RAID 5 on writes. However; using the same number of hard drives,...

  • RE: RAID and Its impact on your SQL performance

    tony.turner (5/2/2012)


    Sounds suspiciously like your hosting company has been listening to their EMC salesperson. EMC apparently is strongly in favour of RAID 5 for SSD, thus the loss of a...

Viewing 15 posts - 391 through 405 (of 814 total)