The problem only affects 64-bit Standard Edition.

In 32-bit Standard Edition,...

These Cookies![/url]

I'm a fan of SELECT * after EXISTS...:-) though I must admit that it is frustrating that the syntax is invalid when the object is schema-bound.

If you are unable to add a rowversion column to the base tables, you could keep track of changed data using a trigger to record the primary keys of modified...

The Express version will allow you to write and compile code, but don't be disappointed when you find that there are no SQL-Server-specific templates (for CLR stored procedures, functions, triggers,...

Hey Mike - I saw your question and thought 'hmmm - now where did I post that other reply earlier...?'

So thanks for saving me a job!

Paul

edit: turns out it was...

To add to Grant's reply, it is also possible that the statistics just aren't covering the new values at all.

Consider a table with an indexed column which always increases when...

happycat59 (10/15/2009)

---

There is only one circumstance when an index will not be updated and that is when the index is disabled. If it was disabled, it might as well...

Ian,

:laugh: Me? No, never! :laugh:

Just me taking the answer as seriously as the OP took posting a question (see my sig block)...

But, if you want the %%physloc%% thing to...

Yeah. So obviously just for fun ;c)

The 2008-only %%physloc%% is even more interesting since it gives an encoded form of the row locator.

For a heap, this will be the...

It's important to mention that all %% pseudo-columns are undocumented, unsupported, and very cool.

'Urgent' really does seem to work!

SQL 2008:

CREATE TABLE

dbo.Employee

(

ename CHAR(3) NOT NULL,

salary INTEGER NOT NULL

);

...

Having CLR enabled and loaded consumes around 100MB of VAS.

Another point to bear in mind is that CLR can be loaded even when disabled - some of the internal MS...

Mike McQueen (10/8/2009)

---

While we're on the topic of computed columns and execution plans, I have a question that has been nagging at me.

If you check out the execution plan of...