Forum Replies Created

Viewing 12 posts - 1 through 12 (of 12 total)

  • RE: Find weak login passwords in your server

    Have you considered simply enforcing password policy?

  • RE: Bad Automation

    I go a short step further than Timothy, and drag the window down to the extreme lower right of my screen. When I'm done with dragging, only a few...

  • RE: Performance hit when running concurrent queries

    You mention that "The processor runs at 100% whilst running the query and then drops back to usual usage". If both processors are running at 100% even when you...

  • RE: Data encryption (column level)

    My company uses xp_crypt for encrypting credit card numbers. The package has performed well for us and is not expensive. Support is by e-mail but is prompt.

    Xp_crypt's performance...

  • RE: Disk Setup

    The page http://www.acnc.com/04_01_01.html shows comparisons between the various RAID levels.  Searching google for RAID will turn up more explanations if you're interested.

    To address your question, RAID 5 is fast for...

  • RE: Encryption with XP Crypt

    We are using xp_crypt to encrypt certain fields in our database.  If you use this product and you want to "encrypt a particular table", you would do that by encrypting...

  • RE: Decimal versus Money and division

    A close reading of SQL Server Books Online strongly implies that MONEY and SMALLMONEY are stored as "bigint" and "int" datatypes with an implied decimal point. This means that...

  • RE: QOD 6/10/2003

    I also agree with viacoboni.

    Removing the locking hint completely without also putting "where InventoryCount > 0" in the update statement will "fix the problem" but create another, more...

  • RE: Backup time increased

    It may be possible for you to reduce your backup time significantly from 5 hours by changing hardware configuration.

    For example, we have a 10.5 gb backup running from a 3-year...

  • RE: Enterprise Manager strips parens from constraints

    Thank you. I stand corrected.

    So here is the deal. EM parses the sql expression and strips out UNNEEDED parentheses, while leaving needed parens in place. For example,...

  • RE: Enterprise Manager strips parens from constraints

    Steve, it's funny that your version keeps parens some of the time, 'cause mine doesn't. I wonder if I'm missing something.

    You're right about the precedence giving the correct result...

  • RE: Enterprise Manager strips parens from constraints

    Good idea Jody, but it doesn't help.

Viewing 12 posts - 1 through 12 (of 12 total)