Forum Replies Created

Viewing 15 posts - 37,396 through 37,410 (of 49,552 total)

  • RE: Can't reduce fragmentation below 66.67%

    Well, they'll be considered for reindexing, and SQL will run the reindex on them, but the eway pages are allocated for very small objects means it's unlikely that they'll get...

    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 27, 2009 at 2:00 pm

    #1030732

  • RE: Retrieving uid for any user table?

    luckysql.kinda (7/26/2009)

    Now here uid=8 determines who is the owner of this table.

    Not in SQL 2005 and above it does not. It shows what schema the table is in. In 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

    July 27, 2009 at 10:11 am

    #1030638

  • RE: Store procedures

    No idea offhand what the base table is, but the system view is sys.sql_modules

    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 27, 2009 at 10:10 am

    #1030637

  • RE: ‘Restoring’ mode

    A database snapshot can only be created of an online database, or a mirror database that is in the synchronised state. A database that's in the restoring state cannot 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

    July 27, 2009 at 10:05 am

    #1030632

  • RE: Can't reduce fragmentation below 66.67%

    How big are these indexes? How many pages?

    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 27, 2009 at 10:04 am

    #1030631

  • RE: When I drop a view or stored procedure, is cache clear automatically ??

    The entire of cache won't be cleared (that would be a bad thing). Just the plan of the object dropped will be marked as invalid and discarded.

    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 27, 2009 at 9:27 am

    #1030597

  • RE: SP First time run takes longer!

    If you want specific optimisation help, please read this first http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    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 27, 2009 at 8:54 am

    #1030582

  • RE: Are the posted questions getting worse?

    Grant Fritchey (7/27/2009)

    Man, I'm clearly not doing things correctly.

    Guess I'm more persuasive than you are... 😉

    I've had to present twice a year for the last three years. I 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

    July 27, 2009 at 8:51 am

    #1030577

  • RE: You guys suck. every time we have to go and register or it says we have to go and click the f**king link. and the email doesnt get send immediately.

    Steve Jones - Editor (7/27/2009)

    And apparently you folks are getting ready for lunch. Enjoy!

    Supper!

    Mmmm, leftovers.... 😀

    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 27, 2009 at 8:37 am

    #1030563

  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (7/27/2009)

    I'd suggest that you try shorter presentations. The Orlando and Denver groups will do a 30 minute "opening" for new presentations or speakers.

    I give potential...

    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 27, 2009 at 8:35 am

    #1030559

  • RE: Are the posted questions getting worse?

    In my experience, the first one is the hardest. Once people see someone who's usually in the audience giving the presentation, they're a lot more willing to try it. Until...

    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 27, 2009 at 8:28 am

    #1030549

  • RE: SP First time run takes longer!

    If I may suggest...

    Look at optimising that, at minimum removing the while loops and breaking it up into smaller procs. 1300 lines is waaaay huge for a single stored proc.

    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 27, 2009 at 8:12 am

    #1030527

  • RE: Are the posted questions getting worse?

    Roy Ernest (7/27/2009)

    Bill Wunder. He is the co founder of the group. 🙂 So it was easy to get the first speaker. But after 3 months, I am planning 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

    July 27, 2009 at 8:09 am

    #1030526

  • RE: Are the posted questions getting worse?

    Roy Ernest (7/27/2009)

    I have been very busy setting up the Curacao SQL pass chapter. At last we are open to the whole world. 🙂

    Woot. Congrats. Who you got lined...

    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 27, 2009 at 7:50 am

    #1030501

  • RE: You guys suck. every time we have to go and register or it says we have to go and click the f**king link. and the email doesnt get send immediately.

    Gaby A. (7/27/2009)

    arthykannan (7/6/2009)

    You guys shuck. every time we have to go and register or it says we have to go and click the freaking link. and the email...

    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 27, 2009 at 7:49 am

    #1030500

Viewing 15 posts - 37,396 through 37,410 (of 49,552 total)