Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ratheeshknair
Posting Yak Master
129 Posts |
 Posted - 2007-10-26 : 13:04:45
|
| Hi all Can anyone please explain me 'What happens when we execute a select query'??how come the server knows that those particular datas are in which file???Thanks in AdvanceRKNAIR |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-26 : 13:09:39
|
| Data is not stored in files, but rather objects. If you are using multiple data files, then SQL Server keeps track of which objects are in which files via the system tables. SQL Server has a ton of system objects where it keeps track of everything.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
help