Sql server management studio.

Enable "include actual execution plan" to get the execution plans [Query\include actual execution...

Who am I ? Sometimes this is me[/url] :alien: and most of the time this is me :hehe:

Paul White NZ (7/29/2010)

.. but I was looking for the plan...

Missed it !

Here's the index(0) execution plan.

And the new full executions plan.

execution stats: ( time and io ON )

SQL Server parse and...

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...