Viewing 15 posts - 46 through 60 (of 213 total)
might want to put with nolock on it
so it doesnt lock itself
or readuncommitted
February 28, 2011 at 9:42 am
clustered indexes, since they are how the data is physically stored the index is in with the data not in a separate index file
February 24, 2011 at 1:35 pm
i would copy the stage database to production
called new_db then ren db to old_db
ren new_db to db
smallest downtime i would think
February 24, 2011 at 12:08 pm
in my enviroment where i have 50 state databases that talk to each other alot I use db.dbo. alot to get to the right database
And in development, so of the...
February 24, 2011 at 10:32 am
usually there is more to the tables than that
so products,sizes, colors and years would make since
normalize it for future issues and flexiblity
the size of the xref file will be...
February 24, 2011 at 10:26 am
you could do it in a trigger probably
but that would be a rbar in the trigger
or you could try a computed fields which should work
February 24, 2011 at 9:21 am
have you run sp_blocking or look in blocked by of sysprocesses
to see if someone is blocking it
February 24, 2011 at 9:05 am
http://johannesbrodwall.com/2010/10/13/database-refactoring-replace-table-with-view/#
I missed this because i found this website
February 24, 2011 at 8:58 am
simple just means it clears it when it is done
now the question here is it possible that you may need to do a point in time restore, if i remember...
February 23, 2011 at 2:38 pm
another option would be to use transactional replication from the 3 children to a read only version of the master
February 23, 2011 at 2:32 pm
merge replication isn't hard to setup but there is an overhead to it
you are basically writing the records on 2 servers
you also have to be careful with identity column issue...
February 23, 2011 at 2:29 pm
i have had similar problems when trying to open an r2 plan from 2008 server but not from 2 r2 servers
February 23, 2011 at 2:24 pm
i have created both types of maintenance plans on 10.50.1600
February 23, 2011 at 2:21 pm
ssms management
database mail
configure
then manage
then view change or delete
February 23, 2011 at 11:28 am
Transactional replication or log shipping
or snapshot
Transactional replication will update the data all the time
If you update any data in the report server the replication jobs could fail
create...
February 23, 2011 at 9:43 am
Viewing 15 posts - 46 through 60 (of 213 total)