quote:

---

Originally posted by amsqlguy

Guys,

I have 20 million row table which I split into 4 files in a single file group based on Clustered primary key, basically I recreated the primary key on a
file group. The data is now spread across 4 files, while this improved the performance of queries against this table I am trying to understand how does the
SQL process all the record inserts across the files in file group. In addition how is this file group different from partitioning using a partion function in terms of SQL Engine.

Any suggestions or inputs would help.
Thanks

---

Use Adventureworks 

-- get the file id's 
select * from sys.sysfiles
-- get the pages for a particular table 
Declare @dbid smallint,@tableid int
select @dbid=db_id(),@tableid=object_id('Person.Contact')
DBCC ind(@dbid,@tableid,-1) -- google to get the details of command
-- look out for pageType=1 data pages
-- look at the contents of the page
DBCC Traceon(3604)
--DBCC page(dbid,fileid,pagepid,0-3) -- google to get the details of --command
DBCC Page(@dbid,1,9689,3)
--scroll down to see the contents of page....u will find the actual ----data