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.
2464explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
2423Post New iSoft SQL Server Interview Questions
What is the difference between the function module and a normal abap/4 subroutine?
What is hexadecimal color code?
How will you make an attribute not process? : sql server analysis services, ssas
Explain the difference between temporary storage queue (tsq) and transient data quene (tdq)?
Can viewdidload be called multiple times?
Do switches use ip addresses?
what is the difference between delete table and truncate table commands? : Sql server database administration
What are mq channels?
Suppose I am trying to assign a variable the value of 0123, but it keeps coming up with a different number, what's the problem?
What is Java Package and which package is imported by default?
What is difference between order by and group by?
What do you mean by pointcut?
Tell about the important components of erp?
Tell us something about an iterator.
What are the important topics in spring?