|
|
Browse by Tags
All Tags » sql server 2005 » SQL Server 2008 (RSS)
-
OK -
so this has been frustrating me for many months... when you create indexes with included
columns (which was a new feature of SQL Server 2005), they're not shown by sp_helpindex
or by DBCC SHOW_STATISTICS. I understand this not showing for statistics because included
columns are not factored into the histogram (that's
only the high ...
-
OK, I still have a way to go in learning about data compression in SQL Server 2008
but one thing that I do know is that nothing is free. So, the trade-off will be performance
(i.e. CPU) v. space. And, that's not really a new trade-off wrt to compression. Sometimes
that trade-off has other benefits that still minimize the ...
|
|
|