Forum Replies Created

Viewing 15 posts - 39,511 through 39,525 (of 49,552 total)

  • RE: Decrypt Password

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic704057-359-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 24, 2009 at 11:28 am

    #983712

  • RE: Row level locking

    If all queries were coming from the same connection, there would be no blocking in the first place.

    I don't understand your concern with snapshot. It's an optimistic concurrently level that...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 24, 2009 at 11:06 am

    #983698

  • RE: Stored Procedure

    Please post some existing sample data from the table. The very first link that I gave you shows how to do that easily.

    Why can't you change the table structure?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 24, 2009 at 10:37 am

    #983679

  • RE: LOGON TRIGGER HELP

    Check the SQL error log. Any errors or prints from a logon trigger go in there.

    I would suggest wrapping the code in a TRY.. CATCH block and have the catch...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 24, 2009 at 10:29 am

    #983675

  • RE: Row level locking

    If your indexes are all optimal you should be getting row-level locking anyway.

    Have you considered snapshot isolation? It'll hit TempDB hard if you have that much activity, but you'll have...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 24, 2009 at 10:24 am

    #983674

  • RE: Database backup

    Jeffrey Williams (4/24/2009)

    What Gail was trying to get at is that overwriting an existing file destroys any maintenance plan you setup.

    Note to self. Get to the point..., 😉

    ...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 24, 2009 at 10:07 am

    #983666

  • RE: Row level locking

    usman.tanveer (4/24/2009)

    Thanks for the reply Grant, i agree but i have no other choice to try this if possible, as the queries are coming from a dll (which i cannot...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 24, 2009 at 9:48 am

    #983651

  • RE: "Database 'COMMON' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details."

    Jeffrey Williams (4/24/2009)

    sharanurampur (4/24/2009)

    Dear Friends,

    I too don't know the exact problem, what I am predicting is we are having 2...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 24, 2009 at 9:46 am

    #983648

  • RE: Code level changes while migration from SQL Server 2000 to SQL Server 2005

    Grant Fritchey (4/24/2009)

    However, it's possible to have written a data access layer that won't work with 2005 (I know because two different development teams in my company did it). You...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 24, 2009 at 9:41 am

    #983646

  • RE: Database backup

    One thing I would like to get clear.

    Are you backing up the transaction log to the same file every time?

    Do you have the overwrite option specified?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 24, 2009 at 9:40 am

    #983644

  • RE: How to prevent column name changes

    Steve Jones - Editor (4/24/2009)

    The functionality is there for design and DBAs, not normal use, and not daily use.

    And auditing. In fact, I'd almost go as far as saying...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 24, 2009 at 9:39 am

    #983642

  • RE: A strange problem with 'select' performance

    johny (4/23/2009)

    and now I want to know why this phenomenon happened.

    As I said, if the column is varchar and the string literal is NVarchar (as in your slow examples), the...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 24, 2009 at 7:32 am

    #983529

  • RE: Database backup

    Hang on.

    You're backing the transaction log up every 15 min, writing to the same file and specifying overwrite? Is that correct?

    Why full backups ever 2 hours? That's awfully frequent, especially...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 24, 2009 at 7:14 am

    #983513

  • RE: One Backup File on two different Disks

    bhuvnesh.dogra (4/24/2009)

    but How do i restore it

    can u please provide the restoring script?

    Did you check the syntax of the RESTORE command in Books Online? Like backup, there can be...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 24, 2009 at 6:32 am

    #983489

  • RE: Multiple daily log backups required in a clustered and mirrored environment

    Schadenfreude-Mei (4/24/2009)

    1. The log grows to the extent whare it cant be backed up in the windows between backs (the log is backed up every 15 minutes but takes 20...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 24, 2009 at 6:27 am

    #983480

Viewing 15 posts - 39,511 through 39,525 (of 49,552 total)