Thanks for this link.
Is there a way to find out when/how often page splits occur, or file growth?
Thanks for replying,
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...
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_prs_id,psv_var_id is a candidate...
On this thread I read a discussion about heap tables:
I have a table that has...
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...
I have a table that holds about 6 million records:
I've got some...
Separate names with a comma.