Forum Replies Created

Viewing 15 posts - 24,331 through 24,345 (of 49,552 total)

  • RE: Shrinking Log files

    GilaMonster (8/8/2011)

    Have you checked why the log is full? (if you read my article I assume you've already done all 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 8, 2011 at 2:51 pm

    #1365537

  • RE: Disk Space Full Drive:j: Percent:97.38%

    Actually the first thing you need to do is identify what's on that drive.

    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 8, 2011 at 2:07 pm

    #1365505

  • RE: Disk Space Full Drive:j: Percent:97.38%

    Lowell (8/8/2011)

    my first inclination is to see if there are any databases that are in FULL recovery mode, but have NEVER been backed up:

    they probably have gigabite sized log 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

    August 8, 2011 at 1:33 pm

    #1365486

  • RE: Are the posted questions getting worse?

    GSquared (8/8/2011)

    Grant Fritchey (8/8/2011)

    I've been failing at Google-Fu today. I'm trying to track down the name of that pet store (or at least a good copy of the story about...

    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 8, 2011 at 12:54 pm

    #1365476

  • RE: Guidelines for tuning CPU bound SQL Server System

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

    Using the DMVs is quick, but it's not necessarily going to show you the complete picture due to queries being aged from cache, cache being cleared and queries that aren'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 8, 2011 at 12:36 pm

    #1365461

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (8/8/2011)

    I have several WordPress blogs and I use the host Arvixe. They're inexpensive, reliable and flexible. One of the reasons I like them is that not only can...

    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 8, 2011 at 12:21 pm

    #1365449

  • RE: Shrinking Log files

    @SQLFRNDZ (8/8/2011)

    Does shriniking breaks up log chain ?

    No.

    even if he is not changing the recovery model.

    ALTER DATABASE fv_prepaid_ca_test SET RECOVERY SIMPLE WITH NO_WAIT

    DBCC SHRINKFILE(Aprakash_CoreAuth_log, 1,TRUNCATEONLY)

    ALTER DATABASE fv_prepaid_ca_test...

    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 8, 2011 at 12:18 pm

    #1365446

  • RE: Are the posted questions getting worse?

    Ask Grant about GoDaddy, and take a couple steps back.

    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 8, 2011 at 10:43 am

    #1365364

  • RE: query datetime column

    Just hope that the table isn't big, because that cannot use index seeks because of the convert. You're building a potential performance problem.

    btw, you have a convert to varchar 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 8, 2011 at 10:31 am

    #1365351

  • RE: Problem: SQL-Database with 4 GB

    p.s. Take a full backup first and store it somewhere. Just incase someone does want those records later.

    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 8, 2011 at 10:13 am

    #1365338

  • RE: Problem: SQL-Database with 4 GB

    Excellent. In that case...

    TRUNCATE TABLE SyncWorkersLog

    You can shrink after that, but I wouldn't recommend it. There will be space free in the data file, so the file won't try 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 8, 2011 at 10:12 am

    #1365336

  • RE: Shrinking Log files

    p.s. There's no way you can be taking log backups after doing what you posted, unless there was a full backup taken that you didn't mention.

    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 8, 2011 at 9:52 am

    #1365317

  • RE: Shrinking Log files

    Have you checked why the log is full? (if you read my article I assume you've already done all 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 8, 2011 at 9:51 am

    #1365316

  • RE: Shrinking Log files

    You can't shrink that, as it says it's already at a minimum

    Why are you trying to shrink anyway? Why are you breaking your transaction log chain? You've left yourself open...

    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 8, 2011 at 9:39 am

    #1365309

  • RE: Problem: SQL-Database with 4 GB

    And you're absolutely sure you want to remove every single row from that table?

    Is that table referenced by any foreign key constraints?

    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 8, 2011 at 9:09 am

    #1365281

Viewing 15 posts - 24,331 through 24,345 (of 49,552 total)