Viewing 15 posts - 1 through 15 (of 21 total)
yes, I Do schedule update statistics for all tables of each database overnight.
August 15, 2008 at 4:33 am
yes, I did run dbcc updateusage when upgrade each database.
August 15, 2008 at 4:31 am
Sorry for the typo.
Thanks Brian.
Yes, it's production environment. but sometime they might create test databases on the old server before.
Sherry
October 3, 2007 at 9:29 pm
Thank Brain.
I think you are right. and that's what I am trying to do. I will discuss with them.
October 3, 2007 at 9:25 pm
Thanks Markus and ALZDB.
We are running OS (32-bit). I will try not configuring any role. on windows 2003 server there are performance advance options:
1. choose how to allocate processor...
October 2, 2007 at 4:03 pm
Hi all,
after renaming the view back to match that in the definition, I ran UA again, this warning message disappeared.
Thanks for your help!
Sherry
September 13, 2007 at 6:48 pm
Hi cmille 19,
excellent! there is a view which name does not match that in the definition. I will check with our sys admin who has been working on it.
Thanks a lot,
Sherry
September 13, 2007 at 6:29 pm
Andy,
All I got in "description" from UA is "Object reference not set to an instance of an object" as I posted before.
Sherry
September 13, 2007 at 5:32 pm
Andras,
results:
"(0 row(s) affected)"
Sherry
September 13, 2007 at 5:28 pm
Thanks for the recommendation. I will keep in mind when planning.
Sherry
September 4, 2007 at 4:59 pm
Thanks Rookie for replying my post.
I found "SQLServer2005Licensingv1.1.doc" on microsoft website. it says:
"When doing failover support, a server is designated as the passive server. The...
September 4, 2007 at 12:12 am
Hi EdVassie,
I am not sure if you've got the private message and I don't know how it works. if not yet, my email is sherryh@phm.gov.au
Thanks,
Sherry
August 15, 2007 at 6:35 pm
Hi EdVassie,
Thanks for reminding me about user type objects in system databases. I did find lots of tables labled as user type. in SQL Server 2005 master database, I can see...
August 13, 2007 at 12:31 am
EdVassie,
a private message with my email has been sent to you. please find it.
Thanks,
Sherry
August 12, 2007 at 5:39 pm
Hi EdVassie,
Your advice on DTS packages are very useful, which I will take fully into account when migrating the databases.
I won't migrate the system databases as I also realize...
August 9, 2007 at 5:55 pm
Viewing 15 posts - 1 through 15 (of 21 total)