thnx!! It is indeed an option to drop the index, add the data and build the indexes again.

However: there are about 100.000.000 rows of statistics, so rebuilding the index will...

TheSQLGuru (10/21/2008)

---

You REALLY should have given us the function code! Anyway, I can tell what is happening even without it: You are doing table accesses on the options...

no sorry, just google it (that is what i always do 😉 )

In a trigger you can select the data before the change from the "deleted" table, and the data afther the change in de "inserted" table (well, it isn't realy a...

you should use the "deleted" and "inserted" tables in your trigger:

ALTER TRIGGER [dbo].[USER_UPD_HIST] ON [dbo].[User] FOR UPDATE

AS

BEGIN

INSERT INTO User_History(ID, Usermodified, etc.)

SELECT ID, Usermodified, etc.

...

As far is i know you have to use the CONTAINS method to make usage of the fulltext search.

So the answer is NO

But ofcourse there is a very simple way...

Thanks a lot, this is EXACTLY what i was looking for.

Thanks for your answers.

Unfortunately (and as you excpected) i have no proof of anything since there is hardly any monitoring done at our servers. I will see if i can...

Peso (6/12/2008)

---

Since you seems to have the Enterprise Edition, go for the

CREATE PARTITION FUNCTION over your partitionNr column,

and have a job that runs nightly to update the partitionNr...

k, thnx!

but in your example you are using viewpartitioning like the blog you posted : http://weblogs.sqlteam.com/peterl/archive/2007/09/24/Horizontal-partitioning.aspx

When i use the SQL2005 feature of tablepartioting, this wil be the same...

I read the whole document, but i still have 2 questions:

1. My table is already filled with data, is it...

We access the data always by idproject, but also by date. I know partitioning by date is common and even in my case a good option. But the majority of...