put it on Ebay..

i dont think it makes a difference, i have tested it and don't see anything different in performance.

would like to see evidence to the contary if there is any..

Merge replication allows you to setup the conflict rules to handle this situation.

the problem you are going to have , no matter which method you choose, is that you will need a method of working out which change 'wins' when it comes...

you need to backup the t-log.

http://www.databasejournal.com/features/mssql/article.php/3559036/Backing-up-and-Restoring-Databases-in-SQL-2000.htm

you should reallly be backing up the t-log regulary to aviod this happening

any reason why? i know of a lot of...

yeah these threads pop up every now and again, and i feel that the real solution to protecting your IP would be to desgin the application to use complied...

bhawna.jain (6/24/2011)

---

I have already applied cell level encryption. But I don't want DBA to see the definition or modify any object. We are blocking DBA access for the security of...

why would you want to restrict the DBA? surely you are just making their job very difficult to do and if possible end up in a situaiton where the...

if you do not need absolutely the latest data then i would have a look at setting up cached datasets. you can preload the datsets at regular times and...

where are you doing the filtering for the where clauses? is it in the data set or in the report.?

how many datasets do you have?

there is First in SSRS,

are you refering to ssrs?

yeah you will need the indexes, you could just script them out from your old database and then run the script against the new database.

i am not sure...

I would then look at the slowest performing query and compare the execution plan between old (fast) and new (slow) to see where the difference is

how did you do the copy?

I would check the index fragmentation and fix ths if neccessary and

you may also need to update the stats. (unless you rebuild the inedexes...