did you check Kimberly's very good white paper on partitioning ?

http://msdn2.microsoft.com/en-us/library/ms345146.aspx

BOL also has some info on sliding windows:

- "Transferring Data Efficiently by Using Partition Switching"

- "Designing Partitions to Manage Subsets...

I would alter the distinct to a group by on all columns.

Group by may take advantage of existing indexes.

what's the size of your indexes (pages) ?

seems to me like your data after exp is a date, so make it a datetime column !

pro:

- only date(time) values accepted

- the whole bunch of datetime related functions

con:

- no...

the original queries contained this where clause:

U.[user_id] = @original_user_id AND

U.[user_name] = @original_user_name AND

U.[user_surname] = @original_user_surname AND

...

Because of the parameter "DETAILED", it will perform like a dbcc updateusage with countrows....

BOL states:

.... The nonleaf levels of indexes are only processed when mode = DETAILED.

...

The DETAILED mode...

kubio (11/4/2008)

---

Hi all,

I had to write two separate queries to get what I want: that is, knowing the branchCode, get the email addresses from another table for two columns. This...

did you resync the users ?

at db level execute this to get an overview of the actions you need to take:

print 'print @@servername + '' / '' + db_name()'

print 'go'

go

declare...

best to do is compare the execution plans.

With sql2005 SSMS you can even save and post the .sqlplan if you want to.

using set statistics io on and set statistics time...

FYI

When I design a table, it always contains a datetime created / user created column as well as a datetime altered / user alterd column.

(the altered columns maintained using...

Best is to format all stuff in the front end application. (because this way you keep the datatime characteristics as long as possible)

Check out convert in BOL

I advise to use aliasses in queries !

- a delete only operates on a single object !

so you should perform TWO delete statements !

Since you have DRI implemented (FK) ,...

That's even easier than I thought. (using the help/about in ssms) :hehe:

The WMI query results to :

Display Name: Service Pack 2 for SQL Server Tools and Workstation Components 2005 ENU...

Could you perform this query just as a test:

(=your query but used as a nested table expression)

Select *

from

(SELECT c.comm_id AS [ID],

...

you'll have to check the dll library of sql2005 at client level.

WMI softwarelist may also help out.