Must Read – Performance

The Ten Rules of Performancehttp://www.panopticoncentral.net/articles/946.aspx and Improving .NET Application Performance and Scalabilityhttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpag/html/scalenet.asp My favorite quote:”If your software does not meet its performance objectives, your application is unlikely to be a success.If you do not know your performance objectives, it is unlikely that you will meet them”


Getting a string array from SQL Server

After the last post showing how to pass an array into SQL, i will show how to go the other way around. How to get a string array from a table. I should note that i ONLY pass and get arrays as strings on very specific cases (usually perf, test or dbg related). Whenever possible i use…


Passing an array to SQL Server

Often times i need to pass a variable number of arguments to SQL, and since there’s no array support i usually end up doing: Adding parameters to T-SQL with default values  Passing a string with some delimiter and building a table from that 1. Adding parameters to T-SQL with default values is something like: CREATE PROC…


Hello Blog

I decided to start sharing some thoughts on this blog, hoping they will help people the same way i have benefited from other blogs and web sources. I’ll blog randomnly mainly on System.Data, Xml and SQL Server, as they are closely related to my current job (perf for System.Xml, System.Data (DataSet especially) and MSXML) All…