Adi Cohn-120898 (8/22/2011)

---

The book is wrong. The number that is used when you declare a variable or define a column that is a Unicode, specifies the number of characters...

I have improved performance by removing a couple of sqlce result sets thus allowing me to remove the need for a max buffer size of 8192. Performance is better but...

Yesterday when the pageiolatch_sh locks were ocurring I opened perfmon and added the following counters Physical disk: reads/sec and writes/sec and SQL Server buffer manager: Page Life Expectancy.

I noticed that...