Answer Posted / kishore
DBCC dbreindex('tabname','indexname','fillfactor')
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is dbcc? : sql server DBA
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
What are the different types of indexes available in sql server? : sql server DBA
what functionality does oracle provide to secure sensitive information?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
who owns the operating system files created by the utl_file package?
What is the default fill factor value? : sql server DBA
Where do you find the default index fill factor and how to change it? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
What is a correlated sub-query? : sql server DBA
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
internal architecture
how can you enable flashback feature?