What are page splits? : SQL Server Architecture
No Answer is Posted For this Question
Be the First to Post Answer
What do you mean by acid?
can i write function in stored procedure and stored procedure in function and nested procedure.Give one example for each question?
Explain optimistic and pessimistic concurrency?
i use few third party softwares. they r all having their own databases . but the data is repeated in all these databases - say a person is in all the three databases, but his name is stoared in diff format in all databases i want to create a centralised database ,and i dont want to re-enter the records . using the exisating records how can i build a centralised database?
Why do we need different type of parameter?
How to delete database objects with "drop" statements in ms sql server?
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
How to list all tables having unique constraints in any of the columns in a database.
What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas
How to rebuild the master database?
Explain having clause and where clause?
What are the advantages of using stored procedures? Please don't simply say compilation time will be saved as they are already complied. Please specify some other advantages.
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)