It seems to me that your questions about FTS are too general sorry. You should probably start from BOL "Introduction to Full-Text Search". Cheers

Lynn, sorry, just to clarify- theoretically (what actually I am asking about 🙂 one should not win/lose (from storage point of view) anything replacing ntext to nvarchar(max)? Thanks

Just curious- is there any explanation why replacing "ntext" data type by "nvarchar(max)" results in table size increasing? Thanks,

Jack, thanks a lot for your response.

If I got you there is no way to control/check success/failure of email sending

(I just used your query to check "sent_status" to "dummy" recipient-...

"Update Statistics" (or sp_updatestats ) does not have "online" option, sorry

"I know that by upgrading to enterprise i could do online reindexing"

Check BOL for Online reindexing limitations, i.e. in some cases (like tables with BLOB data) you can not do...

My preference is backup/restore (especially if DB files are big in size), risk of files losing/corrupting is also min:

1) full backup- restore with no recovery

2) stop applications (you...

Thanks Nick for your answer.

Actually this is pretty close to what I am looking for but not sure I can do this "hard code". Let's assume I have 30 products,...

Thanks, gents, for your help

Greg, Can you please clarify what you meant "data actually is routed through your workstation"?

I can not believe :w00t: that when you copy data from one disk to another...

Steve, sorry I probably was not clear- why there is a big difference in performance while running Wizard locally or remotely? It seems when it's running remotely (i.e. started from...

If you need to identify script that comprises link server name you need only to call sys.syscomments where text like '%linksrv_name%'

From BOL:

sp_linkedservers

Returns the list of linked servers defined in the local server.

Not sure regarding Profiler but if you would like to keep track of all deleted names then 1) create table 2) insert all deleted records into it using OUTPUT. You...

Thanks gents for your help.

Pradeep: Unfortunately these 2 links you provided me with is not my case- I have only 1 record to update and no function involved in Update.

Lynn:distributed...