Posted by: Joey Snow | Apr 13th @ 7:00 AM
There is a lot of talk these days around business intelligence, and it's important that we at IT Professionals understand what is is, what it came from, and where it's going. The folks over on the Business Intelligence team sent me this video that tells the story of B.I. in a very unique way.
The History of Microsoft
Visit the CHANNEL9 at MSDN and know the Microsoft's history with text and videos. Rebuilding Indexes and Updating Statistics, the correct sequence...
Rebuilding Indexes or Updating Statistics, which do you do first? Why? Are there differences? Rebuilding an index will update statistics with the equivalent of a full scan - doesn't matter whether you use DBCC DBREINDEX or ALTER INDEX...REBUILD, the effect is the same. It can do this because it sees a complete picture of the index while it’s doing the rebuild. Reorganizing an index (using the old DBCC INDEXDEFRAG, or the new ALTER INDEX...REORGANIZE) will NOT update statistics at all, because it only sees a few pages of the index at a time. So, which is the correct sequence? Backup And Restore Remain Time
If you execute a BACKUP or a RESTORE using the SQL Server Management Studio (GUI), the percentage completed will be shown on the screen for each 10% completed, ex.: 10%, 20%, 30%....
Read more...
If you need to know, how long does it take?...use the DMVs and a simple SELECT, check the script below. Columns: START TIME, PERCENT COMPLETED, COMMAND, DATABASE NAME, STIMATED COMPLETION TIME, MINUTES TO FINISH. Windows Sysinternals
There are some free tools that we can use in Windows environment that help us in performance analysis, troubleshooting, documentation usage, and server configuration. |
|
More Articles...
|
|
|
| Page 1 of 5 |
Language Selection
Statistics
Members : 1Content : 25
Content View Hits : 22472
Articles
We have 1 guest online
