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
How to select Last row of table.....
if there is no index column.........
i m having table tempStores, having AccessCount column with default value 0
how to drop default contraint
i tried this
Thnaks to all.
finally i have restored my db from backup.......
How to recover the data which get deleted?
i was deleting some rows but i executed statment
there was no begin tranction, i...
How to checked for uncompleted transactions?
There will be accounts which may be store account, user account or admin account.
user will place order for perticular store.
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...
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.