Before you start the restore to recover PIT, you should still backup the current log of the db !

After that, you can restore your previous full backup ( PIT,...

btw

did you check the plan using a @variable in stead of the hard coded

Maybe vendorid 14 just generates a less optimal (non...

A trace file does not switch by day.

run

SELECT * FROM ::fn_trace_getinfo(default)

If you don't see an active trace, someone did disable the default trace for your instance.

There are...

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