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,...
On this thread I read a discussion about heap tables:
I have a table that has...
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 set up transaction replication, and it worked allright for a few hours. Then there was a referential integrity error, which should not appear...
I have a table that holds about 6 million records:
I've got some...
Separate names with a comma.