btw Paul: Nice series on execution plans at sqlblog :smooooth:

Appartently something went wrong with the attached sqlplan.

Just double checking we're testing with the correct engine version. (some still use sql6.5/sql7.sql2k 😉 )

Indeed even without the order by the index...

- are you actually on SQL2008 ? @@version

- Are your statistics up to date ? (autoupdate statistics = on / sp_updatestats after load)

- what's the fragmentation rate of your...

- Can you post the actual ddl of as well table and _all_ indexes ? (mybe even statistics)

- can you post the actual generated plan for both queries ?

(you can...

Jack Corbett (7/27/2010)

---

I don't think it is ironic at all. It is because we are passionate about what we do and we want to see others gain that passion...

As stated in books online:

To create a synonym in a given schema, a user must have CREATE SYNONYM permission and either own the schema or have ALTER SCHEMA permission.

The CREATE...

code .... code .... code please.

- is this native tsql

- is this another kind of prog.code that performs the exec dynamic sql

- are you using SQLNCLI ?

- are you performing frequent LOG backups ? If not, please do ! It helps your DRP and keeps your log files under control.

Check out the great article Gail wrote...

I hope you realize using shrink(db/file) in general is a bad practice !

If you don't have a real need to do the shrink operation, just don't do it. Your db...

Thank you for the feedback. I'm glad you got it in a working state.

Have a nice weekend.

Just my 2ct.

Someone must have had a "overload where clause" button as we can see in queries like this one.

" ...

I think you have misinterpreted how a sliding window actually should work.

Maintain an empty partition on both ends of the partitioned table and ensure that only empty partitions are split...

- What would your user be using when (s)he enters his multiple lines ?

- how would these multiple lines relate to the row, to each other, to whatever other object...

no. sp3 of our subject (sql2005)

I got the same error message, but the table doesn't get dropped.

What's your product version info ?

(I tested on 10.50.1702.0 and 10.50.1720.0)

Select Serverproperty( 'BuildClrVersion' ) as BuildClrVersion

, Serverproperty(...