Find SQL Server Queries with Index Hints, Power BI CONCATENATE Function, T-SQL Tricks and Improve Data Quality (MSSQLTips 11/3/2021)

[View MSSQLTips newsletter online]( [mssqltips logo]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [sponsor message]( [Convince Me – Persuasion Techniques That Get Things Done]( [Find Queries with Index Hints in SQL Server]( [Find Queries with Index Hints in SQL Server]( In this article we look at a script you can use to find all index hints that are being used from the SQL Server cache and from stored procedure code.... [Power BI CONCATENATE Function: How and When to Use it]( [Power BI CONCATENATE Function: How and When to Use it]( In this article we cover various ways join and concatenate data in Power BI by using the DAX CONCATENATE function.... [Learn Techniques to Influence IT Professionals]( [Learn Techniques to Influence IT Professionals]( Ever wanted to convince your boss to try something new, but didn't know where to start? Kevin Kline teaches the eight techniques of influencing IT professionals, so you can innovate and achieve change in your organization.... [Using MERGE in SQL Server to insert, update and delete at the same time]( [Using MERGE in SQL Server to insert, update and delete at the same time]( In this tip we look at an example to help you better understand how the SQL Server MERGE statement works.... [Find, Analyze and Optimize SQL Server Performance]( [Find, Analyze and Optimize SQL Server Performance]( As a SQL Server Professional, application performance is one of my top priorities. I know our applications have numerous inefficiencies and we are constantly firefighting to keep our internal and external users productive. Our team collects data al... [SQL Server CROSS APPLY and OUTER APPLY]( [SQL Server CROSS APPLY and OUTER APPLY]( SQL Server introduced the APPLY operator, which is like a join clause and it allows joining between two table expressions i.e. joining a left/outer table expression with a right/inner table expression. The difference between the join and APPLY operat... [Cloud Migration Guide: SQL Server to AWS]( [Cloud Migration Guide: SQL Server to AWS]( Given the increased cadence of SQL Server releases, many of the migration activities detailed in this guide also apply when performing SQL Server upgrades on-premises if you are not yet ready for full cloud adoption. This guide will provide a detaile... [SQL Server Cursor Example]( [SQL Server Cursor Example]( A SQL Server cursor is a set of T-SQL logic to loop over a predetermined number of rows one at a time. The purpose for the cursor may be to update one row at a time or perform an administrative process such as SQL Server database backups in a sequent... [Improve Data Quality for SQL Server Reporting]( [Improve Data Quality for SQL Server Reporting]( Recently, we uncovered the root cause of our reporting issues: poor data quality for portions of our data. Some data is out of date, while other data is not formatted consistently based on numerous source systems, particular data does not properly m... [By Greg Robidoux -]( [SQL Server Clustered Tables vs Heap Tables]( One very important design aspect when creating a new table is the decision to create or not create a clustered index. We will take a look at a few points to help with the decision.... [By Jignesh Raiyani -]( [SQL Server Performance of SELECT INTO vs INSERT INTO for temporary tables]( SQL Server provides SELECT INTO and INSERT INTO for inserting data into temporary tables. In this tip we look at which performs better.... [By Aaron Nelson -]( [PowerShell Commands for SQL Server Reporting Services]( In this tip we look at PowerShell commands you can use to manage SQL Server Reporting Services.... [Twitter]( [spacer] [Facebook]( [spacer] [LinkedIn]( [spacer] Edgewood Solutions LLC | PO Box 682, Wilton, NH 03086 [Unsubscribe {EMAIL}]( [Update Profile]( | [Our Privacy Policy]( | [Constant Contact Data Notice]( Sent by newsletter@mssqltips.com