Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the basic concepts of SQL server architecture?
- 2 Answers
- 17105 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 |
What is a recursive stored procedure in sql server?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
how to avoid cursors? : Sql server database administration
If you are working on a SQL database and if suddenly a developer changes the code and your queries results start giving errors,how will you check using a T-SQL query (on system tables) that what has changed in the database.
Can select statements be used on views in ms sql server?
Why de-normalization required?
Can sql server be linked with other servers like oracle?
What is #table in sql server?
Which sql server table is used to hold the stored procedure script?
What is a covered index?
Define full outer join?
What is the difference between a local and a global variable?
-
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)
