Forum Replies Created

Viewing 15 posts - 30,151 through 30,165 (of 49,552 total)

  • RE: Managing Transaction Logs

    MostInterestingMan (10/6/2010)

    With the recovery model set at FULL (USING SIMPLE IS NOT AN OPTION) and no log backup being done what is the recommended best practice on managing the transaction...

    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

    October 6, 2010 at 1:59 pm

    #1233008

  • RE: Query not returning the right amount of records.

    You're using INNER JOIN. Isn't it possible that only the 93 rows have matching values in that table?

    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

    October 6, 2010 at 12:02 pm

    #1232913

  • RE: Are the posted questions getting worse?

    Grant Fritchey (10/6/2010)

    I can't seem to edit the post. It won't go into edit mode when I click on it.

    Refresh a couple times. It's because of the fast posting 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

    October 6, 2010 at 12:01 pm

    #1232910

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (10/6/2010)

    It looks like Alvin got it.

    With a very appropriate post...

    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

    October 6, 2010 at 11:56 am

    #1232902

  • RE: Are the posted questions getting worse?

    WayneS (10/6/2010)

    [Heavy Sigh]

    okay, wait mode on. This will be on your blog?

    Well, yes. 😀

    It's for the T-SQL Tuesday blog 'party' so *shock* *horror* you'll have to wait for the details...

    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

    October 6, 2010 at 11:52 am

    #1232892

  • RE: Are the posted questions getting worse?

    Your link, it is broken.

    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

    October 6, 2010 at 11:45 am

    #1232878

  • RE: Restore SQL Server 2005 database in SQL Server 2008 instance

    gmamata7 (10/6/2010)

    Is restoring a SQL Server 2008 database backup into a SQL Server 2005 instance possible?

    No, and that's regardless of compatibility level.

    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

    October 6, 2010 at 11:43 am

    #1232875

  • RE: Are the posted questions getting worse?

    WayneS (10/6/2010)

    Okay, I've got a few questions:

    1. Can I help?

    Thanks, but I have it under control (will hack out the post this weekend)

    2. Can you share the myth that I...

    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

    October 6, 2010 at 11:33 am

    #1232864

  • RE: Naming a SQL server instance ".\SQLExpress"

    I suspect, like Steve, what he really wants is an instance named SQLExpress (which is the default for the express version of SQL). . means local server. If you 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

    October 6, 2010 at 11:19 am

    #1232849

  • RE: SQL Server 2008 Restart

    sqlrocks79 (10/6/2010)

    Sorry for the late reply. The problem still persists. I am trying to solve it.

    If you want our help, answer George's questions.

    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

    October 6, 2010 at 10:53 am

    #1232819

  • RE: Performance Tuning

    Standard edition has profiler, though you should probably rather use a server-side trace.

    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

    October 6, 2010 at 10:05 am

    #1232757

  • RE: How to delete database on production server

    sjimmo (10/6/2010)

    Homebrew01

    Coming soon, another thread about restoring a database without a backup

    Can't wait for this one. Hope that it is as informative as this thread has been.

    Why wait?

    http://www.sqlservercentral.com/Forums/Topic773514-146-1.aspx

    http://www.sqlservercentral.com/Forums/Topic754888-357-1.aspx

    http://social.msdn.microsoft.com/Forums/en-US/sqldisasterrecovery/thread/bfcddeb1-b45d-41d7-abe7-33d25600397f

    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

    October 6, 2010 at 10:01 am

    #1232750

  • RE: Shrink the log file size

    Tom Goltl (10/6/2010)

    The first thing you need to do is to truncate the t-log. backup log <db> with truncate_only.

    Then issue the dbcc shrinkfile (filename,size)

    No, no, no, no! Both are...

    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

    October 6, 2010 at 9:52 am

    #1232742

  • RE: Shrink the log file size

    Please read through this - Managing Transaction Logs[/url]

    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

    October 6, 2010 at 9:47 am

    #1232737

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (10/6/2010)

    As an FYI, we have about 5GB of data in the forum database.

    Only? I thought there's be quite a bit more than 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

    October 6, 2010 at 9:44 am

    #1232732

Viewing 15 posts - 30,151 through 30,165 (of 49,552 total)