Forum Replies Created

Viewing 15 posts - 37,366 through 37,380 (of 49,552 total)

  • RE: Full Backup and Log

    http://www.sqlskills.com/BLOGS/PAUL/post/Misconceptions-around-the-log-and-log-backups-how-to-convince-yourself.aspx

    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

    July 29, 2009 at 6:31 am

    #1031596

  • RE: Which one runs faster?

    http://sqlinthewild.co.za/index.php/2009/04/14/on-counts/

    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

    July 29, 2009 at 12:54 am

    #1031482

  • RE: Are the posted questions getting worse?

    Jan Van der Eecken (7/28/2009)

    Why are you Vaalies always picking on us? :angry: Just coz we don't pick up the phone before 9AM?

    Cause you're so laid back you won'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

    July 28, 2009 at 4:05 pm

    #1031382

  • RE: SP First time run takes longer!

    Startup procs have to be in the master database. They cannot be in any other DB. Bear in mind that, at the point that the startup procs run, the 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

    July 28, 2009 at 10:03 am

    #1031145

  • RE: Cursor with INSERT

    mtassin (7/28/2009)

    Consistency checks and index rebuilds I'd agree with... but apparently executing multiple backups seperated by ;'s will work too 🙂

    Depends how much logic you're building into your backup routine.

    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

    July 28, 2009 at 9:48 am

    #1031137

  • RE: Shrinking Database

    Why do you want to shrink? Databases tend to grow as more data gets put in them. It's in their nature.

    Shrinking causes massive fragmentation and will just result in 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

    July 28, 2009 at 8:35 am

    #1031061

  • RE: Cursor with INSERT

    Iron Chef SQL (7/28/2009)

    Is it possible to nest a cursor inside a cursor,

    Yes.

    if so why would anyone do so.

    Good question...

    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

    July 28, 2009 at 8:35 am

    #1031060

  • RE: DB Consistency errors

    Vishal Singh (7/28/2009)

    Yup, I saw. What of it? It's a fairly standard corruption message saying that there's damage to the blob pages

    I mean here is that error 8964 doesn't left...

    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

    July 28, 2009 at 8:28 am

    #1031049

  • RE: Cursor with INSERT

    Iron Chef SQL (7/28/2009)

    I'm just curious why another fetch is needed. I tested your suggestion and it worked.

    There has to be a fetch inside the while loop to get 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

    July 28, 2009 at 8:26 am

    #1031045

  • RE: Recover data of a Dropped Table

    Do you have a backup of this 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

    July 28, 2009 at 3:29 am

    #1030918

  • RE: DB Consistency errors

    Vishal Singh (7/28/2009)

    My databases are on 2000 only where I believe there is no DATA_PURITY option available?

    Please post SQL 2000-related questions in the SQL 2000 forums in the future. If...

    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

    July 28, 2009 at 3:23 am

    #1030912

  • RE: DB Consistency errors

    manoj2001 (7/28/2009)

    So please check in your procedure wherver you are importing data into database.

    It's not possible to insert out-of-range values via stored procedures. The SQL query processor will catch 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

    July 28, 2009 at 3:20 am

    #1030910

  • RE: DB Consistency errors

    Vishal Singh (7/28/2009)

    Additionally, Look on to the error message Its Error 8964:

    Yup, I saw. What of it? It's a fairly standard corruption message saying that there's damage to 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

    July 28, 2009 at 3:14 am

    #1030905

  • RE: DB Consistency errors

    Vishal Singh (7/28/2009)

    For restoring from backups I had to go 15 days back because I have a full backup running everyday (WITN INIT) and the conistency error I found was...

    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

    July 28, 2009 at 3:12 am

    #1030904

  • RE: suggest me a good solution.

    sys.dm_db_index_usage_stats only holds info since the last start of SQL Server

    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

    July 28, 2009 at 1:24 am

    #1030880

Viewing 15 posts - 37,366 through 37,380 (of 49,552 total)