SQL Feeds - All your SQL feeds in one place.

Wednesday, March 03, 2010

Enabling Partition Level Locking in SQL Server 2008

by Thomas Kejser via Microsoft SQL Server Development Customer Advisory Team on 3/3/2010 11:54:00 PM

Author: Thomas Kejser Reviewers: Juergen Thomas, Sanjay Mishra, Stuart Ozer, Lubor Kollar, Kevin Cox, Kun Cheng In this blog, we will provide additional details on a well-hidden feature in SQL Server 2008 – partition-level locking. But before we illustrate the feature, here’s a bit of background about lock escalation and lock granularities. Background SQL Server has a lock manager that tracks which database objects are locked. Typically, a query will take locks at the row or page level, ...

[ read more ]

SQL Server 2008 R2 UNICODE Compression – what happens in the background?

by Peter Scharlock via Microsoft SQL Server Development Customer Advisory Team on 3/3/2010 12:06:00 AM

SQL Server 2008 R2 added a much requested feature: Unicode compression. It addresses the need to compress Unicode strings. It is implemented as part of ROW compression, which was added in SQL 2008. That is; if ROW compression (on SQL 2008 R2) is enabled on a table that contains NCHAR / NVARCHAR datatypes, then the Unicode compression algorithm will kick in for each individual Unicode column. Note: since PAGE compression is a ‘superset’, which also includes ROW compression, it will also enable Un ...

[ read more ]

SQL Server 2008 R2 UNICODE Compression – what happens in the background?

by Peter Scharlock via Microsoft SQL Server Development Customer Advisory Team on 3/3/2010 12:06:00 AM

SQL Server 2008 R2 added a much requested feature: Unicode compression. It addresses the need to compress Unicode strings. It is implemented as part of ROW compression, which was added in SQL 2008. That is; if ROW compression (on SQL 2008 R2) is enabled on a table that contains NCHAR / NVARCHAR datatypes, then the Unicode compression algorithm will kick in for each individual Unicode column. Note: since PAGE compression is a ‘superset’, which also includes ROW compression, it will also enable Un ...

[ read more ]

Subscribe

New Feed

Product Spotlight

Recently Updated Sources

Legal Note

The content of the postings is owned by the respective author. SQL Feeds is not responsible for the contents of the postings. This site is automatically generated and cannot be reviewed for abusive content. If you find abusive content on SQL Feeds, please contact us. Designated trademarks and brands are the property of their respective owners. All rights reserved.

Advertise with us