Microsoft SQL Server Tips & Tricks

Setup is ideally supposed to be an easy process, but more often than not we are fraught with a multitude of errors. This blog is intended to make life a little easier when it comes to SQL server setup. When we run SQL 2005 setup we get the following error: Read More...

What will happen if the indispensible SSMS crashes or worse just hangs? A lot of fretting!! (For the not-so SQLCMD savvy)....!! I have enclosed here two scenarios and their corresponding resolutions PROBLEM 1 When we start up SQL Server Management studio Read More...

Recently we encountered an issue while installation of client tools in sql 2005, so I would like to share the same in the following blog Problem Description The installation of the Client tools in SQL Server 2005 fails with the following error messages: Read More...

With Sql server 2000 and 2005 computed columns can be use to improve the performance of queries since without the computed columns, indexes cannot be used as explained in the following blog by one of our Escalation Engineer Jack Li. http://blogs.msdn.com/psssql/archive/2009/03/09/how-to-use-computed-columns-to-improve-query-performance.aspx Read More...