How to maintain a fill factor in existing indexes?
No Answer is Posted For this Question
Be the First to Post Answer
When you use @@error and try-catch?
How would we use distinct statement? What is its use?
you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration
Explain some stored procedure creating best practices or guidelines?
How to transfer an existing table from one schema to another schema in ms sql server?
What command do we use to rename a database?
What are the properties of the transaction?
What are number line correlation administrators will use while working with a subquery?
What is a view and what are its advantages?
What are “lock” hints?
Their are two tables 'A' and'B'.Table 'A' contains 3 columns named 'eid','ename','dept'. Table 'B'contains 3 columns named'sid','designation','salary'. We have to retrieve the names of employees working in the same department,same designation and same salary. Its urgent can anyone help me out in this problem.
Describe the left outer join & right outer join. : sql server database administration