SQL server Architechture is basically a partition of Logical and Physical

Explain the basic concepts of SQL server architecture?

Question Posted / bhushan

Answer Posted / bhushan

SQL server Architechture is basically a partition of
Logical and Physical data database.

Is This Answer Correct ?

17 Yes

11 No

Please Help Members By Posting Answers For Below Questions

What is change tracking in sql server?

1075

What is the primary use of the model database?

1129

Write the syntax for stuff function in an sql server?

1073

What is an execution plan?

1235

What are the purpose of Normalisation?

1095

How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?

1071

What is difference between Datepart() and Datename() in SqlServer?

1257

What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

961

Can multiple columns be used in sql group by clause in ms sql server?

1115

Explain features of analysis services?

1079

Is the order of columns in the set clause important in ms sql server?

1011

How do you rename a table in sql server?

1100

If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?

1175

What is a deadlock and what is a live lock?

1040

Explain the use of containers in ssis?

1014