to explain sql server 2000 architecture & authentication
Answer / madhuri
Sql server architecture
Database having physical and logical databases
in physical databases contains filegroup and Transcation log
in filegroup consists of datafile--36,767 TB
datafile consists of table--a single table can have 1024
columns.
Table consists of extents---8 contigious pages 1 extent--
64KB
exetents consists of pages---8KB
pages consists of rows---8060 bytes(max row size)
Tnasaction log is userdefind filegroup by default it's
primary file group.
Logical --- database objects like
views,sp,functions,triggers,indexes and roles etc.
------authentication modes
There are two types of Authentication modes.
1.Windows Authentication Mode.
2.Sql server Authentication(mixed mode)
Is This Answer Correct ? | 3 Yes | 0 No |
Which command is used for user defined error messages?
Is it possible to call a stored procedure within a stored procedure?
What triggers long term care?
What is the purpose of the model database?
What is instead of trigger sql server?
Explain what is the difference between union and union all?
What is the datatype of rowid?
What is a raid and what are different types of raid configurations?
What according to you is the difference between mysql and sql server performance?
What is the diffrence between update_one and auto_fix?
what is syntex second or third highest salary. thanks & Regards Dhirendra sinha
Can you get second highest salary from the table?