SqlServer-QA.net

May 25 2007-  From the snippet of Tibor Karaszi, SQL Server MVP I have raised a feedback form on Connect.Microsoft website to get newer version (SQL Server 2005) about Index Defragmentation Best practices information. Vote your interest to get newer documentation quickly for most of our benefit to attain the performance. Jan 04 2008 - ...

Interesting popup message on the down-right corner of my laptop when I'm performing SQL Server tasks against a 2005 version database using SQL Server Management Studio (SSMS), displays the message ''Microsoft SQL Server Management Studio is waiting for an internal operation to complete. If you regularly encounter this delay ...

Imagine a simple installation of SQL Server Express 2005 edition fails with an error ''SQL Server service failed to start?'' Whether it may be on a X64 based operating system or on a simple desktop with XP PRO, as usual you would go with default install options. When the installation fais always best to check the error log for the reason ...

I believe since Windows 2000 server days you can take advantage of Indexing Service that creates indexes of the contents and properties of all files on local and network drives in order to increase file searching speed. It's quite similar to ''Find Fast'' that ships with Microsoft Office. There is a downside in using this option ...

Yet another update to SQL Server 2005 Books Online, though it states May 2007 update that was released on June 06th 2007! During February 2007 with the release of Service pack 2 Microsoft has updated the BOL content to reflect the changes with SP2. For this one: The May 2007 update to Books Online contains new material and fixes to ...