What’s the use of custom fields in report?
How will u get 5 years back record?
What are user-defined functions (udfs) in sql server?
How many clustered indexes there can be on table ?
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
How to override dml statements with triggers?
What is the importance of concurrency control?
What are different type of Collation Sensitivity?
Can we write a distributed query and get some data which is located on other server and oracle database?
How would you use user_constraints table in DB?
How do you clear a log file?
How use inner join in sql server?
How do SQL server 2000 and XML linked?