Forum Replies Created

Viewing 15 posts - 10,096 through 10,110 (of 49,552 total)

  • RE: Mirroring database can take Tlog backup?

    Well, as I said you have to take log backups, it's not optional (unless you want to run out of disk space). Since you have to take log backups when...

    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

    February 6, 2014 at 5:07 am

    #1686531

  • RE: How to restrict memory in SQL Server 2008 R2 64 Bit Standard Edition

    Max server memory limits the buffer pool. SQL can use a small amount of memory in addition to that. If it's using too much, reduce max server memory

    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

    February 6, 2014 at 5:05 am

    #1686530

  • RE: Mirroring database can take Tlog backup?

    For a database to be mirrored, it must be in full recovery model. If you don't take log backups of a database in full recovery, your log will grow until...

    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

    February 6, 2014 at 4:24 am

    #1686525

  • RE: convert

    SQLSteve (2/6/2014)

    I never knew about formatteddatestring

    That's just a column alias. You could alias the column 'Whatchamacallit' if you like, won't make any difference.

    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

    February 6, 2014 at 3:15 am

    #1686506

  • RE: convert

    Once you've done a conversion it's a varchar, not a date. Cast (or assign) back to a date datatype and formatting is stripped away. Formatting a date is only relevant...

    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

    February 6, 2014 at 3:08 am

    #1686504

  • RE: LCK_M_IX on tempdb?

    Dird (2/6/2014)

    It was an object in tempdb so my assumption is that it would be that local temporary table created/dropped by the procedure because when I try OBJECT_NAME on 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

    February 6, 2014 at 3:02 am

    #1686503

  • RE: LCK_M_IX on tempdb?

    What resource were the locks on?

    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

    February 6, 2014 at 2:21 am

    #1686487

  • RE: Sql server logs

    By default there are 6 files. You won't be able to delete the active log and to be honest you shouldn't be messing directly with files that SQL works with.

    Why...

    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

    February 6, 2014 at 12:23 am

    #1686461

  • RE: memory issue: manual memory settings

    Don't use Task Manager to check SQL's memory, it lies. The labels on the values are also not as clear as they could be.

    If SQL is still using too much...

    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

    February 5, 2014 at 2:22 pm

    #1686362

  • RE: Execution Plan vs DTA missing index recommendations

    Evil Kraig F (2/5/2014)

    DTA is... um... I'll find a polite word for it in a moment, hang on.

    ....

    DTA is a best effort guess from an app to try to help...

    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

    February 5, 2014 at 11:48 am

    #1686316

  • RE: I'm .NET Developer with 3 years of experience. Looking to change career to DBA. Advise please.

    Evil Kraig F (2/5/2014)

    It's only, like, right there in huge letters, and not hidden under a link. I must scroll down more! Yeah, sorry. I disagree with...

    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

    February 5, 2014 at 11:14 am

    #1686310

  • RE: I'm .NET Developer with 3 years of experience. Looking to change career to DBA. Advise please.

    Evil Kraig F (2/5/2014)

    I was inaccurate about the intern level though, at least for the administration test. My bad, thanks for clarifying that for me/us.

    That quote was actually from...

    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

    February 5, 2014 at 10:22 am

    #1686278

  • RE: SQL SERVER 2008 R2 transaction log shipping

    sanku.raghuram (2/5/2014)

    Sorry for mis confusion and comming to Shawpoint-- you mean replication and transaction logshipping will work together.

    In that which order we go fist ,,

    Yes they do and either order....

    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

    February 5, 2014 at 10:21 am

    #1686277

  • RE: I'm .NET Developer with 3 years of experience. Looking to change career to DBA. Advise please.

    MinhTuCSharper (2/5/2014)

    So beside .NET and SQL Server, what is the hot MS technical field out there that on high demand, I'm willing to learn whatever MS Technology to get my...

    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

    February 5, 2014 at 10:20 am

    #1686276

  • RE: SQL job is getting hanged

    Maybe a server-side trace to identify what's happening.

    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

    February 5, 2014 at 3:22 am

    #1686121

Viewing 15 posts - 10,096 through 10,110 (of 49,552 total)