How can you control the amount of free space in your index pages?
No Answer is Posted For this Question
Be the First to Post Answer
Explain database normalization?
what are the critical issues you have resloved in your company
What is the process of indexing?
what are user defined datatypes and when you should go for them? : Sql server database administration
What is merge?
Which command executes the contents of a specified file?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
Write a sql query to sort on different column name according to the parameters passed in the function?
What are recommended options to be used while using db mirroring? : sql server database administration
Can a table be moved to different filegroup?
What are the difference between primary keys and foreign keys?
Write a stored procedure for emplpoyee and department table to get DeptName which having no employee. Table Structure- Emp-Emp_Id,Emp_Name,Dept_id Dept-Dept_Id,Dept_Name
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)