Index Column Order – Be Happy! (2020-12-04)

 SQLServerCentral Newsletter for December 4, 2020 Problems displaying this newsletter? [View online](. [SQL Server Central]( Featured Contents - [Index Column Order – Be Happy!](e2%80%93-be-happy) - [Optimize SQL Server estate monitoring with Redgate's SQL Monitor]( - [From the SQL Server Central Blogs - The Future of PASS]( - [From the SQL Server Central Blogs - Book Review: Making Work Visible]( Question of the Day - [Autocorrect for Git]( The Voice of the DBA  Daily Coping Tip Enjoy new music today. Play, sing, dance, or listen. I also have [a thread at SQLServerCentral]( dealing with coping mechanisms and resources. Feel free to participate. For many of you out there working in a new way, I'm including a thought of the day on how to cope in this challenging time from [The Action for Happiness Coping Calendar](. My items will be on [my blog](, feel free to share yours. Your Favorite IDE SSMS is, well, it's what we mostly have from Microsoft. It's been around a long time, but it is getting regularly released. There are [new versions]( about every quarter, and there are bug fixes and minor enhancements. [Azure Data Studio]( appears to be where Microsoft would like most of us to move, but I, and many others, somewhat resist this because it's not quite as full featured as we'd like. Recently I was watching one of Brent Ozar's [Ask Me Anything recordings]( and some people asked about SSMS and other IDEs. I think Brent is mostly an SSMS fan, and deals with issues, but he mentioned some other IDEs, like [DataGrip](. I've never used that one, but I used to use [RapidSQL]( when it was Embarkadero, mostly because I had offline editing. Once Microsoft added that, I didn't see a reason to buy it anymore. At Redgate, we've been asked to produce an IDE, but that's a ton of work for limited commercial appeal. At least, that's been what I think. Today, I'm curious. What's your favorite IDE to work with SQL Server, or maybe the Microsoft data platform? I'd like to know what you use for SQL Server, but I'd also be curious what you use for other code. PoSh, C#, anything else. Are you a Visual Studio person? Do you like VS Code, and if so, is ADS a complement for databases or do you prefer SSMS? Let me know. Maybe you'll convince me to try another editor. Steve Jones - SSC Editor [Join the debate, and respond to today's editorial on the forums](   Featured Contents e2%80%93-be-happy [Index Column Order – Be Happy!](e2%80%93-be-happy) Mike Byrd from SQLServerCentral.com Ever wonder about index column order; this piece should give some insight. [Optimize SQL Server estate monitoring with Redgate's SQL Monitor]( Additional Articles from MSSQLTips.com How can we balance our need to monitor SQL Server performance and operational processes across hundreds of SQL Servers, but also save time by focusing on the highest priority issues? From the SQL Server Central Blogs - [The Future of PASS]( Andy Warren from SQLAndy 2020 has been a tough year for PASS. It’s primary fund raiser – the PASS Summit – was converted to a virtual event that attracted fewer attendees and far... From the SQL Server Central Blogs - [Book Review: Making Work Visible]( Steve Jones - SSC Editor from The Voice of the DBA I was recommended Making Work Visible by a developer at Redgate Software. The book caught my eye as it seeks to ensure you can work more efficiently by watching...   Question of the Day Today's question (by Steve Jones - SSC Editor):  Autocorrect for Git What command will enable autocorrect in the git command line for all repos, with a 2 second delay? Think you know the answer? [Click here]( and find out if you are right.    Yesterday's Question of the Day (by Steve Jones - SSC Editor) Ordering with NULL I have a bit of data: CREATE TABLE BeerCount ( BeerName VARCHAR(20) , BottleCount INT) GO INSERT dbo.BeerCount (BeerName, BottleCount) VALUES ('Becks', 5), ('Fat Tire', 1), ('Mac n Jacks', 2), ('Alaskan Amber', 4), (null, 7), ('Corona', 2), ('Tsing Tao', 4) GO If I run this query, where is the NULL value in the result set? SELECT beername, bottlecount FROM dbo.BeerCount AS bc ORDER BY bc.BeerName desc; Answer: It is the last value returned Explanation: NULL is treated as a lower value than other items, so in this case, it is returned as the last value. Ref: ORDER BY - [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 - Administration [alias SQL multisubnet failover = true]( - Good morning all , I have an always on instance to configure with a listener in mutlisubnet mode on the application side I am unable to add multisubnetfailover = true is it possible to create an sql alias with this parameter DESKTOP-95KKMMH\DISS; multisubnet failover = true thanks [HA Availability Group Listener]( - I was looking for a specific definition for the Active Directory / DNS team as to what I need set up for an HA Group Listener; does it just need to be a DNS name, IP address, and Directory Object in AD? If so, what is the object called, a cluster object? I have the […] SQL Server 2017 - Development [Operand type clash: text is incompatible with datetime2]( - Dear Group: I am not sure what is causing this, and having a terrible time debugging and hoping someone might notice what I am missing. If I take the actual SELECT * FROM OPENQUERY(......) and run it, I have no problem and the data is returned, so there isn't anything wrong with the SELECT statement, […] SQL Server 2016 - Administration [is_merge_published]( - I'm running the following query to get a list of my Merge Publications but I'm getting results of publications I have deleted a long time ago. Thanks in advance, David. SELECT name as merge_published_db FROM sys.databases WHERE is_merge_published = 1 ORDER BY merge_published_db [Performance and usage of system stored procedure sp_columns_100]( - Hello experts, I'm researching different ways to monitor SQL Server CPU usage by query. I know there are many ways to this, but I just noticed this result and want to know if anyone knows what might make this particular code come up at the top of this particular report. It seems like this system […] Administration - SQL Server 2014 [Can I clone a database across servers?]( - Hi all, I have a database that resides on server A and I need to create its clone on server B. I am using DBCC clonedatabase command. I have a linked server from B to A. And I can create an opposite linked server too, from A to B. Is it possible, and if yes, […] [sp_refreshview on indexed views]( - Hi I have to increase the size of a field in a table. I've listed all the views that use this table so I can run sp_refreshview on these. I'm left with a couple of schema bound views that use the underlying table, but not the changed field otherwise it wouldn't have allowed me to […] SQL Server 2019 - Administration [SQL server service account lost permission on directories]( - I last week installed a SQl 2019 instance on a new server, applied the service pack. Everything looks fine. Then this week when I login to that server again I noticed all the services in the configuration manager are down, this include database engine, SSIS, and SQL server agent. I tried to restart the services, […] SQL Server 2019 - Development [Can I download Shapefiles for all countries from somewhere?]( - I'm trying to get my head around the Geography/Geometry methods in SQL Server... are the shapefiles for all the countries downloadable from somewhere? So far I haven't found them. [Random Timeout Error]( - Hi, following a code release we have seen random timeout errors. I'm not sure whats causing the system to slow down to the point that a timeout happens so set a SQL profiler running and found that on 2 traces before the timeout occurs there is a deadlock thing recorded... SET DEADLOCK_PRIORITY -10 Does this […] SQL Azure - Development [What is the best way to create events from table inserts in SQL Server]( - I have a SQL 20XX database in an on-premise data center that has a table, call it acct.trans_history, with about 1 million rows in it generated per day (and truncated at the end of the day). It is a table written by an old accounting application. This is a table that looks like an accounting […] SSRS 2016 [Enabling date Input parameter to allow mmdd input but display as dd/mm/yyyy]( - Hi there I have an SSRS Report with various input parameters Now one of these is a date field which we want to format to mmdd format but as the user tabs out of it, it will then snap back into dd/mm/yyyy format. For example , 1130 would be entered by the user but then […] General [poor performance function]( - Hello friends. This is my table "Cuentas" [IdCuenta] [int] IDENTITY(1,1) NOT NULL, [IdJerarquia] [int] NOT NULL, [Cuenta] [varchar](20) NOT NULL and I use this function CREATE FUNCTION [dbo].[fIdCuentaPadre] (@IdCuenta as integer) RETURNS integer AS BEGIN DECLARE @IdJerarquia INT DECLARE @Cuenta VARCHAR(20) SELECT @IdJerarquia = idjerarquia, @Cuenta=Cuenta FROM cuentas WHERE idCuenta = @idCuenta RETURN (SELECT TOP(1) […] [Costing per database]( - Hi, I am just checking to see if anyone has ever did a costing per database (based on it size). I am trying to figure out what the cost is for a database throughout its lifecycle. I am looking for mow much disk space will each DB use, how much memory does it require, how […] Integration Services [SSIS Startup directory not found]( - This seems to be a common issue throughout my packages. Anywhere I try to access anything in the startup directory. The startup directory is a server URL mapped to Z:\. In this example package. The task that is failing is a script task that verifies the components required are in the startup directory. This is […]   [RSS Feed]([Twitter]( 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. ©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -