October 2007 - Posts

• So-called "exact" numerics are not at all exact!

  Attempting to dispel myths tends to make me feel like Don Quixote, riding against hordes of windmills that won’t budge. In this case, even some of my fellow MVPs and Microsoft’s own Books Online are among the windmills… Books Online says that there are Read More... Posted Wednesday, October 17, 2007 1:42 AM by Hugo Kornelis | 14 Comments Filed under: Mythbusting

• How NOT to pass a lot of parameters

  Did you know that SQL Server allows stored procedures to have up to 2100 parameters? And more important: do you care? Well, some people do care, and Joe Celko seems to be one of them. If you are a regular reader of SQL Server newsgroups, you probably Read More... Posted Thursday, October 04, 2007 10:07 AM by Hugo Kornelis | 15 Comments Filed under: T-SQL, Performance, Best Practices Attachment(s): Sudoku.zip