Adds columns to, drops columns from, and changes column attributes in an existing table. Adds, modifies, and drops integrity constraints from an existing table. Restriction: You cannot use any type of ...

One of the interesting new features in SQL Server 2008 is Change Data Capture. I wrote about Change Tracking in a previous blog entry. That will track the what, when and who but will not tell you ...

BANGALORE, INDIA: Think of a mechanism that can automatically log all changes to your database tables; how valuable could those log values be to database administrators. With Microsoft SQL Server 2008 ...

Modify columns. Optimize table schema (from v3.2), including modifying the bucketing method and the number of buckets. Create and delete the rollup index. This statement is a synchronous operation.