There are many occasions where a SQL Server Developer uses scripts which take longer to execute. I would rather say a wrong choice or approach in writing scripts caused the execution of the script longer. There are smarter ways to achieve results. In this post I will try to consolidate few tips on smarter SQL Server programming.





Do you want to delete all rows from a table?

Use Truncate instead of Delete statement. Truncate is… Continue

SQL Server 2005 has lots of new features, of which one is PIVOT clause. This is similar to Pivot tables in MS Excel and Matrix Control in Reporting Service. Here is a simple example demonstrating how to use PIVOT clause. I am right now taking a simple example. There are scenarios where there could be a need to write a big stored procedure to build a Pivot table in lower versions of SQL Server.



Do run the below query in Query Analyzer… Continue

Advanced Stream Redirector (ASX) files are based on the Extensible Markup Language (XML) syntax, and are made up of various elements with their associated tags and attributes. This is designed to store a list of Windows Media files (.WMA, .ASF, .WMV) to play during a multimedia presentation. The ASX files can be effectively used to play songs over the Internet/Intranet through HTTP protocol.



I will not write here on how one…

Continue

Considering an example web application where the application allows uploading files with extension DOC, RTF, XLS, PPT, GIF, JPEG, PDF and MSG. The view page has the list of attachments and allows viewing files by invoking relevant applications. But files with .MSG do not open or do not invoke Outlook to view it.



The solution for this is in fact very simple. Do follow the following steps:

• Open IIS and navigate to the web…

Continue

Injection of HTML code and/or client side scripts like JavaScript, VBScript, and Jscript by malicious web users into the web pages viewed by other users is a computer security vulnerability typically found in web applications. This is popularly known as Cross Site Scripting (XSS) Attack.



Injection of the code can be done either from a web form or through a query string input. To check whether your web application is open to XSS, insert the following code given below in… Continue