Forum Replies Created

Viewing 15 posts - 9,061 through 9,075 (of 49,552 total)

  • RE: table scan stopped

    What exactly do you mean?

    The query was doing table scans and now isn't? Something else?

    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

    May 14, 2014 at 4:43 am

    #1713378

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (5/14/2014)

    This was a funny topic 😀 (especially the last replies)

    Sorry, am a little short on patience 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

    May 14, 2014 at 4:40 am

    #1713375

  • RE: difference between '‚' and ','

    Um, really?

    You have a working query, and you're asking what changes to make? Maybe replace the non-working query with the working query?

    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

    May 14, 2014 at 4:10 am

    #1713364

  • RE: difference between '‚' and ','

    If you check using the ASCII function, they're different characters. The first is ASCII code 130, the second is ASCII code 44

    SELECT ASCII('‚')

    SELECT ASCII(',')

    One was copied from Word and one...

    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

    May 14, 2014 at 3:59 am

    #1713358

  • RE: Know user actions on database

    shohelr2003 (5/14/2014)

    GilaMonster (5/14/2014)

    The trace will show the modifications, but it's high overhead. Maybe a trigger?

    Yes, I found information that someone has opened Edit window but did not find what has...

    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

    May 14, 2014 at 3:22 am

    #1713350

  • RE: GUID vs BIGINT

    Haven't we been over this a couple times already?

    http://www.sqlservercentral.com/Forums/Topic1553317-391-1.aspx

    http://www.sqlservercentral.com/Forums/Topic1549110-391-1.aspx

    http://www.sqlservercentral.com/Forums/Topic1548615-391-1.aspx

    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

    May 14, 2014 at 3:18 am

    #1713349

  • RE: Performance issue

    Follow the articles I referenced, identify the queries with the highest CPU usage overall (not the one high one at a time you look at the server), tune them to...

    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

    May 14, 2014 at 12:57 am

    #1713323

  • RE: Database became in recovery

    Wait.

    Once recovery completes the database will come online.

    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

    May 14, 2014 at 12:54 am

    #1713322

  • RE: Know user actions on database

    The trace will show the modifications, but it's high overhead. Maybe a trigger?

    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

    May 14, 2014 at 12:53 am

    #1713320

  • RE: Log shipping and log chain

    william.rees.howells (5/13/2014)

    1) After the initialisation is done the first time from the BAK file, does the job just add the data from each new TRN file every time a new...

    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

    May 13, 2014 at 2:30 pm

    #1713247

  • RE: Log shipping and log chain

    william.rees.howells (5/13/2014)

    First) We do a full backup of our DB every Sunday, and then a log backup every night until the next Sunday to enable point in time recovery.

    That will...

    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

    May 13, 2014 at 1:54 pm

    #1713229

  • RE: Round decimal number

    lsalih (5/13/2014)

    Thank you both. So how you correct the query to print 1.9?

    Um, maybe using the code I posted?

    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

    May 13, 2014 at 8:54 am

    #1713106

  • RE: Round decimal number

    lsalih (5/13/2014)

    hi Gail -

    Sorry, one correction... I just realized that the user wanted to get the actual decimal result, in this case the result should print 1.9.

    It prints 1 because...

    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

    May 13, 2014 at 7:37 am

    #1713040

  • RE: Round decimal number

    The first problem is you're declaring the variables as integer and then assigning a value with a decimal. SQL will truncate this, so set @val1 = 1.9 results in @val1...

    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

    May 13, 2014 at 7:21 am

    #1713025

  • RE: Please help to reduce query time

    Grant Fritchey (5/13/2014)

    I'm being blunt and honest here, I see very little opportunity to tune this query. You should reassess the approach.

    Agreed.

    I've had several major tuning wins by removing temp...

    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

    May 13, 2014 at 7:11 am

    #1713019

Viewing 15 posts - 9,061 through 9,075 (of 49,552 total)