Viewing 15 posts - 15,151 through 15,165 (of 19,564 total)
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...
April 7, 2010 at 12:13 pm
Pranav Shah-410191 (4/7/2010)
April 7, 2010 at 12:09 pm
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...
April 7, 2010 at 11:49 am
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...
April 7, 2010 at 11:40 am
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...
April 7, 2010 at 11:38 am
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.
April 7, 2010 at 11:34 am
Carla,
You're welcome - it was really Paul's script. I just added a little mod to it.
April 7, 2010 at 11:34 am
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...
April 7, 2010 at 11:32 am
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,...
April 7, 2010 at 11:27 am
boris_shvartsman (4/7/2010)
thanks a million for your...
April 7, 2010 at 11:26 am
the tables are stored in the protected hidden resource db.
April 7, 2010 at 11:19 am
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...
April 7, 2010 at 11:17 am
vkkrishn,
Do you have any of the information / answers for the questions asked?
April 7, 2010 at 11:01 am
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:...
April 7, 2010 at 10:59 am
Viewing 15 posts - 15,151 through 15,165 (of 19,564 total)