Search Results | SQL Server Performance Forums

page splits / file growth

Thread by: jeroen, Jun 15, 2007, 2 replies, in forum: General DBA Questions

Hi all, Is there a way to find out when/how often page splits occur, or file growth? Thanks for replying, Jeroen

updating a record that may not exist

Thread by: jeroen, Apr 12, 2007, 13 replies, in forum: T-SQL Performance Tuning for Developers

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...

Transaction log won't shrink

Thread by: jeroen, Nov 30, 2006, 2 replies, in forum: General DBA Questions

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,...

using heaps

Thread by: jeroen, Apr 2, 2006, 8 replies, in forum: Performance Tuning for DBAs

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...

Using subscriber as distributor

Thread by: jeroen, Mar 26, 2006, 2 replies, in forum: Performance Tuning for SQL Server Replication

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...

Transaction replication and foreign keys

Thread by: jeroen, Feb 26, 2005, 1 replies, in forum: Performance Tuning for SQL Server Replication

I set up transaction replication, and it worked allright for a few hours. Then there was a referential integrity error, which should not appear...

Deleting many rows - use clustered index?

Thread by: jeroen, Oct 30, 2004, 6 replies, in forum: T-SQL Performance Tuning for Developers

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...