MSSQLTips

What is difference between Update Stat and DBCC DBREINDEX .......... after doing dbcc dbreindex database size become smaller

I am having doubt - is it achivable Or not? The senario is , "If the outer transaction is rolled back, then all inner transactions are also rolled back" is it any way to avoid Rollbacking of inner transactions?? Thanks, srinivasan r

Hi, I’m looking for a table ore stored procedure which gives me al the information about the Maintenance Plans on a SQL Server. For example Backup Folder, witch databases are selected and so. I did find a quite a lot store Procedures and some views whit information about Maintenance Plans and Jobs, bud...

Good day all. I have about 25 SQL boxes that are 2000 and 2005. I have all the maintenance plans running successfully nightly now. What I would like to accomplish is to have all the history reports go to one location and email a report on the failed jobs. SQL 2005 doesn't have the option to add a...