What are recommended options to be used while using db mirroring? : sql server database administration
No Answer is Posted For this Question
Be the First to Post Answer
1. What are the grouping function in SQL ? 2. If base table of a view deleted means, what will happen while we querying on view ? will give any error ? 3. Difference between DROP, DELETE, TRUNCATE table ? 4. What is constraints and types ? 5. What is max size of nchar & nvarchar ? 6. Define ROLLBACK, COMMIT, SAVE POINT 7. How non-clustered better ? or rank the Clustered, Non-Clustered and Table scan in performance wise 8. Select 10 rows from a table ? 9. Define DML, DDL, DCL, DTL commands ? 10. What is mean by NULL value ? NULL means "" or 0 or undefined ? 11. Default constraints ? 12. Can we have more then primary Key in table ? 13. Type of integrity ? Entity, Referential, Domain ?
How to automatically create a log when an exception is being received into SQL Server?
How the authentication mode can be changed?
Where can you add custom error messages to sql server?
What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio
Difference Between ORDER BY Clause and GROUP BY Clause in SQL?
How do you drop an index?
What is etl - extraction, transformation, and loading?
What is resource governor?
What stored by the msdb? : sql server database administration
employee table has employee id ----------- empid ---------------- 1 2 3 3 3 4 5 5 5 6 6 6 7 here the values r repeated two times.how to select the repeated values only.i.e 3,5,6 should alone come.
Why truncate is ddl command?