Forum Replies Created

Viewing 15 posts - 12,916 through 12,930 (of 49,552 total)

  • RE: Questions on Index Rebuilding (not reorganize)

    chewychewy (6/3/2013)

    anyone can advise why it need to much space for transaction log? i thought the additional spaces required in the mdf file to store the additional index during time...

    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

    June 3, 2013 at 8:39 am

    #1620594

  • RE: creating logon & logoff triggers in MSSQL

    There are login triggers in SQL Server. Have a look in Books Online for the details and examples, they're a form of DDL trigger. There are no logoff triggers though.

    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

    June 3, 2013 at 8:15 am

    #1620573

  • RE: 2 transaction log files -- which one is in use?

    writearjun53 (6/3/2013)

    If We don't take a full backup and try to take backup of transaction log file then sql server give a error "Msg 4214, Level 16, State 1, Line...

    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

    June 3, 2013 at 8:01 am

    #1620563

  • RE: 2 transaction log files -- which one is in use?

    writearjun53 (6/3/2013)

    After transaction log backup, If we rerun the DBCC LOGINFO command then we will see how the Status=2 has changed in the file. The last entry is still marked...

    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

    June 3, 2013 at 7:43 am

    #1620548

  • RE: SQL server Query

    Ed Wagner (6/3/2013)

    Maybe it was a trick question.

    Maybe a question designed to see whether the candidate will admit they don't know or try to make up something.

    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

    June 3, 2013 at 7:07 am

    #1620530

  • RE: 2 transaction log files -- which one is in use?

    Unfortunately some bad info here.

    No need to shrink files. ShrinkFile with the EmptyFile option is for when you're removing a data file from a filegroup that has multiple data files....

    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

    June 3, 2013 at 6:25 am

    #1620501

  • RE: 2 transaction log files -- which one is in use?

    HanShi (6/3/2013)

    Empty the second logfile with DBCC SHRINKFILE ('name' EMPTYFILE) and follow this statement with a delete file statement (alter database [...] remove file ...)

    DBCC ShrinkFile with the emptyFile option...

    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

    June 3, 2013 at 6:19 am

    #1620499

  • RE: Group by field, include or not include

    It's because of the query form you're using. Please read the blog post I referenced above, it's discussed in there.

    If you want a test that will show that putting 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

    June 3, 2013 at 6:15 am

    #1620496

  • RE: Group by field, include or not include

    Evgeny (6/3/2013)

    Did you do any tests about?

    You mean other than the ones on the blog post I referenced?

    Particullary for SQL Server 2012...

    No, but neither the index architecture nor...

    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

    June 3, 2013 at 3:48 am

    #1620442

  • RE: SQL server Query

    Never heard of query recasting. What's the context?

    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

    June 3, 2013 at 3:03 am

    #1620421

  • RE: How to rollback an insert query on sql server ? , please suggest bit high priority .. thanks in advance

    pietlinden (6/2/2013)

    So you'd save the transaction logs from the new stuff (back it up), restore the database, rolling forward to a point in time, and then apply the logs, skipping...

    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

    June 3, 2013 at 3:01 am

    #1620419

  • RE: How to reduce the size of the t-log file of a mirrored DB that is still in restoring mode

    Patience.

    We're volunteers, we all have our own jobs, our own problems and we post in our spare time. If you want immediate solutions hire someone, it's not as if...

    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

    June 3, 2013 at 2:58 am

    #1620418

  • RE: Group by field, include or not include

    Key columns, because the ordering of them may be useful to the optimiser and query processor. Very much depends on the rest of the index and the rest of 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

    June 3, 2013 at 2:57 am

    #1620416

  • RE: What do u mean by DB Refresh

    Skppani (6/2/2013)

    I can place it in the same machine where my production server is available but as a different instance..?

    Do you want the testing to impact your production server's...

    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

    June 2, 2013 at 11:39 am

    #1620338

  • RE: DB Reindex

    Index rebuilds aren't expected to make the fragmentation exactly zero. Also could be index is too small to be worth rebuilding.

    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

    June 2, 2013 at 11:38 am

    #1620337

Viewing 15 posts - 12,916 through 12,930 (of 49,552 total)