what is Enhanced Read-ahead and Scan???? can anybody suggest any article on this topic?
what is Enhanced Read-ahead and Scan????? Can anybody suggest any article for this topic??
If i want to drop default contraint without knowing name i mean selecting contraint name in variable then pass variable to ALTER clause like...
hi all, How to select Last row of table..... if there is no index column......... Thanx
hi all, i m having table tempStores, having AccessCount column with default value 0 how to drop default contraint i tried this DECLARE @name...
Thnaks to all. finally i have restored my db from backup.......
hi, How to recover the data which get deleted? i was deleting some rows but i executed statment delete tablename there was no begin tranction, i...
How to checked for uncompleted transactions?
requirements: There will be accounts which may be store account, user account or admin account. user will place order for perticular store. so...
Hi, System is like this : Is is like online purchase, but product will be collected by user from physical store. there will be many Stores, which...
Hi All, I have given task of redesigning DB. I m doing this first time. we have tables accounts (contents AccountId(PK), all information about...
Separate names with a comma.
