October 26, 2007 at 7:47 am
Hi All
Can anyone explain me is there anything like catalog in SQL Server?.When we execute a select statement how the server knows, in which file is data???
Thanks in Advance
October 26, 2007 at 7:49 am
You can get the database files from the sysfiles "select * from sys.sysfiles" view.
Or are you interested in filegroups?
Regards,
Andras
October 26, 2007 at 10:15 am
My question is when we execute a select query how server came to know that in which file is that particular data.....
October 26, 2007 at 10:25 am
Date is stored on pages, each page has an id. The pageid also contains the file id (you can map these based on the query I've sent you). So once SQL Server knows which page it needs to read, it can determine the file. Concerning which pages it needs to read depends on your query/indexes. I suggest you read Kalen Delaney's Inside SQL Server: The storage Engine book.
Regards,
Andras
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply