Monthly Archives: September 2007

Practical SQL Server 2005 CLR Assemblies

Consuming a Web Service from a SQL Server 2005 CLR Assembly Practical SQL Server 2005 CLR Assemblies One advantage of CLR assemblies is the ability to consume web services from within the database. This wouldn’t be easy with T-SQL, and … Continue reading

Posted in Uncategorized | Leave a comment

Making the case for Full Text Search

Making the case for Full Text Search Use Case for Full Text Search On a recent project, one of the needs was to search by a few different sets of criteria which were in a number of different tables with … Continue reading

Posted in Uncategorized | Leave a comment

Compress Asp.net Ajax Web Service Response – Save Bandwidth

Compress Asp.net Ajax Web Service Response – Save Bandwidth In this post, I will show you how to compress the Asp.net Ajax Web Service response, To understand the benefits of compression let us start with a simple example, Consider you … Continue reading

Posted in Uncategorized | Leave a comment

Pivots with Dynamic Columns in SQL Server 2005

Pivots with Dynamic Columns in SQL Server 2005   Pivots in SQL Server 2005 can rotate a table, i.e. they can turn rows into columns. PIVOTs are frequently used in reports, and they are reasonably simple to work with. However, … Continue reading

Posted in Uncategorized | Leave a comment

OSQL: Storing result of a Stored Procedure in a file

OSQL: Storing result of a Stored Procedure in a file   BCP works ok if you want to store the contents of a table to text file. If you want the contents of a stored procedure it gets complicated. In … Continue reading

Posted in Uncategorized | Leave a comment

Exporting Data Programatically with bcp and xp_cmdshell

Exporting Data Programatically with bcp and xp_cmdshell

Posted in Uncategorized | Leave a comment

Creating CSV Files Using BCP and Stored Procedures

Creating CSV Files Using BCP and Stored Procedures Create a simple CSV file The simplest way to copy data from a database table to file is to use the basic BCP command: BCP master..sysobjects out c:\sysobjects.txt -c -t, -T –S<servername> … Continue reading

Posted in Uncategorized | 4 Comments