Probably later we can think about it (problem is that string can be from domain, folder, file in your design approach). But currently I have what I have- whole url....

I can't call this table static as new records with new url are inserted pretty often. Thanks

Table I mentioned (pretty big ~15 million rows) has url column varchar(800). Query is looking for records (id) where this url contains some string (sometimes 15-20 characters). I know that...

It's not from MS-taken from Kalen's InsideSQLServer website. Search Internet

Unfortunately, syntax you used is incorrect (@a + @b-2), i.e. this version doesn't work either. Thanks

Thanks, I'll try this way

Thanks, Yelena. I know how to use updatetext when using text data from another table:updatetext testText1.content1 @ptr1 0 null testText2.content2 @ptr2. But can't do something similar with writetext.

OK, make sense- you suggest simply copy from somewhere 32K string and insert into writetext data. Probably this works but frankly I thought about something more elegant like...

Yelena, thanks, but in this article data is 'This is new text-value…', i.e. data is again varchar, not real text (I mean how we can put 32K string here?!). My...

Thanks guys for your help. New column in particular place- my boss requirements.

Thanks. Actually I thought the same way

Thanks, Zach. Eventually I added this row (~35 minutes) from EM. My challenge is: to replace existing column id (bigint) with new one id(bigint, identity (82,256)). My plan is: 1)drop...

No, I try to restore only 1 Diff back (after Full one that succededed). Yes, I restored Full backup with No Recovery (as DB has loading status)

Thanks

Yes, tables are in the same DB. I don't know how to check table collation but columns collations as I pointed are the same- default DB. Thanks

Thanks for your replies.

Ray: probably I wasn't clear. I need  top 10 sources with biggest sourcenumbers (actually, it's score for every source) and then for each source from this 10...