Pages and Extents: Stairway to SQL Server Indexes Level 4 (SQLServerCentral 3/6/2019)

[SQLServerCentral - www.sqlservercentral.com]( A community of more than 1,600,000 database professionals and growing Featured Contents - [Pages and Extents: Stairway to SQL Server Indexes Level 4]( - [Free eBook: Defensive Database Programming]( - [One-way and Two-way Tabulation Example in SQL Server - Part 2]( - [Transform your SQL Server permissions]( - [SQL Server, What's In My Buffer Cache?]( (From the SQLServerCentral Blogs) - [How to get Live Execution Plan using Extended Events]( (From the SQLServerCentral Blogs) The Voice of the DBA The Data Incident I was reading [a Google whitepaper]( and I think this was the first time I'd seen a potential loss of data referred to as a data incident. The paper deals with the response from the Google Cloud team if there are potential data loss issues, outlining a four part process for responding and ensuring the customer can get back to work. [Azure has a similar plan](, though [AWS seems to expect the customer to do more of the work](. This is the first public disclosure of a process, and it's a good one. In fact, everyone should use this or have something similar in their organization. The way that the world seems to be moving, it's likely that most of us will suffer a breach at some point, and we ought to know how to respond. Without some plan, it's easy to have a situation spiral out of control. I've had formalized DR plans as well as incident responses for events such as a DDOS or virus attack, but the issues with data are somewhat different and probably deserve a dedicated plan of some sort. While I've often seen these handled under the security team response, that might not be enough for data services, especially when you have responsibility for data that is different than managing a software system or service. Data security is becoming a more important part of the data professional's job, with legislation and best practices starting to require that we recognize a shared interest in sensitive data that extends beyond our organization. Whether this is something you like or dislike, it is becoming a part of our work. Personally I like having a crafted plan that is available for use in crisis situations. It can be hard to remember all the possible issues, and certainly crisis seem to occur when our best people aren't available. Even more important, a plan means we have something we can practice to be sure that everyone understands how to react, limit the exposure of data, and even ensure that we can get services back up and running as soon as possible. Steve Jones from [SQLServerCentral.com]( Join the debate, and [respond to today's editorial on the forums]( --------------------------------------------------------------- The Voice of the DBA Podcast Listen to the [MP3 Audio]( ( 3.4MB) podcast or subscribe to the feed at [iTunes]( and [Libsyn](. [feed]( The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. ADVERTISEMENT [SQL Change Automation]( CI/CD for your SQL Server database Feeling the pain of managing and deploying database changes manually? Redgate SQL Change Automation completes your database delivery process by building, testing, and deploying the database changes you and your team check into version control. [Try it free]( [SQL Source Control]( How to track every change to your SQL Server database See who’s changing your database, alongside affected objects, date, time, and reason for the change with SQL Source Control. Get a full change history in your source control system. [Learn more]( Featured Contents  [] [Pages and Extents: Stairway to SQL Server Indexes Level 4]( David Durant from [SQLServerCentral.com]() We've now seen how indexed and non-indexed tables perform in queries, and established "logical reads" as the metric for query performance. Now it is time to explain why logical reads are an excellent metric and also explain what is actually being read. [More »](Series/72352/) ---------------------------------------------------------------  [] [Free eBook: Defensive Database Programming]( Press Release from [Redgate]() Resilient T-SQL code is code that is designed to last, and to be safely reused by others. The goal of defensive database programming, the goal of this book, is to help you to produce resilient T-SQL code that robustly and gracefully handles cases of unintended use, and is resilient to common changes to the database environment.[More »]( ---------------------------------------------------------------  [] [One-way and Two-way Tabulation Example in SQL Server - Part 2]( Additional Articles from [MSSQLTips.com]() In this tip we demonstrate how to use dynamic SQL and stored procedures to simplify the computation with SQL of one-way and two-way tabulations.[More »]( ---------------------------------------------------------------  [] [Transform your SQL Server permissions]( SQL Census helps users understand who has access to their SQL Servers (including Active Directory groups) and simplify existing SQL Server permissions. A new feature reworks discrete user permissions into database roles, giving users the same effective rights in a more controllable structure. Download and use SQL Census (in preview) for free.[More »]( ---------------------------------------------------------------  [] From the SQLServerCentral Blogs - [SQL Server, What's In My Buffer Cache?]( Gavin Draper from [SQLServerCentral Blogs]( When SQL Server reads pages it stores them in an area of memory called the buffer cache, things like memory...[More »]( ---------------------------------------------------------------  [] From the SQLServerCentral Blogs - [How to get Live Execution Plan using Extended Events]( Joyful Craftsmen from [SQLServerCentral Blogs]( Introduction Have you ever found yourself in a situation where you were supposed to troubleshoot a long running expensive query that...[More »]( Question of the Day Today's Question (by Steve Jones): I want to get a set of the odd numbers less than 100. Which of these produces that set? Think you know the answer? [Click here](, and find out if you are right. --------------------------------------------------------------- We keep track of your score to give you bragging rights against your peers. This question is worth 1 point in this category: Python. We'd love to give you credit for your own question and answer. To submit a QOTD, simply log in to the [Contribution Center](. Yesterday's Question of the Day Yesterday's Question (by Kendra.Little): You create a new SQL Server database. You check right away, and there is a table in the database named dbo.foo. It has 10 rows of data in it. What is the most likely cause of this? Answer: There is a table named dbo.foo in the model database with 10 rows of data in it Explanation: The model database is used as a template for all new databases. If you created a dbo.foo table in model, or someone else did, then it would be in all new databases. Ref: Model database - [click here]( --------------------------------------------------------------- [» Discuss this question and answer on the forums]( Database Pros Who Need Your Help Here's a few of the new posts today on the forums. To see more, [visit the forums](. --------------------------------------------------------------- [SQL Server 2017]( : [SQL Server 2017 - Administration]( [Domain Accounts for SQL Server Services]( - Hi I have installed SQL Server 2017 (RTM-CU12) on a server. When installing I used domain accounts that I have used on... [Nested Subquery vs Correlated Subquery]( - [Best way to mirror SQL database of customers to our SQL database]( - We have installed a SQL 2017 database on a Windows 2016 server at our customers (about 20) worldwide. We Installed a... --------------------------------------------------------------- [SQL Server 2017]( : [SQL Server 2017 - Development]( [Query Question]( - I am some what of a self taught developer and was looking for some guidance if the query I have... [HOW TO USE EXISTS FUNCTION WITH 3 TABLES]( - Can you Please show me that how can we use EXISTS FUNCTION WITH 3 OR MORE TABLE. Please show me... [WHERE Clause exclusions, best practices.]( - Hello, I was just wondering if anyone has a good idea on how to implement a set of filters that we... --------------------------------------------------------------- [SQL Server 2016]( : [SQL Server 2016 - Administration]( [SQL Service Start before App DBs Drives on line]( - What happens if SQL starts up from C drive, but it takes 5 minutes before the E and F drives... [Restoring backups overview]( - I'm all we have at the moment, and I'm trying to learn everything I can about disaster-handling before the event.... [recreate a Basic Availability Group question]( - hi, In the process of changing IPs for one node of a clustered server with databases in a Basic Availability Group... [Always On]( - I know we can have 4 secondary database using Always on. However, i am little unsure that 4 secondary means... --------------------------------------------------------------- [SQL Server 2016]( : [SQL Server 2016 - Development and T-SQL]( [Query runs slow when executing under the context of a different DB]( - I am trying to understand this behavior but when I try to use the below code and execute it in... [Slow in the Application, Fast in SSMS. How to force the execution plan generated by SMSS]( - Hi, This is my second case this week where the same query is fast in SSMS and slow in the application.... [Why would SQL Server not run?]( - I've got SQL Server 2016 Developer Edition installed on my desktop. I don't get in it frequently, I'll admit. However,... --------------------------------------------------------------- [SQL Server 2012]( : [SQL 2012 - General]( [Error 9020 - The log for database failed to grow while shrink in progress. Please retry]( - Hi - I noticed this entry within the SQL log file this morning. I have checked the DB properties for this... [Can I set TDE Encryption off while my db actively in use?]( - We have a DB about 45GB (32gb compressed-backed up) that has TDE setup, I need to remove encryption so I... [Always On SQL Server 2012 Enterprise. After failover DB Owner ist lost.]( - Hello Folks, After a failover of one of my SQL server instances it happends that one specifed database lost its dbowner.... --------------------------------------------------------------- [SQL Server 2012]( : [SQL Server 2012 - T-SQL]( [Save the actual execution plan of a SQL statement in a script]( - I have a script that runs in SSIS from an "Execute SQL Task". One statement that is taking about 1... [Overlapping Date Ranges]( - Hi there, I have looked in many forums and have been unable to find what I am looking for to get... --------------------------------------------------------------- [SQL Server 2005]( : [Administering]( [Database in Recovery Pending State]( - One of my databases is in Recovery pending state. I tried to run an Alter command on the database to... --------------------------------------------------------------- [Microsoft Access]( : [Microsoft Access]( [Export memo field to Excel truncates values]( - I am using MS Access 2007. There are two tables each having a memo column. I have written a IIF statement to... This email has been sent to {EMAIL}. To be removed from this list, please click [here.]( If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com. --------------------------------------------------------------- This newsletter was sent to you because you signed up at [SQLServerCentral.com](. Feel free to forward this to any colleagues that you think might be interested. If you have received this email from a colleague, you can register to receive it [here](. --------------------------------------------------------------- This transmission is ©2018 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. Contact: webmaster@sqlservercentral.com