Saturday, March 17, 2007 - Posts
In SQL Server designing efficient indexes is paramount to achieving good database and application performance. The selection of the right indexes for a database and its workload is a complex balancing act between query speed and update cost. Narrow indexes,
Read More...
I was searching for this task on my Reporting Services, but unable to find where exactly I can perform this change. Then with the help of Object explorer you can accomplish the task, this is how you have to: -Navigate the report that is required to configure,
Read More...
IMHO and expereince do not let autogrowth get out of control on your SQL Server database. This is most important factor for the databases capacity planning and with this you might need an additional check-over to confirm the database size levels. I'm
Read More...
Still I can remember the features in Office 97 with Word, Excel and Powerpoint. Office 2003 extended the features to the databases and other formats. Now Office 2007 is out now which is a 'wow' factor as I have heard. I have received the Beta copy couple
Read More...
Previously Service Broker admin tool was in Beta version and recently Microsoft release the Admin tool for RTM version and with Service Broker, a feature in Microsoft SQL Server 2005, internal or external processes can send and receive guaranteed, asynchronous
Read More...
Take an in-depth look at the internals of the SQL Server Storage Engine—with advice from a popular author and SQL Server expert. Database developers and administrators get best practices, pragmatic advice, and code samples to help master the intricacies
Read More...
A big question for every SQL Server user when a new version is released! Indeed, this was my question initially when looked at Microsoft SQL Server website homepage where the site is fully equipped with SQL Server 2005 version. It is more important for
Read More...
Recently I have been asked in MSDN forums about how to start a SQL Server 2005 Reporting Services report builder from Internet Explorer, the solution is open the IE and type http://localhost/reports or in http://reportserver/reportbuilder/reportbuilder.application
Read More...
A newbie question about How can I know more about SQL Server Reporting Services 2005 verison, then here is answer: http://www.sql-server-performance.com/sm_sql_2005_reporting.asp
Read More...
How to know whether my indexes are being used or not? This is most interesting question I have come across through the forums since the SQL 2000 version usage days, you may not have easy way to find out using SQL Server 2000 or even you have to run a
Read More...
In the README.HTML for SQL Server 2005 Service Pack 2 there are install instructions that covers the uninstall procedures too: > 1.3 Uninstalling SQL Server 2005 SP2, Once SQL Server 2005 SP2 has been applied, it cannot be removed without uninstalling
Read More...
With the latest release of SP2 Update release it has been a rumour in the community that it is a SP2a release, which I believe not as it is intended to fix a particular issue with cleanup tasks and maintenance plans. As the remaining tasks with Service
Read More...
Until the Office 2003 version in Excel application there is no feature to store the data more than 65536 rows in Excel. With Office 2007 version this is not a problem, but there are few cases you might neet to use previous version of Office software then
Read More...
Now a days there has been 'good' changes within the Microsoft product development and support with more trustworthy computing features, recently I have been going through for a information in Visual Studio and then I came accross the following information
Read More...