Jacob's Blog

Having huge amounts of traffic can be a problem. Aside from the usual maintenance, you also need to check on the server load. Having a virtual dedicated server hosting can solve these problems.

August 2010 - Posts

SQL Server - Server-side paging with Row_number() function

Most application does some sort of paging on the client side to display only a certain number of rows to the user. For the best performance, this type of applications want to retrieve only the information needed for the current page from the database...

by Jacob Sebastian on 08-06-2010 | 12,313 Views

Tips and Tricks for Error Handling in ASP.NET Web Applications

This post highlights some of the most common Error Handling techniques in ASP.NET Web Applications...

by Jacob Sebastian on 08-05-2010 | 5,011 Views

SQL Server FILESTREAM feature and Differential Backups

This post tries to explain the behavior of differential backups on a FILESTREAM enabled database. A number of times, I see questions looking for a confirmation whether Differential Backups will correctly backup the NTFS (FILESTREAM) files and restore...

by Jacob Sebastian on 08-04-2010 | 3,205 Views

Getting started with PIVOT Queries in SQL Server 2005/2008

This post intends to help TSQL developers get started with PIVOT/CROSS TAB queries. Most business applications will need some sort of PIVOT queries and I am sure many of you must have come across pivoting requirements several times in the past. Let us...

by Jacob Sebastian on 08-03-2010 | 4,575 Views

How to load a huge file into a FILESTREAM column quickly

This post shows a quick and dirty way of loading a huge file into the FILESTREAM column of a SQL Server 2008 database instance. Note that this is an unsupported method which is not recommended on a production server. The correct way of loading BLOB data...

by Jacob Sebastian on 08-02-2010 | 3,503 Views