Explain the basic concepts of SQL server architecture?
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 |
What are the system database in sql server 2008?
What is the security principal at the database level that represents your session?
Why SQL Agent is used?
how to select a field with firstletter as capital and remaining are small letters
What is entity data services?
What are different types of database indexes?
What is database mirroring?
What does the update command do?
write an SQL query to list the employees who joined in the month of January?
How to enforce security in sql server? : sql server security
Explain the storage models of OLAP?
I have a table in which phno is one of the columns.i do have some values in tht phno column.i need to update phno column values with 0(zero) as prefix.give me a correct solution plz...
Oracle (3253)
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)