Limitations

by Bjørn Storkholm 24. November 2009 23:03
  • Biztalk taught me, not to put more than 65000 files in one folder
  • Microsoft CRM taught me not to do more than 1024 joins in one select statement (if you're working with SQL 2005 and newer)
  • Ibatis taught me not to use more than 2100 parameter in a sql command
  • Some stupid code taught me not to select 50000 rows and store them in session

Tags:

dotNet | Microsoft

Add comment



biuquote
Loading



Powered by McDonalds

About Bjørn

Bjørn StorkholmBjørn Storkholm has been working in the IT industry since the mid 90es, with a primary focus on Microsoft technologies. Started developing on the dotNet platform in 2001, when it was in it's early beta stages.

About the blog

This is a place where I can discover my own findings, after they have slipped my memory. But maybe others can find some usefull stuff here as well.

The blog is powered by BlogEngine