Beyond Web Logs

Gregg Stark has created a very nice query that is a great tool for optimizing indexes (indices) in SQL Server 2005.  Here's the query: SELECT o.name AS object_name, i.name AS index_name , i.type_desc, u.user_seeks, u.user_scans, u.user_lookups , u.user_updates, u.last_user_seek, u.last_user_scan , &#... [More]

SQL Server index, performance

Make sure Visual Studio 2005 SP1 is installed. Turn off animation. Go to Tools | Options | Environment and uncheck Animate environment tools. Disable Navigation Bar. If you are using ReSharper, you don't need VS2005 to update the list of methods and fields at the top of the file (CTRL-F12 does this nicely). Go to Tools | Options | ... [More]

How To visual studio, performance

Fragmented files in your hard disk causes your computer to slow down to an extent. Because if we need to read from a fragmented file it needs more time for the computer to find that file. so defragmenting makes your pc works faster. you can do this by following these steps Step 1 : Goto My computer, Right click on the disk drive and select p... [More]

General performance, hard drive, defragmentation