SQL Server Best Practices for Index Column Order, Money Data Type and Learning Resources (MSSQLTips 08/26/2019)

[tag] [View MSSQLTips newsletter online]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [SQL Server Performance Monitoring and Tuning Tutorial - Improve Performance Now]( [SQL Server Best Practices for Index Column Order, Money Data Type and DBA Learning Resources]( In this tip we look at some additional best practices questions for SQL Server such as using the money data type, column order of indexes and more.... [Solve SQL Server Data Challenges]( [Webcast] There is no debate – duplicate data is unwanted data. But, issues behind duplicate data detection persist, such as sound-alike matches, misspellings, abbreviations, nicknames and other variants of fuzzy matching records. So how do you overc... [SQL Server Indexing Tutorial]( Although there are many different things that can be done to improve the performance of a database system, creating indexes is the main tool in every DBAs toolbox that is used when we are trying to improve the performance of a query. This tutorial co... [Do you need a faster SQL Server Cluster?]( Making SQL Server deployments resilient to failures is a goal most want to achieve. Whether you are trying to account for high availability and/or disaster recovery, there are various methods to achieve the end goal. One of the most popular approache... MSSQLTips Week In Review [Azure Data Factory Control Flow Activities Overview]( In this article we look at the different types of control flow activities that are available in Azure Data Factory as well as look at how to use the Execute Pipeline activity.... [Disk Latency for SQL Server Database and Transaction Log Files]( In this tip we look at a simple stored procedure you can create to determine which data or log files on your SQL Server instance are experiencing latency issues.... [How to Stop a SSIS Package Execution from Code]( In this tip we look at a way to stop the execution of a SSIS data flow task that is running by executing an outside process to stop the data flow immediately.... [Shortcut to Show and Hide SSMS Results Pane]( In this tip we look at how to quickly hide and show the SQL Server Management Studio SSMS results pane.... [SQL Server Permissions List for Read and Write Access for all Databases]( In this tip we look a script to find SQL Server logins and database users that have read or write access to any database in the instance.... [SQL Server Stored Procedure Input Parameter, Output Parameter and Return Value]( In this tip we look at how to write SQL Server stored procedures to handle input parameters, output parameters and return codes.... [Twitter]( [Facebook]( [LinkedIn]( You are receiving this as a subscriber of MSSQLTips.com. If you wish to discontinue receiving email, please send us an email to [unsubscribe](mailto:unsubscribe@mssqltips.com?subject=UNSUBSCRIBE). Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL}