Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the basic concepts of SQL server architecture?
- 2 Answers
- 17133 Views
- College School Exams Tests, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Sql server is having Physical database & logical database
On Physical Database contians file groups and Transcation
log
in file group Contains data files-36,767 TB
data file contains of tabel -
tabel containts extents
Extents contains Pages
pages Contains rows
Transcation log is Userdefined filegroup by default it's
primary file group
Logical - database objects like
view,Sp,functions,Triggers,Indexes and roles etc
| Is This Answer Correct ? | 33 Yes | 10 No |
Answer / bhushan
SQL server Architechture is basically a partition of
Logical and Physical data database.
| Is This Answer Correct ? | 17 Yes | 11 No |
Is candidate a key?
How to resolve the orphan use problem? : sql server security
Explain about the command-line tool SQLCMD?
How to drop existing indexes in ms sql server?
how many type of indexing in database?
Write query to return all rows sql?
How do database indexes work?
How to create user defined functions with parameters?
What is multi-statement table-value user-defined function?
What is a trigger and its types?
What is #table in sql server?
Can primary key be a foreign key?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
