Forum Replies Created

Viewing 15 posts - 22,036 through 22,050 (of 49,552 total)

  • RE: How we can get the log an data File sizes Increments with Query

    Query sys.master_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

    November 22, 2011 at 12:06 pm

    #1411743

  • RE: Processor license of SQL server

    Evil Kraig F (11/22/2011)

    Wut? Gyeaddangit! That better be one heck of a price drop.

    Around about 1 socket === 4 cores in terms of price. Is complex, see Denny...

    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

    November 22, 2011 at 12:05 pm

    #1411741

  • RE: Two databases - same instance - query both

    What is the exact error message?

    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

    November 22, 2011 at 11:08 am

    #1411708

  • RE: Covering a Query with a nonclustered index that is already a primary key, adding includes to cover

    jwbart06 (11/22/2011)

    Is is standard practice to cover your queries by adding non-clustered that is essentially your primary key.

    Depends if your primary key is clustered or not. If it 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

    November 22, 2011 at 11:05 am

    #1411705

  • RE: number of executions don't match number of rows -- Nested Loops

    p.s. If you're looking to optimise this, it looks like you're missing a simple index - EnhancedBusinesses Key column: BusinessStatus, include columns BusinessId, UserGroupId, SuppressFRISK2, FriskScore

    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

    November 22, 2011 at 10:57 am

    #1411701

  • RE: number of executions don't match number of rows -- Nested Loops

    The inner table of a nested loop join can return more than one row per execution (and can return no rows as well). So if rows > executions, some of...

    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

    November 22, 2011 at 10:54 am

    #1411700

  • RE: Is there any algorithm using by sql server to fetch data using indexes ?

    http://www.sqlservercentral.com/articles/Indexing/68439/

    http://www.sqlservercentral.com/articles/Indexing/68563/

    http://www.sqlservercentral.com/articles/Indexing/68636/

    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

    November 22, 2011 at 8:50 am

    #1411606

  • RE: Shrink and backup

    Jim Murphy (11/22/2011)

    He's doing a full backup every 24h and a tlog backup every 2h and retaining 24h of tlog backups. No gaps. In your scenario, he'd restore...

    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

    November 22, 2011 at 8:44 am

    #1411596

  • RE: number of executions don't match number of rows -- Nested Loops

    There's probably a good reason, but I just don't have time to sit and decode the raw XML, plus I'd need to see the operators before and after as well.

    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

    November 22, 2011 at 8:41 am

    #1411593

  • RE: how to dcrypt a view

    Redgate SQL Prompt (professional version) can do this.

    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

    November 22, 2011 at 6:51 am

    #1411450

  • RE: Transaction log

    Might also be worth while reading this, it explains a bit more about the details of how SQL uses the log - http://www.sqlservercentral.com/articles/Transaction+Log/72488/

    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

    November 22, 2011 at 2:24 am

    #1411272

  • RE: Transaction log

    RuanK (11/22/2011)

    But is it possible to configure the ldf's to do different jobs?

    No, and I get the impression from that question you don't understand how the log is used....

    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

    November 22, 2011 at 2:23 am

    #1411271

  • RE: missing records on table

    Jeff Moden (11/20/2011)

    GilaMonster (11/19/2011)

    For the record, this is a stupid interview question. It's another 'read my mind' kind of question that generally serves just to make the interviewer feel superior....

    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

    November 22, 2011 at 2:19 am

    #1411269

  • RE: Transaction log

    Managing Transaction Logs[/url]

    The article's old and an updated version will be published soon. If you have any questions after reading that, please ask.

    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

    November 22, 2011 at 1:49 am

    #1411255

  • RE: number of executions don't match number of rows -- Nested Loops

    The entire plan please. I can't load that into SSMS and I'm not overly fond of reading the XML raw.

    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

    November 21, 2011 at 3:55 pm

    #1411090

Viewing 15 posts - 22,036 through 22,050 (of 49,552 total)