Forum Replies Created

Viewing 15 posts - 2,656 through 2,670 (of 49,552 total)

  • RE: Calculating time between two times five an arithmetic overflow

    SQLTestUser (8/11/2016)

    SELECT UserID, Hours = SUM(DATEDIFF(MINUTE, '0:00:00', LogDatetime))

    It's because of the '0:00:00' you have in the datediff. With no date specified, that becomes 1900-01-01 00:00:00.000, which is probably 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

    August 11, 2016 at 12:40 pm

    #1895088

  • RE: Questions on spills to tempdb

    Brandie Tarvin (8/11/2016)

    3) Am I right in thinking that an INNER JOIN statement where an unindexed column is being used on the left side of the ON against a clustered...

    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

    August 11, 2016 at 12:36 pm

    #1895086

  • RE: sql server 2016 - Grant Fritchey

    Grant Fritchey (8/11/2016)

    That guy is really lazy and has not written a book on 2016.

    I'll file a complaint with his boss. 😉

    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

    August 11, 2016 at 12:30 pm

    #1895085

  • RE: Database Corruption - Possible False Positive

    ThomasRushton (8/11/2016)

    Have you tried dropping & recreating the index on that view?

    as in, drop the spacial index and recreate it.

    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

    August 11, 2016 at 12:28 pm

    #1895083

  • RE: Are the posted questions getting worse?

    TomThomson (8/10/2016)

    GilaMonster (8/10/2016)

    First time in years that I'm flying somewhere just for a vacation, no conferences involved. Scotland, to save anyone from wondering.

    Any particular place in Scotland? I'm...

    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

    August 11, 2016 at 12:25 pm

    #1895081

  • RE: Are the posted questions getting worse?

    First time in years that I'm flying somewhere just for a vacation, no conferences involved. Scotland, to save anyone from wondering.

    Someone please keep an eye on the corruption forums, I've...

    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

    August 10, 2016 at 10:00 am

    #1894836

  • RE: Unable to read and latch page

    You can try that, but I'm not sure it'll fix everything.

    Unable to read and latch page (1:5609991) with latch type SH. 23(failed to retrieve text for this error. Reason: 15105)...

    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

    August 10, 2016 at 2:01 am

    #1894723

  • RE: Unable to read and latch page

    If you're absolutely certain that table_xxxx has no important data, then you can run CheckDB with the repair_allow_data_loss option and it will fix the damage.

    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

    August 10, 2016 at 1:42 am

    #1894721

  • RE: Viewing specific query from transaction log

    joe 92217 (8/9/2016)

    My idea was to do a RESTORE to a temp db of the *.bak and *.trn up until the hour the event occurred and then somehow view all...

    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

    August 10, 2016 at 1:40 am

    #1894720

  • RE: Unable to read and latch page

    Please run the following and post the full output

    DBCC CheckDB('<database name>') WITH NO_INFOMSGS, ALL_ERRORMSGS

    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

    August 9, 2016 at 4:35 pm

    #1894675

  • RE: trailing spaces

    You really don't need to use such a large font...

    SQL ignores trailing spaces when comparing strings. If it didn't, you'd never be able to compare a char(10) to any other...

    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

    August 9, 2016 at 4:29 pm

    #1894673

  • RE: SP_UPDATESTATS

    Erik de Jonge (8/9/2016)When we tested it on our dev system there were performance increases across the board.

    Yup, not a surprise there, You do need some index/stats maintenance. Without...

    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

    August 9, 2016 at 4:18 pm

    #1894671

  • RE: SP_UPDATESTATS

    I wouldn't recommend running that during peak time. To be honest, I wouldn't recommend running that specific stored proc either, there are better ways to update stats (the explicit UPDATE...

    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

    August 9, 2016 at 3:59 pm

    #1894668

  • RE: Are the posted questions getting worse?

    SQLRNNR (8/9/2016)

    Restart dev edition in minimal configuration and add your personal account as a sysadmin that way.

    http://www.practicalsqldba.com/2012/08/sql-server-lost-all-administrator.html

    Minimum config isn't necessary. SQL just has to be started in single user mode.

    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

    August 9, 2016 at 12:20 pm

    #1894623

  • RE: Database Corruption problems

    6 year old thread, and a completely irrelevant reply to boot.

    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

    August 9, 2016 at 9:33 am

    #1894573

Viewing 15 posts - 2,656 through 2,670 (of 49,552 total)