Satya, Thanks for this link. Jeroen
Hi all, Is there a way to find out when/how often page splits occur, or file growth? Thanks for replying, Jeroen
Hi all, I have a simple table with a few million records. Quite often I will have to update some non key field in a record. If that record does not...
Hi, I have moved my sql2000 database over to a new server running sql 2005. The recovery model is set to full. Now I have a 15G transaction log,...
There's the primary key, one index on psv_prs_id,psv_var_id and one on psv_var_id. Indexes are rebuilt on a weekly basis. I could do it more often,...
Thanks for your replies. I read about the sequential guids in the thread I posted above, so I'm thinking about using it. The reason I think I have...
psv_id primary key, guid psv_prs_id guid, foreign key psv_var_id guid, foreign key psv_value nvarchar psv_prs_id,psv_var_id is a candidate...
On this thread I read a discussion about heap tables: http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=9684 I have a table that has...
Thanks Twan, Yes all servers are on a 100Mb network.
I have 2 servers that are going to replicate to a 3rd server that is doing the reporting. Is it a good idea to make this 3rd server the distributor...
I had exactly the same problem. First you run the sp_scriptpublicationcustomprocs procedure, then run the generated statements on the subscriber...
I set up transaction replication, and it worked allright for a few hours. Then there was a referential integrity error, which should not appear...
Thanks for all your suggestions. It looks like there's not really much I can do. There are much more rows to be kept than to be deleted, and some...
Hi all, I have a table that holds about 6 million records: id (PK) res_id (FK) qst_id (FK) number (smallint) value (varchar(8000)) I've got some...
Separate names with a comma.
