RSS

Archive | SQL RSS feed for this section

The FILESTREAM Data Type in SQL Server 2008

24. September 2008

0 Comments

Seriously, i’ve no time these days for blogging, busy with work as well as personal activities. but just wanted to share this valuable information for those who might have missed. Well the current project which im working on is the ASSETTE Presentations. for more information on the project you can see the above link. but the [...]

Continue reading...

SQL Server 2008 Table Valued Parameters

23. December 2007

4 Comments

Last two weeks I have been working on developing bulk data manipulations. And even before that I always wondered “What’s the best way to pass an array of values into a SQL Server stored procedure.” One option I found was OPENXML, which I blogged here. And I was trying out visual studio 2008 and SQL [...]

Continue reading...

ADO.Net & OPENXML to Perform Bulk Database Operations

18. December 2007

3 Comments

Last week at my work I had to write a tool to process few hundreds of thousand email files and insert their details to the MS SQL Server 2005 database. Doing it in traditional way might require much connectivity to the database and will consume many resources. I was wondering what if I could insert [...]

Continue reading...