10 Essential Excel Skills You Need To Know

1-Freezing Rows and Columns If you have a lengthy spreadsheet containing tons of data, you may have to scroll too far down or even across to view it all. This means you will lose sight of your headings and find yourself constantly scrolling back to see them. However, if you freeze the rows and columns,…

Read more

How To Enable Instant File Initializating And Improving Sql Server Performance

What is 'File Initialization' ?  When the database data files talk to the disk, they have to be 'initialized'.  This means that any newly allocated space is overwritten with zero values (0×0). Windows does this to avoid problems by accessing old data, previously stored on the same disk. This zero File Initialization causes operations like…

Read more

Understanding SQL Server Recovery Model

Recovery Models in SQL Server are basically designed to control the transaction log maintenance and to help you recover your data from a disaster. There are basically three different types of recovery models available in SQL Server 2000 and higher versions namely Simple, Full and Bulk Logged. The choice of a specific recovery model purely…

Read more