One of the presenters at recent SQL Server Open World conference in Denmark ( http://www.miracleas.dk/index.asp?page=168&page2=323 ) suggested tuning SQL queries using logical IOs to measure quality of query plan. The IO count is returned for each
Read More...
Interesting observation with table > 1TB We have a project using SQL 2005 with a table that is several terabytes. This table has a varbinary(max) column with an average length of 150k bytes. We needed a second copy of the table on a smaller test server
Read More...
