In this case, I think you need to add the PERSISTED attribute in order to create the fulltext index.

STR is not a precise function.

SELECT COLUMNPROPERTY(OBJECT_ID('YourTableName'), 'YourColumnName', 'IsDeterministic'),

...

This online store appears to have a fair lot of SQL Server books available:

http://search.china-pub.com/s/?key1=sql+server&type=&pz=1&t=2

I'm pretty sure there are lots of online bookstores in China.

Alessandro, are you sure that this query contains the right predicates?

Usually, you want to surround OR conditions in parentheses.

SELECT DISTINCT TBL1.TBL1_ID

,REPLACE(TBL1_TITOLO, CHAR(13) + CHAR(10), ' ')

...

Can you post the definition of yuor computed column?

You can query the remote web edition using your locally installed SSMS.

SSMS Express can be downloaded free of charge and used to query any edition of SQL Server. Honestly, I...

You can use sp_MsForEachDB or any other replacement[/url] for that.

Jayanth_Kurup (3/5/2012)

---

I frankly wouldn't advice doing it using the model database:-

The model database is a template for all future databases. Do not change it unless you want the change in...

No, you won't even notice the difference.

CHECK constraints can get expensive when built with scalar UDFs with data access. Otherwise, the cost is negligible.

An indexed view could also do the trick.

See here: http://spaghettidba.com/2011/08/03/enforcing-complex-constraints-with-indexed-views/

If you have no joins, it could work.

If you have an alias to a remote table, the query will be executed against the remote table. The buffer pool would...

Performance will be awful, expecially if the query contains JOINs.

I would talk to the DBA and convince him/her to open the connection from Access.

I see it used all the time. Maybe it's just personal coding style/preference.

I didn't know this could work.

I've always seen things like DELETE sometable FROM sometable, but never ran into "double from".

Nice to know.

Interview question?

Try Google in the first place.

SSRS developers seem to be more requested now.