Forum Replies Created

Viewing 15 posts - 15,151 through 15,165 (of 19,564 total)

  • RE: Don’t Change Anything

    Check with someone that is responsible for the data, or its use, and confirm with them that you are making the correct changes.

    Sound advice. Even though I am responsible...

  • RE: Data Modeling Question

    Pranav Shah-410191 (4/7/2010)


    I am sorry, but I didn't mean to say that SQL Server is the problem. I just did a quick personal comparison on how it is different...

  • RE: Get DDL for any SQL 2005 table

    Thanks Lowell for a superb script.

  • RE: Creating a development environment - merge replication

    I would take the production database from your primary server and restore the backup of that database to the dev server. Make sure to rip out any replication related...

  • RE: Talking baseball

    I agree on the salary cap. I would also like to see revenue sharing implemented in baseball like in the NFL. I think the revenue sharing has made...

  • RE: system tables only

    RBarryYoung (4/7/2010)


    CirquedeSQLeil (4/7/2010)


    the tables are stored in the protected hidden resource db.

    Well, some of it is, but a lot of it is not even there. Rather, much of it...

  • RE: system tables only

    boris_shvartsman (4/7/2010)


    I agree 100%.. no doubt, but I worry that those "dead" tables in the sysobjects are somehow pulling the performance... reading your link..

    Fair enough.

  • RE: ANSI_NULLS

    Carla,

    You're welcome - it was really Paul's script. I just added a little mod to it.

  • RE: Creating a development environment - merge replication

    In your dev environment, will you be merging from the dev server to another dev server? Or are you trying to merge with another database on the same dev...

  • RE: How to Play the SSC Game - SSC Points

    GSquared (4/7/2010)


    Alvin Ramard (4/6/2010)


    GSquared (4/6/2010)


    Steve Jones - Editor (4/6/2010)


    Those are good suggestions. We are getting some people up there, so I ought to add more.

    Since I'm closing in on SSChampion,...

  • RE: system tables only

    boris_shvartsman (4/7/2010)


    if you don't mind being asked, where? and how is that "thing" is being re-indexed? That pretty much proves my "gut" feeling about it..

    thanks a million for your...

  • RE: system tables only

    the tables are stored in the protected hidden resource db.

  • RE: 70-448 Certification - Am I mad?

    It is possible. If you are doing that full time you may have enough down for the exam at that point.

    My recommendation would be to try as many scenarios...

  • RE: clearing SQL cache

    vkkrishn,

    Do you have any of the information / answers for the questions asked?

  • RE: system tables only

    RBarryYoung (4/7/2010)


    boris_shvartsman (4/6/2010)


    ... I need to only select the system tables and run update stats and reindex on them. ...

    OK, I'll be the dumb non-DBA here and ask the question:...

Viewing 15 posts - 15,151 through 15,165 (of 19,564 total)