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.
2467explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
2426Post New iSoft SQL Server Interview Questions
why QA team is necessary for an organization?
how to calculate duct fittings surface area ?
What is the functionallity difference between radio/option buttons and a drop-down list box besides appearence? i.e. When it is better to use one instead of the other?
MOP: can MOP is use for Industrial Purpose ? If yes ? what are the uses ? and which industriesw use ? If not use what is the reason? Can it be exported ?
What are the types of functions in excel?
Can method names be capitalized?
Given a business requirement, wherein you have to execute all the available actions in a single workflow rule, what would be the sequence of actions ?
What is main/jni/ directory?
Tell me whether the account “cash” will be credited or debited, when a company pays a bill?
I KNOW THAT INSURANCE CHARGES ON PURCHASE OF VEHILE (LIGHT/HEAVY VEHICLES)HAS BEEN CAPITALISED OR NOT.?
If there is still an m: drive mapped, why does the free space number look funny?
A number of combiners can be changed or not in MapReduce?
Expand-------ACNS
In a sales interview if a person ask us how would you be able to sell our products in this recesion. How would i have to respond them.
does the query needs a hint to access a materialized view?