And the column datatype is text.

I should mention that the program is a Java program, and the SQL server version is 2005 (9.0.3282)

Thanks a lot for all your great tips. I did try to increase the fillfactor up to 90% but still fragmentation is SO QUICK. I'll try and work with the...

The PK is on an id column. Many (most) queries in our system are id-oriented and therefore it seemed like a good choice. Most of them use the id column...

Well this is a very old post, but I am having the exact same problem.

I have a procedure that rebuilds indexes once a month. I can't do it in a...

Thanks so much!!!

OK, I managed to find an explanation on performing a "sliding window" operation, which is basically switching partitions with tables, and that way moving new data in and old data...

.... And it worked!! For both Oracle and SQL Server.

Thanks!

That's great!

Only it doesn't work in Oracle.... That's the reason I didn't use the "decode" function in Oracle- it does exactly what this function does but doesn't work for SQL...

That was it! So simple....

Thank you thank you!

Oh, and I should point out that during the database re-installation today I have not received any errors. The database (and management studio) were working fine until few days ago....

One more thing...

The report returns results in management studio and from the reports services (visual studio), BUT:

After I deploy the project, from the browser I don't get ANY results,...

Thank you, Jeff. This is exactly what I needed. This helps a lot.

I see I have managed to annoy you. But believe me- I had no intention to... 🙂 I...

In case anyone has ever came across such a problem here's the solution:

In order for the login who's default database is the restored database to be able to connect to...

Thank you for your reply.

I cannot drop the schema, since objects in the database are attached to the schema (and of course I don't want to delete those tables. Whan...