Forum Replies Created

Viewing 15 posts - 4,681 through 4,695 (of 7,496 total)

  • RE: Piecemeal Restore SQL 2005

    - Wouldn't you be better off setting up db-mirroring ?

    (maybe even using db-snapshots to use the data you want)

    It will keep up with the updates if...

  • RE: Monthly SQL Crashes

    I'm in Toronto this week spending some quality time with the family :w00t:

    I'll see if I can get the info you requested.

    Johan

  • RE: Monthly SQL Crashes

    BTW the new drivers are:

    HP DL380G5

    ComponentFirmwareDriver

    Bios P56-01/24/2008-

    ILO1.431.13.0.0

    Networkcards2.1.2.04.4.21.0

    Raidcontroller1.786.12.4.32

    Videocard-6.14.10.6744

  • RE: query taking too much time

    GilaMonster (7/21/2008)


    ALZDBA (7/18/2008)


    And sweet is the odor of victory 😎

    But sometimes no one acknowleges it ... "after all you just did your job".

    The best part was that a few months...

  • RE: query taking too much time

    Oh indeed, sqlserver will try to make its work as easy as possible by grabbing all the ram it actualy needs.

    Probably it decided to grab some more because of the...

  • RE: How to Query when SQL Server 2005 SQL sql authenticated account will expire

    Thank you for providing the extra parameters Jeffrey.

    Apparently those weren't in BOL sep. 2007

  • RE: How to Query when SQL Server 2005 SQL sql authenticated account will expire

    I don't have sql2005 on win2003 right now, but according to BOL

    you can check it using:

    LOGINPROPERTY ( 'login_name' ,

    ...

  • RE: Monthly SQL Crashes

    till today that driver-fixed server has been running fine after the upgrade.

    We're planning on doing the same operation on the other 3 servers next tuesday.

    No dump, no eventlog, no nothing...

  • RE: query taking too much time

    GilaMonster (7/18/2008)


    You haven't got a clue what you're talking about! (Said to me in a meeting that included most of IT management)

    And sweet is the odor of victory 😎

    But sometimes...

  • RE: Half a Million

    Did anyone notice SSC crossed the 800000 members some time ago ?

    Good job guys 😎

  • RE: query taking too much time

    GilaMonster (7/18/2008)


    My favorite was a java-based messaging app that passed all string literals as N'... despite defining the table with varchar columns.

    Net result, index scan of around a million rows...

  • RE: ALTER SYS SP in SS2K5

    there is one thing I can say about modifying system stored procedures:

    it is a big nono[/b]

    If you do it, sooner or later, you're going to pay for it.

    You just...

  • RE: query taking too much time

    GilaMonster (7/18/2008)


    ALZDBA (7/18/2008)


    We have recently had an issue where the same query on an equal table

    one using nvarchar, the other using varchar. (indexes same indexes on both objects)

    Implicit conversion...

  • RE: xp_cmdshell

    ZA_Crafty (7/18/2008)


    Well, this will go into a sql job. The reason I have it as tsql, is so that the file name can be dynamic.

    the idea is to email a...

Viewing 15 posts - 4,681 through 4,695 (of 7,496 total)