Browse by Tags

Vote now: Index defragmentation best practices for SQL Server 2005 documentation - feedback received from Microsoft

Published 4 January 8 5:35 PM | SSQA.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...

Filed under: defragmentation, sql server, indexes, microsoft, i/o, best practices, feedback, sql express, connect

SQL Server is waiting for an internal operation to complete, message on SQL Server Management Studio

Published 17 December 7 2:49 AM | SSQA.net

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

Filed under: sql server, performance, microsoft, users, sql express, service pack2, management studio, slow, delay

Unable to install SQL Server Express - Error SQL Server service failed to start?

Published 7 November 7 1:33 PM | SSQA.net

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

Filed under: sql server, microsoft, services, error, sql express, installation, encryption, build, log file, 15029

"Allow Indexing Service to index this disk for fast file searching"

Published 25 July 7 3:3 AM | SSQA.net

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

Filed under: sql server, indexes, microsoft, services, windows, sql express, xp, file search, 2003

SQL Server 2005 Books online May 2007 updates are available now

Published 11 June 7 3:22 AM | SSQA.net

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

Filed under: sql server, microsoft, update, BOL, documentation, sql express