Indexes with Included Columns: Stairway to SQL Server Indexes Level 5 (SQLServerCentral 3/27/2019)

[SQLServerCentral - www.sqlservercentral.com]( A community of more than 1,600,000 database professionals and growing Featured Contents - [Indexes with Included Columns: Stairway to SQL Server Indexes Level 5]( - [Free eBook: Fundamentals of SQL Server 2012 Replication]( - [SQL in the City Summits – UK, US & Down Under]( - [Create Azure Data Lake Linked Service Using Azure Data Factory]( - [Capturing a Workload with WorkloadTools]( (From the SQLServerCentral Blogs) - [Querying temp tables across a linked server.]( (From the SQLServerCentral Blogs) The Voice of the DBA Giving Computers Ethics I was reading a fascinating paper recently about autonomous cars. I'm actually excited about having a car that can drive itself, though I think this is likely quite a few years away, despite the hype. Ever since I read [Red Thunder](as_li_qf_asin_il_tl?ie=UTF8&tag=way0utwest-20&creative=9325&linkCode=as2&creativeASIN=0441011624&linkId=4307d100772a8f410ac1f87a328a5938), I've thought that we would first get full time autonomous cars that would either be limited in where they were in use, or part-time autonomous cars that could only be self-driving in certain places. Dense inner cities, or maybe isolated highways might be good places to try this, in my mind. While we want to do some programming of these cars, we also have a lot of AI/ML systems in place that run models trained to react in certain ways. They identify things that are moving and stationary, trying to determine how the car should navigate and react. The systems aren't quite as tightly programmed as many of us expect, with if this then that logic. Instead they have guidelines that are decided upon by the designers and then reactions to data inputs and analysis are a little more fuzzy. What are the goals? Well, in most cases they are just moving the car safely down a road. In crisis situations, it's a little more murky. What happens when collisions are unavoidable? How should the car react? Humans often panic and do strange things, but we don't want erratic behavior from automated systems, so what should we set as goals? [There's a bit of research]( that was done to ask humans what they would do when they can consider the situation a little more slowly. In short, humans make different decisions in different cultures. There are clusters and tendencies in different parts of the world, which is interesting. While people are people and behave similarly in many cases, we tend to value different things, depending on our views of the world. That can be problematic when we start to expect computer systems to be more consistent or predictable. After all, we should decide how computers react and be able to trust our decisions are followed. It is up to humans to imprint our ethical desires as a society on computer systems. This is an area where I feel AI and ML systems are moving faster than our ability to comprehend the implications. I would want to have a framework built for automated systems, certainly cars, and then expect all vendors of systems would implement that framework in their vehicles. However, this goes beyond cars, and in any places where we are using software, AI/ML based or not, we ought to publish a comprehensive outline of the way in which our system works. Computers have the capability to improve our world and reduce chaos, but only if we agree on the way in which these systems work, and disclose in a transparent way what data they handle and what decisions they make based on that data. I hope that we start to get better about informing the world the goals and operation of our systems. I'm not sure that will happen anytime soon. 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]( ( 5.6MB) 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 Provision]( SQL Provision: Create, protect, & manage SQL Server database copies for compliant DevOps With SQL Provisions virtual cloning technology, databases can be created in seconds using just 1MB of storage, and sensitive data can be anonymized or replaced with realistic data to ensure it is protected as it moves between environments. [Download your free trial]( [Data Masker]( Redgate Acknowledged as Representative Vendor in 2018 Gartner Market Guide Data Masking has come of age and Gartner’s?2018 Market Guide for?Data Masking includes analysis, recommendations and representative vendors to help you start your data masking journey on the right foot. [Get your complimentary copy now]( Featured Contents  [] [Indexes with Included Columns: Stairway to SQL Server Indexes Level 5]( David Durant from [SQLServerCentral.com]() Included columns enable nonclustered indexes to become covering indexes for a variety of queries, improving the performance of those queries and with the only overhead being an increase the size of an index.[More »](Series/72276/) ---------------------------------------------------------------  [] [Free eBook: Fundamentals of SQL Server 2012 Replication]( Press Release from [Redgate]( Fundamentals of SQL Server 2012 Replication provides a hands-on introduction to SQL Server replication. The book introduces you to the technologies that make up replication, and then walks you through setting up different replication scenarios. When you've finished reading, you should be able to implement your own multi-server replication setup while following the principle of least privilege.[More »]( ---------------------------------------------------------------  [] [SQL in the City Summits – UK, US & Down Under]( Redgate are inviting senior data professionals to attend one of the upcoming SQL in the City Summit events taking place in April, May and June. If you’re interested in learning how your business can benefit from implementing Compliant Database DevOps this event is for you. Find out who’s presenting and register for a Summit near you today. Register now[More »]( ---------------------------------------------------------------  [] [Create Azure Data Lake Linked Service Using Azure Data Factory]( Additional Articles from [MSSQLTips.com]( In this article we walk through a step-by-step example on how to create an Azure Data Lake Linked Service in Azure Data Factory v2.[More »]( ---------------------------------------------------------------  [] From the SQLServerCentral Blogs - [Capturing a Workload with WorkloadTools]( Gianluca Sartori from [SQLServerCentral Blogs]( Last week I showed you how to use WorkloadTools to analyze a workload. As you have seen, using SqlWorkload to...[More »]( ---------------------------------------------------------------  [] From the SQLServerCentral Blogs - [Querying temp tables across a linked server.]( Kenneth Fisher from [SQLServerCentral Blogs]( And if you are still reading you probably fit into one of the following categories. Not a DBAA relatively new DBALike...[More »]( Question of the Day Today's Question (by Steve Jones): I have this string in R: > phone <- "(555) 867-5309" I want to extract out the phone number without the area code. In the US, the first three digits are the area code and the last seven are the main phone number. Which of these does this in R? 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: R Language. 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 Steve Jones): I have a SQL Server 2017 on Linux instance. The physical machine has 100GB of RAM. I want to set SQL Server to use 64GB of RAM. How do I do this? Answer: Run mssql-conf and use the set memory.memorylimitmb parameter Explanation: mssql-conf is the utility to configure your instance on Linux, and this inlcudes the memory allocated to the SQL Server instance. Use the set memory.memorylimitmb parameter. Ref: Set the memory limit - [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]( [patching automation]( - i have 20 servers in my environment , need to do automation for sql patching some are cluster and some are... [Migrating replication to a newer server]( - Hello Team, I am in the process of migrating transactional replication between 2 databases on the same server to a newer... [014 insufficient permission]( - We have setup alert 014 (SQL Server event alert, severity 14 insufficient permission) . Sometimes when we got an alert with no client... [PBM: script warning]( - Hello community, I want to use some policies on my sql servers. I have created them and everything works fine except... --------------------------------------------------------------- [SQL Server 2017]( : [SQL Server 2017 - Development]( [Creating a non-unique index]( - If you don't specify Unique, then by default a non-unique index is created. But suppose I wanted to explicitly create... --------------------------------------------------------------- [SQL Server 2016]( : [SQL Server 2016 - Administration]( [SSRS Scale out deployment, force different server for some reports]( - Hello, I have a large set of reports on our server. One set of reports is required to update every 30... [PREEMPTIVE_OS_PIPEOPS Wait]( - So to start with, man, I sure have a lot of weird issues. I appreciate all the help and direction... [Monitoring Resource Governor checking if your pools are not max out on CPU]( - Once you set up your Resource Governor, and have configured a few pools/workload etcs, and one of the Pools are... --------------------------------------------------------------- [SQL Server 2016]( : [SQL Server 2016 - Development and T-SQL]( [More efficient delete sql]( - Hi, thanks for your help in advance. Is there a way to make this query faster DELETE FROM dbo.polygon dest WHERE NOT... [Help needed in a query]( - Hello All, I need help in getting the info like  Name  User ID How many days until account expires Account is not set to never... --------------------------------------------------------------- [SQL Server 2014]( : [Administration - SQL Server 2014]( [Limit Size of Tables]( - I'm looking for a way to put a cap on the size of newly created tables or adding data to... [Database Corruption]( - Got the below error on our database on day 1 Msg 8992, Level 16, State 1, Line 1 Check Catalog Msg 3851,... --------------------------------------------------------------- [SQL Server 2014]( : [Development - SQL Server 2014]( [CTE Group By not grouping results correctly]( - I have the following CTE that is doing a SUM on the field MERCHANDISE_AMT, seperately from 2 different queries and... [Insert to Clustered Index]( - Hello, I have a stored procedure that consists of a relatively simple INSERT INTO SELECT, the table being inserted into... --------------------------------------------------------------- [SQL Server 2012]( : [SQL Server 2012 - T-SQL]( [deleting duplicates, even though different key values]( - Is there a way of deleting duplicates, even though different key values? e.g.: 123 Mary Kay 124 Mary Kay 125 Bob Incus 126 Bob... [need help with writing query to retrieve info stored in multiple columns]( - I need help with creating query to retrieve info stored in multiple columns. Below you can find sample table/info with... --------------------------------------------------------------- [SQL Server 2008]( : [SQL Server 2008 - General]( [Permissions granted to Public - anything I might need to know?]( - I have two SQL 2008 R2 servers that have two databases each.  I have the exact same stored procedure in... [sql Database (MDF) repair Best Tools]( - hi MDF file corrupted Best Repair Tools or Software ? What is your suggestion [Query to see what components or features are installed]( - I've been trying to find a simple way to query to see what components and features are installed on my... --------------------------------------------------------------- [SQL Server 2008]( : [SQL Server 2008 Administration]( [Integration Services]( - I install SQL 2008 R2 on a server. Integration Services works just fine on server. If I try to connect... 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