Forum Replies Created

Viewing 15 posts - 10,126 through 10,140 (of 49,552 total)

  • RE: DBCC CheckTable repair_allow_data_loss

    Do you have a clean backup (from before the corruption) and an unbroken chain of log backups?

    Since it's a reporting DB, can it be recreated from another source?

    Is that 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 4, 2014 at 5:35 am

    #1685803

  • RE: Are the posted questions getting worse?

    Jeff Moden (2/3/2014)

    This guy isn't the only person of such ilk when it comes to indexes. I also see that Brent Ozar published an article about what a waste...

    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 3, 2014 at 10:47 pm

    #1685732

  • RE: Are the posted questions getting worse?

    Grant Fritchey (2/3/2014)

    Please, please, please, no piling on, but I'm curious what you guys think about this: Unreasonable Defaults. I think most of the fundamental info is fine. I'm just......

    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 3, 2014 at 10:37 pm

    #1685730

  • RE: Write a conditional query

    That kind of query generally doesn't perform well. To give you an idea, I had a query the other week that was written to do just that and took 3...

    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 3, 2014 at 8:37 am

    #1685530

  • RE: Best way to add constraint?

    Why are you explicitly adding an unknown value, rather than allowing NULL to indicate unknown?

    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 3, 2014 at 6:54 am

    #1685466

  • RE: Stored Proc And View Giving Different Results

    BWFC (2/3/2014)

    I'm personally surprised not one of the auditors has said something like 'about these nolocks...'

    No, they won't. Most aren't technical and won't have any idea of the implications. now,...

    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 3, 2014 at 6:50 am

    #1685462

  • RE: Stored Proc And View Giving Different Results

    BWFC (2/3/2014)

    I don't think we have much in the way of blocking problems, although it's not something that would necessarily come to my attention if we did.

    If you have nolock...

    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 3, 2014 at 6:26 am

    #1685455

  • RE: Stored Proc And View Giving Different Results

    BWFC (2/3/2014)

    What transaction level should I be setting it to? I assume, to make sure it's clean data I should be using read committed. I know it's not...

    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 3, 2014 at 5:43 am

    #1685442

  • RE: What recovery model should the replication subscriber db be using?

    colin Robinson-345240 (2/3/2014)

    I imagine using bulk logged on the subscription replica is a replication throughput issue,

    all the insert update action from the replication stored procs will be getting logged 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

    February 3, 2014 at 4:09 am

    #1685427

  • RE: What recovery model should the replication subscriber db be using?

    Replication doesn't require any recovery model from any of its databases (publisher, distributer, subscriber). It's technically in simple recovery anyway since the log is truncated without another backup running.

    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 3, 2014 at 4:08 am

    #1685426

  • RE: Linked server

    Where is that error coming from? Can you post the code?

    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 3, 2014 at 12:45 am

    #1685402

  • RE: Memory Outside of the Buffer Pool

    SQLSACT (2/3/2014)

    I understand that SQL Server's plan cache is memory taken from outside of the buffer pool (Memory allocated by the Max Memory setting in SQL).

    No, the plan cache is...

    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 3, 2014 at 12:32 am

    #1685401

  • RE: auto-increment across multiple tables

    squeekz01 (1/31/2014)

    EDIT: Dont worry... figured it out... just needed to get the "-" out of the sequence name.

    Dashs are not valid characters in object names, so if you do use...

    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 3, 2014 at 12:31 am

    #1685400

  • RE: Query to get the CPU Usage,memory usage details of server

    sharadkkw (1/30/2014)

    Can someone help me in providing a query for fetching the data for CPU Usage, Memory usage, blocking and all details ...

    Could you give a little more info as...

    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 3, 2014 at 12:28 am

    #1685399

  • RE: Query to get the CPU Usage,memory usage details of server

    Jeff Moden (2/2/2014)

    sqlsniper (2/2/2014)

    You could also take a look at Windowstooling, like perfmon and the typeperf tooling.

    Perfect! How do you store that in a table in SQL Server? 😉

    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 3, 2014 at 12:25 am

    #1685398

Viewing 15 posts - 10,126 through 10,140 (of 49,552 total)