Imran Ashraf-452633 (6/14/2010)

---

I have a table that has 38 columns with a row size of 3939 bytes. There are 118000 records in the table. All the records need to be...

Thanks for taking the...

Interesting question.

By definition, SARGable means an index seek could be used. The key word there is 'could': a SARGable predicate gives...

There is a 'workaround' on the related Connect item:

https://connect.microsoft.com/SQLServer/feedback/details/522048/expanding-catalogs-on-a-2008-linked-server-using-sqlncli-to-sql-2005-causes-stack-dump

I haven't tested that because I cannot replicate the problem. I am running SQL Server 2008 and 2005 on the same...

Nils Gustav Stråbø (6/13/2010)

---

Paul, my mistake. I found the document in BOL I mentioned (), and the timestamp is required if you want to manually start an incremental population. It...

A trigger fires once per statement, not once per row.

The trigger code provided does not account for multi-row changes (more than one row in the inserted/deleted pseudo-tables).

Either prevent multi-row operations...

One motivation might be to take the log out of auto-truncate mode (assuming model...

With change tracking set to auto, SQL Server takes care of maintaining the full-text index for you. There is no need (or point) in writing a user trigger, and...

It might be - to be honest I can't be...

:laugh: I think that's kinda been the point since...

:laugh: !!!

Pesky?! I kinda like that.

I can't fix the other statement I don't think because it has columns in both sides of the...

sgalbra (6/11/2010)

---

...My assumption was that the compatibility runs the old query processing engine from parsing the query, to determining the optimized execution plan, and through executing the query. However,...

sgalbra (6/11/2010)

---

Is it just me or does Microsoft documentation just not explain compatibility levels very well? Usually the documentation just tells which options you can use, but does not...

So it needs fixing more...

Another way is to use dynamic SQL (for example if the excluded column is determined by a computation).

Example:

CREATE TABLE dbo.Test

(

...