Forum Replies Created

Viewing 15 posts - 871 through 885 (of 49,552 total)

  • RE: Corrupted page not repairable w/ DBCC - how to delete it?

    Please note: 8 year old thread, and the linked page just says to run repair (well, and buy some magic software), which the OP had already tried.

    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 21, 2017 at 5:12 am

    #1955962

  • RE: Need to find a store procedure in a database

    Searching for the XML tags won't get you anywhere, because those get generated from data, they're not hard coded into the procedure. Instead, look for procedures that are generating XML...

    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 21, 2017 at 1:01 am

    #1955951

  • RE: Transaction Logs in Status 2 for no apparent reason

    Are the log backups being done with no_truncate or copy_only options?

    If you run a checkpoint after the log backup, what does the log_reuse_wait change to (it shows 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

    August 21, 2017 at 12:59 am

    #1955950

  • RE: Why did added partitions make cube processing slower?

    For those mentioning index maintenance, queries, etc, the OP's asking about partitions of Analysis Services cubes, not SQL Server tables. Very different beasts.

    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 21, 2017 at 12:51 am

    #1955949

  • RE: RAMDisk? Use it for TempDB?

    JakDBA - Sunday, August 20, 2017 10:46 PM

    All are interesting facts..but why cant you use extended buffer poll feature from SQL...

    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 21, 2017 at 12:47 am

    #1955948

  • RE: How to reduce the space /shrink SQL Server 2008 R2 Data file (MDF) and Log file (LDF)

    srik18 - Sunday, August 20, 2017 6:24 PM

    Log file ( FileSize in MB 31189.94     -- UsedSpace MB ( 19.75 ) and...

    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 21, 2017 at 12:37 am

    #1955947

  • RE: How to reduce the space /shrink SQL Server 2008 R2 Data file (MDF) and Log file (LDF)

    JakDBA - Sunday, August 20, 2017 10:00 PM

    Try Testing trace flag 610.

    Trace flag 610 is useless unless he also switches 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

    August 21, 2017 at 12:36 am

    #1955946

  • RE: Memory CAP

    No idea. How busy are each of them? How much data do they work with?

    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 21, 2017 at 12:33 am

    #1955945

  • RE: Remove TempDB data files

    Riic - Friday, August 18, 2017 3:22 AM

    Thanks Anthony! Hope there is no error after removing files! TGIF enjoy...

    Run the alter database,...

    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 20, 2017 at 11:32 am

    #1955915

  • RE: Triggers and Stored procedures

    oga1234 - Sunday, August 20, 2017 7:51 AM

    That sounds intense.... I am not that advanced yet to pull that off... have any...

    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 20, 2017 at 9:52 am

    #1955912

  • RE: Triggers and Stored procedures

    That doesn't sound like mirroring or availability groups, as they are high-availability solutions that can allow for reading from secondaries as a bonus.

    This sounds like a problem that...

    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 20, 2017 at 7:21 am

    #1955910

  • RE: SQL Database corruption issue

    SQL_Hacker - Friday, August 18, 2017 1:24 PM

     The best approach is going to be time consuming, but worth it...you'll want to 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

    August 19, 2017 at 10:33 am

    #1955899

  • RE: SQL Database corruption issue

    john.round - Friday, August 18, 2017 2:47 AM

    Many thanks for the replies,

    We do have good backups of the database and Full 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

    August 19, 2017 at 3:17 am

    #1955898

  • RE: Problem with NEWID (point of evaluation)

    pcd_au - Friday, August 18, 2017 6:14 AM

     to my mind the 2nd CTE should have resolved the problem, but it doesn't....

    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 18, 2017 at 8:33 am

    #1955845

  • RE: Are the posted questions getting worse?

    jasona.work - Friday, August 18, 2017 6:18 AM

    What does it say when you're told that your name comes up on a regular...

    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 18, 2017 at 8:27 am

    #1955843

Viewing 15 posts - 871 through 885 (of 49,552 total)