ASP.NET 2.0 has many secrets, when revealed, can give you big performance and scalability boost. For instance, there are secret bottlenecks in Membership and Profile provider which can be solved easily to make authentication and authorization faster. Furthermore, ASP.NET Http pipeline can be tweaked...

Today I was made aware by Filip, a colleague of mine, about the importance of columns used in a where clause with a compound index. I decided to investigate this a bit more in detail, with proper profiling and comparisons on a large data set. Read more at http://blog.cumps.be/efficient-compound-index...

Original Post: http://morewally.com/cs/blogs/wallym/archive/2006/12/27/616.aspx I went and spoke to the Michiana .NET User Group on November 21, 2006. The talk was in South Bend, IN. The subject of the talk was Sql Server 2005 CLR Objects. Whenever I do the talk, I got get the question of “Which...

You have a hot ASP.NET+SQL Server product, growing at thousand users per day and you have hit the limit of your own garage hosting capability. Now that you have enough VC money in your pocket, you are planning to go out and host on some real hosting facility, maybe a colocation or managed hosting. So...

Might need to create a separate page for notes on performance since I've been doing a lot of C# and database tuning lately but having them on this post so far. Here are some of my notes on performance [more] * Before you optimize, ensure that your results are accurate first before optimizing. I would...

When your database tables start accumulating thousands of rows and many users start working on the same table concurrently, SELECT queries on the tables start producing lock contentions and transaction deadlocks. This is a common problem in any high volume website. As soon as you start getting several...

Hiya. . . Some of you may have already seen this, but just in case you haven't; Some excellent SQL Server work from Michelle Ufford, also known as "SQL Fool". http://sqlfool.com/2009/06/index-defrag-script-v30/ Index Defrag Script, v3.0 June 23, 2009 by Michelle Ufford Filed under: Performance &...

NOTE: This is “Misfit Data” - While I do work for Microsoft, this data is NOT “official Microsoft” data and is not endorsed or ratified by Microsoft in any way. I built and ran these tests because I was personally curious about comparative performance. If these test results cause you dizziness, vomiting...

Yesterday I attended at local community evening where one of the most famous Estonian MVPs – Henn Sarv – spoke about SQL Server queries and performance. During this session we saw very cool demos and in this posting I will introduce you my favorite one – how to insert million numbers to table. The problem...