Keep-Learning.com

"where the knowledge lives"

 
  • Increase font size
  • Default font size
  • Decrease font size

The History of Business Intelligence

E-mail Print
(3 Votes)
User Rating: / 3
PoorBest 
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.
Read more...
 

The History of Microsoft

E-mail Print
(1 Vote)
User Rating: / 1
PoorBest 

Visit the CHANNEL9 at MSDN and know the Microsoft's history with text and videos.

Very interesting to know the Microsoft's evolution through the years.

Read more...
 

Rebuilding Indexes and Updating Statistics, the correct sequence...

E-mail Print
(3 Votes)
User Rating: / 3
PoorBest 

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?

Read more...
 

Backup And Restore Remain Time

E-mail Print
(2 Votes)
User Rating: / 2
PoorBest 
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%.... 

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.
Read more...
 

Windows Sysinternals

E-mail Print
(1 Vote)
User Rating: / 1
PoorBest 

There are some free tools that we can use in Windows environment that help us in performance analysis, troubleshooting, documentation usage, and server configuration.

You can download these tools from Windows Sysinternals website:

Read more...
 
  • «
  •  Start 
  •  Prev 
  •  1 
  •  2 
  •  3 
  •  4 
  •  5 
  •  Next 
  •  End 
  • »


Page 1 of 5

Language Selection

English

Statistics

Members : 1
Content : 25
Content View Hits : 22472

Main Menu