few years ago i did this. i had to move a replicated database and didn't want to reinitialize replication. i forced a detach by dropping all...
i would be careful with this. i run netbackup and that installs Sybase to handle internal operations. Tivoli probably installs a lite version of DB2...
i always try to query the minimum amount of data. we have some databases in the TB range and people always select months and years of data at the...
1. in BIDS there is an option to import DTS packages. another time consuming option is to save each DTS on the new server. you'll have to open and...
if you have the hardware then there is no license to buy to go from x86 Windows 2003 to the x64 version. you can even install R2 using the same...
is your hardware x64 compatible? i would look into reinstalling the OS with the x64 version as well if your're not going to upgrade the OS to x64 i...
if you buy the hardware in the next few weeks then it's going to be ridiculously powerful. next year when the new 32nm CPU's come out the power is...
what is the OS of the cluster? if it's windows 2000 then no and you will need to upgrade to windows 2003 and/or buy new hardware depending on how...
not sure if you can use execute as in a view, but what about running it as a stored procedure and using execute as sa?
if you have spare hardware or vmware i would test. restore a copy of the RS database to a sql 2008 server and connect with a 2003 server running RS
we do full backup weekly and daily differentials a few days a week. small databases 1GB and under get a full backup 4 times a week. Full backups are...
very big differencebuilding a home there is usually one way to do it right so that the work meets quality and safety standards. my mom bought a home...
check your data and which column the clustered index is on. could be it's causing every single page to be written to instead of only a few pages we...
what kind of problems are you having? we solved a lot of our problems by moving to x64 on the publisher, a lot of the subs and the distributor as...
see if you can delete and redo this and check the size of the files before and after the restore a backup will only backup the data but if there is...
the exams are made to test the test world and not real world. most people don't use all the features of SQL or use a lot of third party products for...
my spanish is pretty rusty, pero you can try this add with (nolock) todos su stored procedures para utilizar select
used it and people complained about the cost with the new SAS drives you can use RAID5 and you will never see the difference. in fact I think it's...
rebuild your clustered index
a reorganize doesn't update statistics and you will need to run that a dbreindex drops and recreates and index and the statistics are rebuilt as...
Separate names with a comma.
