Hello All, Yesterday night while running our custom backup script,the database has been crashed. From Yesterday night onwards we are not able to log...
please solve my doubt 1.Does the DBCC indexdefrag achives index defragmentaion by organizing B-tree? what is the mechanism that DBCC indexdefrag...
1.We have large production database consisting of 50 tables and almost 200000 records. we have the script that executes twice in month to update...
hi every one, we have a production database having 50 tables, each conating 200000 records. how much time is needed for the exec "sp_updatestats"...
Does the performance tuning wizard really helps to improve the access time of database and user experience? is there any case study to confirm the...
Separate names with a comma.