Posts
Sort by recent activity
Database name as a parameter
I appreciate the facility to ignore the Database name when object naming includes it in synonyms, but I wonder if you might take it one step further for me?
We have a number of instances on the sam...
Changing the Compression on a table is not a schema change
As part of a system test I set compression on my database tables, (all 3200 of them) to NONE as I was investigating some of the issues with estimated cardinality being wrong on SQL Server 2008 R2. ...
DATA_COMPRESSION = PAGE causes an error when using SVN
We are using SVN and when I check in a table which has both for the table and the indexes DATA_COMPRESSION = PAGE (using SQL Server 2008 R2), the check in works fine, all susequent attepts to check...