How to change free space?

How to change free space? and When do i to need change free space?
oh yeah, Explain me of fillfactor so simple awayYour best place to start is BooksOnLine. Lookup Fill Factor and it will
point you to all sorts of good information. Also have a look at this:
http://www.microsoft.com/technet/pr...n/ss2kidbp.mspx
Index Defrag
Andrew J. Kelly SQL MVP
"Bpk. Adi Wira Kusuma" <adi_wira_kusuma@.yahoo.com.sg> wrote in message
news:euLMQrXrFHA.460@.TK2MSFTNGP15.phx.gbl...
> How to change free space? and When do i to need change free space?
> oh yeah, Explain me of fillfactor so simple away
>

How to capture the sql query

Hi
can someone explain how the profiler get the queries that are fired against the database. This information will be useful for building a customized trace tool.
ThanksRefer to Inside SQL Server book from Kalen Daleney and also you may get better information from MS Support about designing such a tool.

HTH|||look at the sp_trace_xxxxxx stored procedures