Forum Replies Created

Viewing 15 posts - 12,436 through 12,450 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    wolfkillj (7/8/2013)

    If you haven't seen this already, you're due for some Monday-morning laughs!

    Something broke with that link...

    http://www.buzzfeed.com/daves4/jokes-only-nerds-will-understand

    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

    July 8, 2013 at 6:06 pm

    #1630617

  • RE: log differences

    SQL Guy 1 (7/8/2013)

    Publisher database (I guess you call it General) must be in full recovery model

    Not true. Publisher can be in any recovery model

    Subscriber database must be in...

    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

    July 8, 2013 at 4:27 pm

    #1630608

  • RE: Tempdb issue

    No.

    What exactly happened and why is it a concern?

    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

    July 8, 2013 at 11:13 am

    #1630528

  • RE: Are the posted questions getting worse?

    Ignoring my mail, so hadn't noticed. No notifications today.

    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

    July 8, 2013 at 10:47 am

    #1630518

  • RE: Alter Stored Procedure with errors

    No.

    You can create a procedure that refers to tables that don't exist, but if the tables do exist, the columns referenced must all be there.

    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

    July 8, 2013 at 10:43 am

    #1630516

  • RE: Delete Table Variable

    DELETE FROM @TableVariableName

    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

    July 8, 2013 at 7:30 am

    #1630435

  • RE: Sleeping SPID

    Yes, it will take some memory, just for its threadstack which is 2MB (I think) on x64.

    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

    July 8, 2013 at 7:20 am

    #1630430

  • RE: Drop Database before Restore - Any Downside ?

    If you drop the DB then the first thing SQL has to do is recreate the files, including zeroing them out.

    Try taking the DB offline with rollback immediate.

    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

    July 8, 2013 at 7:19 am

    #1630428

  • RE: Sleeping SPID

    pujain (7/8/2013)

    what can I conclude from it ?

    Virtually nothing.

    All that tells you is the number of reads (pages read from memory) that the connection did from the time it connected...

    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

    July 8, 2013 at 6:57 am

    #1630417

  • RE: creating new ldf file

    It will use the first then the second then the first again then the second again, etc. The log files will only grow if both are full.

    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

    July 8, 2013 at 6:26 am

    #1630398

  • RE: Difference between Full backup and Copy-only full backup

    IT researcher (7/8/2013)

    I am not using differential backup in my environment. i use full backup and transaction log backup.So in this case taking full backup and copy only...

    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

    July 8, 2013 at 6:25 am

    #1630397

  • RE: Sleeping SPID

    Yes, they are a SQL Server connection and they hold a small amount of memory (2MB each I think) for the thread stack

    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

    July 8, 2013 at 6:23 am

    #1630396

  • RE: copy system database files

    mJai (7/7/2013)

    When I try to copy these files (master,model,msdb,tempdb), it says the files is in use and it does not allow me to copy.

    You don't need the TempDB files. Master...

    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

    July 8, 2013 at 3:31 am

    #1630366

  • RE: copy system database files

    Ratheesh.K.Nair (7/8/2013)

    Try This..

    1.Turn ON the Auto-Close option for databases

    2.Kill all connections

    and then try to copy the files

    He's talking about the system databases, not user 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

    July 8, 2013 at 3:30 am

    #1630365

  • RE: Difference between Full backup and Copy-only full backup

    Joie Andrew (7/8/2013)

    Copy-only full backups are the same concept as copy-only log backups. It does not write an archive bit so the log chain is not interrupted with the backup....

    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

    July 8, 2013 at 2:04 am

    #1630345

Viewing 15 posts - 12,436 through 12,450 (of 49,552 total)