Forum Replies Created

Viewing 15 posts - 5,491 through 5,505 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    SQLBill (6/25/2015)

    GilaMonster (6/25/2015)

    I found a photo of my Siamese.

    *sniff*

    Okay, so how many looked at the cat and then looked at the books and thought "I have that one, don't have...

    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

    June 25, 2015 at 9:05 am

    #1808114

  • RE: Are the posted questions getting worse?

    Grant Fritchey (6/25/2015)

    Plus spitting and cursing at all the George RR Martin books. I've grown to really dislike that author.

    I took all of my Game of Thrones books down 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

    June 25, 2015 at 9:03 am

    #1808113

  • RE: ldf shrink issue

    What's the issue?

    You've described a scenario, but haven't said what exactly is wrong.

    Also, have you either scheduled log backups or put the DB into simple recovery (depending on recovery...

    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

    June 25, 2015 at 8:23 am

    #1808086

  • RE: #SQLNewBlogger

    When I was still blogging, it was very rare that something I wrote was related in any way to what I was working on. More often they were inspired by...

    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

    June 25, 2015 at 7:25 am

    #1808053

  • RE: Backups

    I'm going to disagree with you there.

    Large transaction log will not result in lots of log backups.

    Lots of VLFs won't result in lots of log backups.

    You get 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

    June 25, 2015 at 5:47 am

    #1808006

  • RE: Are the posted questions getting worse?

    I found a photo of my Siamese.

    *sniff*

    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

    June 25, 2015 at 5:42 am

    #1808003

  • RE: DW and TLog.

    No.

    Availability groups requires full recovery model. In full recovery model, the transaction log is only marked reusable when a log backup runs.

    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

    June 25, 2015 at 5:36 am

    #1807999

  • RE: need help on Scalar value Function

    Couple things jump out.

    Nolock hints, do you know what they do? (hint, they don't make queries faster)

    Scalar UDFs are notorious performance problems. Consider converting this to an in-line table function...

    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

    June 25, 2015 at 4:00 am

    #1807981

  • RE: Itzik Ben-Gan's Books

    Probably Querying.

    The Window functions book is excellent, but has a very narrow scope and is reasonably advanced.

    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

    June 25, 2015 at 3:08 am

    #1807967

  • RE: Msg 5244: Repair statement not processed

    Please run the following and post the full and unedited output. Not all corruptions are repairable.

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

    Also can you run:

    SELECT name, df.state_desc, df.is_read_only FROM sys.database_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

    June 25, 2015 at 2:57 am

    #1807963

  • RE: SQL DB slow after restore

    Because the first time you run a query the data has to be loaded from disk. Disk is slow. After that first execution, SQL Server can read the pages 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

    June 24, 2015 at 8:04 am

    #1807753

  • RE: SQL DB slow after restore

    Disks are slow, memory is fast. Therefore when SQL reads a page off disk it puts it into the data cache so that if it needs to read it again,...

    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

    June 24, 2015 at 7:45 am

    #1807744

  • RE: SQL DB slow after restore

    Loading data from disk into the data cache

    Compiling the query the first time and placing the plan into the plan cache

    The first is usually a far larger impact than 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

    June 24, 2015 at 7:24 am

    #1807729

  • RE: Whopper of a Deadlock, but why are there so many blank input buffers?

    Lowell (6/24/2015)

    what is the significance of the spiderwebs pointing to [Exchange Event]? what is an exchange event in a deadlock graph?

    A parallelism operation.

    That's also why there are so many empty...

    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

    June 24, 2015 at 7:19 am

    #1807726

  • RE: SQL Server 2014 SP2: SQL Server is not ready to accept new client connections

    It just means that someone was trying to connect while SQL was still starting up. It's not an error.

    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

    June 24, 2015 at 5:42 am

    #1807711

Viewing 15 posts - 5,491 through 5,505 (of 49,552 total)