Forum Replies Created

Viewing 15 posts - 12,091 through 12,105 (of 49,552 total)

  • RE: Script to reset password for SQL 2000

    That's 2005+ syntax.

    Look up sp_password for SQL 2000 and older.

    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

    August 14, 2013 at 4:14 pm

    #1641611

  • RE: sql server automatically opening a file handle for every database file

    Erland Sommarskog (8/14/2013)

    if you have a server with many, rarely-used, databases, it may make sense.

    Or a sever with a few heavily used databases and a few very seldom used databases...

    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

    August 14, 2013 at 4:10 pm

    #1641609

  • RE: sql server automatically opening a file handle for every database file

    No, but there's a way to not open the database at all until someone logs in. It's usually a bad idea.

    Why? What problem is this behaviour causing?

    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

    August 14, 2013 at 4:04 pm

    #1641607

  • RE: What do you open a logfile with?

    I assume you mean ERRORLOG, ERRORLOG.1, etc. They're text files, any text editor or word processor can handle them

    Double click the file. Windows will bring up a dialog that says

    Select...

    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

    August 14, 2013 at 4:02 pm

    #1641606

  • RE: sql server automatically opening a file handle for every database file

    Because part of the startup process is opening and recovering every database. If it didn't, then the first time a user connected they'd have to wait for the recovery process,...

    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

    August 14, 2013 at 3:52 pm

    #1641599

  • RE: What do you open a logfile with?

    What file are you trying to open?

    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

    August 14, 2013 at 3:49 pm

    #1641598

  • RE: What do you open a logfile with?

    I usually use UltraEdit for it's ability to automatically reload the file on change.

    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

    August 14, 2013 at 2:55 pm

    #1641580

  • RE: checkdb and snapshots

    What's in the error log?

    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

    August 14, 2013 at 2:51 pm

    #1641575

  • RE: What do you open a logfile with?

    Notepad or any other text editor. The error log files are plain text.

    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

    August 14, 2013 at 2:50 pm

    #1641574

  • RE: Restoring a database and simultaneously increasing it's file size

    Extent fragmentation has to do with the position of extents within the file, not the file in the storage system. No amount of backup/restore will change the position of extents...

    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

    August 14, 2013 at 2:48 pm

    #1641572

  • RE: Restoring a database and simultaneously increasing it's file size

    Maybe. Why's it so essential that the files be contiguous?

    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

    August 14, 2013 at 2:10 pm

    #1641559

  • RE: Restoring a database and simultaneously increasing it's file size

    Maybe, maybe not. Depends on way too many factors to answer.

    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

    August 14, 2013 at 12:31 pm

    #1641536

  • RE: Restoring a database and simultaneously increasing it's file size

    A restore will recreate the database as it was at the time of backup. If you want something different, do the restore then make the changes.

    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

    August 14, 2013 at 12:01 pm

    #1641519

  • RE: Operating system error = 3

    If E drive is a cluster resource and is currently owned by the active node then the drive will not be present on the passive node at all, as expected.

    But...

    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

    August 14, 2013 at 9:29 am

    #1641462

  • RE: Sql Server 2008 R2 Partitioning

    If you want to partition the clustered index (a unique one enforcing the pk), you have to include the partition column in the key, it's not optional. If you don't...

    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

    August 14, 2013 at 9:06 am

    #1641451

Viewing 15 posts - 12,091 through 12,105 (of 49,552 total)