What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
- 0 Answers
- 649 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is the difference between Triggers and Stored Procedure?
Mention the 3 ways to get a count of the number of records in a table.
Why SQL Agent is used?
How to recompile stored procedure at run time?
Difference between Function and Procedure-in general?
What is ACID Property of Transaction?
What is partition, how will you implement it? : sql server analysis services, ssas
If any stored procedure is encrypted, then can we see its definition in activity monitor?
How can you stop stored procedures from recompiling?
How to create indexed view?
How to delete duplicate records from a table?(for suppose in a table we have 1000 Records in that we have 200 duplicate Records , so ,how to findout that duplicate Records , how to delete those Records and arranged into sequence order? one more thing that there is no primary key at all)
What is coalesce in sql server?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
