Vidhya Sagar – Blog

New article on SQL Server 2005 Best Practices posted in main website, you can read the article from the link below.

SQL Server 2005 Best Practices

Vidhya Sagar General Administration, SQL Server 2005

Query tuning is an interested topic in SQL Server. Deepak has written an article on query tuning in our main website, please read the article below and make use of it.

Most of the DBA’s new to query tuning would wonder where to start in order to tune a query. I hope this article would probably guide them in understanding the steps to begin with.

Query Tuning Steps

Vidhya Sagar Performance Index

Deepak has written an aritcle on Index Usage in www.sql-articles.com. You can check out the article in the link below.

I have used the Contact table with person schema which is residing in AdventureWorks database for testing the index usage. I am describing the scenarios and places where index seek or scan will be used.

Index usage

Vidhya Sagar Performance Index

SQL Server 2005 SP3 released today after the release of SP3 beta a couple of weeks ago. You can download SP3 from the link below.

DOWNLOAD SQL SERVER 2005 SP3

Above download link is applicable to below products.
* SQL Server 2005 Enterprise
* SQL Server 2005 Enterprise Evaluation
* SQL Server 2005 Developer
* SQL Server 2005 Standard
* SQL Server 2005 Workgroup

For Express edition check the link http://go.microsoft.com/fwlink/?LinkId=64064 for SP3.

For a list of new features and improvements that are included in SQL Server 2005 SP3, review the What’s New document.
Once the server is patched with SP3, SQL Server version will be changed to 9.00.4035. You can use the below query to check it.

SELECT SERVERPROPERTY('ProductLevel')

SELECT SERVERPROPERTY('ProductVersion')

Vidhya Sagar SQL Server 2005 Administration, Service Pack, SQL Installation

In previous versions of SQL Server we have used sp_makewebtask procedure to generate HTML output for a query. From SQL Server 2008 MS has depreciated web assitant procedures. You can find this option under surface area configuration (SAC) in SSMS 2008 however if you enable this option for SQL Server 2008 you will be thrown with the below error message.

TITLE: Microsoft SQL Server Management Studio
——————————

This method cannot be called on the server version 10. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.1600.22+((SQL_PreRelease).080709-1414+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.UnsupportedVersion&LinkId=20476

——————————
BUTTONS:
OK
——————————

This parameter is provided in SSMS 2008 for backward compatibility. i.e If you connect to SQL 2005 and then you can use this option.

Ok Now comes the question. How can I generate HTML output in SQL Server 2008 without using web assistant stored procedure?
The only option is to use reporting services to generate HTML output in SQL Server 2008. As an alternate you can also write your own T-SQL statements to print HTML tags while generating the output thereby creating a HTML page.

Vidhya Sagar SQL Server 2008 SQL Server 2008, T-SQL