Moving a database to new hardware with little downtime uses early restore, a maintained log chain, final synchronization, and a tested client switch.
SQL SERVER – Introduction to Discovering XML Data Type Methods – A Primer
The XML data type has five methods in SQL Server 2008. This primer from Joes 2 Pros Volume 5 introduces the XML data type methods, starting with query().
SQL SERVER – Introduction to SQL Error Actions – A Primer
Many think an error of severity 11 or higher stops the rest of the batch. This primer on SQL error actions shows it is true only most of the time.
SQL SERVER – Introduction to Basics of a Query Hint – A Primer
Query hints apply to the whole statement through the OPTION clause. This primer from Joes 2 Pros Volume 3 covers the basics of a query hint.
SQL SERVER – Introduction to Hierarchical Query using a Recursive CTE – A Primer
A primer from Joes 2 Pros Volume 2: what a CTE is, how it compares to a derived table, and how to write a hierarchical query using a recursive CTE.
SQL SERVER – Introduction to SQL Server Security – A Primer
A primer on SQL Server Security terms with a simple story: Tom needs Read access to the Financial Folder. Learn what a securable, principal and permission are.
Columnstore Data Types: What Compresses Well and What Is Blocked
A great compression number means little if the index rejects one column. Here is how to test both questions on your own server.