January, 2012

Starting with SQL Server 2008 the product supports the ability to start using or stop using CPUs that are dynamically added or removed to a running system, either physically, logically (by online hardware partitioning), or virtually through a virtualization...

If you connect from SQL Server Management Studio (SSMS) to an instance of SQL Server, whether it is named or default, and rather than using the proper machine name (or machine name followed by the instance name, separated by the backslash) you use either...

This is another issue that was kindly exposed by our colleague, John Huang , from Canada, through the MCM community distribution list. Once an activated stored procedure finishes its execution, Service Broker runtime code doesn’t verify whether the maximum...

John Huang , a colleague from the MCM community , recently exposed to the rest of us a weird case which he decided to present as an “Interesting blocking issue”. I don’t know the exact details of what he was trying to implement, but basically, he had...

The INSTEAD OF INSERT Triggers topic in the documentation describes the following: An INSERT statement that is referencing a view that has an INSTEAD OF INSERT trigger must supply values for every view column that does not allow nulls . This includes...

As with any index, SQL Server can decide to use an indexed view (materialized views) in its query plan only if the query optimizer determines it is beneficial to do so . Indexed views can be created in any edition of SQL Server. But only in the Enterprise...

Together with the definition of each linked server goes a series of options that control different behavioral aspects of the way the linking server interacts with the linked one. Among those options there us one called “lazy schema validation”...

SQL Server can use read-only distributed partitioned views as a scale out mechanism , but any attempt to update any of these heterogeneous objects will fail with error 4451 (Views referencing tables on multiple servers are not updatable in the edition...