The answer to yesterday’s Simple Puzzle Using Union and Union All, explained with an image. My UNION vs. UNION ALL article explains why it works.
SQL SERVER – 2005 – Mechanisms to Ensure Integrity and Consistency of Databases – Locking and Row Versioning
Books Online describes two mechanisms to ensure integrity and consistency of databases: locking and row versioning. Here is how it defines each one.
SQLAuthority News – 500th Post – An Interesting Journey with SQL Server
I am very pleased to write my 500th post on SQLAuthority. Thank you to my family and to all of you, plus a look at the blog’s milestones so far.
SQL SERVER – Understanding Licensing Models
The licensing structure has evolved to reflect advances in technology and diverse use cases. Below are the primary licensing models available:
Reading the SQL Server Error Log Properly
Read the SQL Server error log for startup details and incident context, filter it with T-SQL, and cycle files without losing needed history.
SQLAuthority News – SQL Joke, SQL Humor, SQL Laugh – Funny Microsoft Quotes
I have received many emails that I should write more post like SQLAuthority News – SQL Joke, SQL Humor, SQL Laugh – Funny Quotes.
SQLAuthority News – Fix : Remote Desktop Copy Paste Stop Working
My Remote Desktop copy paste stopped working both ways while I worked on a remote SQL Server. Restarting did not help, but the fix at the end of the post did.