Browse by Tags

Is it possible to estimate the space requirement for TEMPDB or factors that are affecting space?

Published 12 July 7 3:16 AM | SSQA.net

No straight answer to say yes you need so and so value to set on TEMPDB for such space requriement. By default i t is difficult to estimate the tempdb space requirement for an application. In general and one of the best practice is to allow 20% more space...

Filed under: sql server, fillfactor, indexes, trace, alerts, trigger, usage, tempdb, allocation, requirement

SQL Server 2005 & 2000 - Index optimization best practices

Published 22 May 7 1:31 PM | ssqa

In SQL Server 2000 for index defragmentation DBCC DBREINDEX and DBCC INDEXDEFRAG statements are used, as you are aware defragmentation on table does not yield performance gains in every case. Every scenario is different. Similarly, determining when you...

Filed under: sql server, performance, fillfactor, indexes, database

FILL Factor blurb to decide

Published 8 May 7 5:29 AM | SqlServer-QA.net (SSQA)

As all of us know that while creating Index for a Table there is Option for specifying Fill factor. This option specifies how full SQL should make in the Index Page while creating Index. Why this option is provided, should it not by default 100 ? What...

Filed under: sql server, performance, fillfactor, management, indexes