How you structure your SQL queries is very important and choosing the wrong approach can have big effects on the performance of the query. This article shows the difference between an optimal query and a sub-optimal query resulting from subtle changes to the approach taken.

A performance walkthrough of passing a dynamic number of values to an stored procedure using the new table valued parameter support within SQL Server 2008, in comparison with XML and CSV parameter approaches.

When bulk loading data to an SQL Server database, the SqlBulkCopy class is invaluable. This article compares the SqlBulkCopy approach against an SqlDataAdapter approach to demonstrate the difference in performance, and how to squeeze even more throughput out of the bulk load process.

There are a number of ways to sort the data within a DataTable and this article compares 3 ways to find out what the performance difference is between the different approaches, and which offers the most scalable solution.

The impact of performance is much more readily apparent in .NET Compact Framework applications. The mobile devices commonly have a CPU that is 10 times slower than your desktop CPU, and possibly up to 100 times less RAM than a desktop or server. In Agile or XP development, the mantra is often to i...

When you create rich Ajax application, you use external JavaScript frameworks and you have your own homemade code that drives your application. The problem with well known JavaScript framework is, they offer rich set of features which are not always necessary in its entirety. You may end up using on...

Google have announced some new tools and services for web developers.

A little but handy helper class to run (small) performance tests.

Strings of type System.String are immutable (read-only) in .NET because its value cannot be modified once it has been created. That means any change to a string causes the runtime to create a new string object and abandon the old one. That happens invisibly. Following code allocates three new string...

Extended Events are the new low level, high performance eventing system in SQL Server. They use less system resources and provide better tracking of SQL Server performance than previous methods like Perfmon and SQL Trace/Profiler events.

When and how to use linq to filter Collections

A comparison between performance improvement using concurrent threads on multiple CPUs

Hosting a WCF service to transfer streaming data using tcp sockets. The article describes how to tune a WCF service to handle large files and transfer them across the network using net tcp binding.

Stop the waiting when debugging your ASP.Net Web Applications! Here's a complete RAM Disk solution to save your sanity.