SQL Server Failover Cluster Storage, CTE in SQL Server, Cloud Transformation and SELECT DISTINCT (MSSQLTips 1/25/2023)

[tag] [View MSSQLTips newsletter online]( [mssqltips logo]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [sponsor message]( [Remove Performance Problems]( [Steps to add a new disk to SQL Server failover cluster instance and move a user database to it]( [Steps to add a new disk to SQL Server failover cluster instance and move a user database to it]( In this article, we look at the steps to add another disk to an existing Windows Failover Cluster used for SQL Server and also how to move an existing database to this new disk.... [Understanding Cloud Transformation Roles and Responsibilities]( [Understanding Cloud Transformation Roles and Responsibilities]( This article provides a clear overview of the key cloud roles and responsibilities involved in cloud platform transformation and administration. These roles include leadership, development, and support personas at both cloud and traditional levels that al... [Performance Tuning Like This Won't Get You Candy]( [Performance Tuning Like This Won't Get You Candy]( Taking blindfolded random swings at a problem is not effective. In order to performance tune you need visibility into what queries are casuing problems and why they are causing problems. See how SQLGrease gives you this visibility with a free 30 da...... [Create a Python Wheel File to Package and Distribute Custom Code]( [Create a Python Wheel File to Package and Distribute Custom Code]( In this article we will explore how to create a Python wheel file using Visual Studio Code, load it to a Databricks Cluster Library, and finally call a function within the package in a Databricks Notebook....... [Bringing SQL Server Data Quality Tools to Your Company]( [Bringing SQL Server Data Quality Tools to Your Company]( Learn how and why you should be using Melissa's data quality components that fully integrate into SSIS packages to fix data problems and save your company money....... [SQL SELECT DISTINCT Examples]( [SQL SELECT DISTINCT Examples]( In this article we look at how to retrieve a list of distinct datasets from SQL Server without repeating information using the DISTINCT clause....... [X-Ray Vision into SQL Queries]( [X-Ray Vision into SQL Queries]( Learn how to conduct deep SQL Query optimization with SQL Grease with the Enterprise dashboard, historical data, troubleshooting SQL Server Wait Stats, capturing anomalies and intelligent notifications....... [CTE in SQL Server Examples]( [CTE in SQL Server Examples]( In this article we cover what a Common Table Expression CTE is and how to write a CTE for doing selects, inserts, deletes, updates and more....... [Strategies to Improve SQL Server Storage Performance]( [Strategies to Improve SQL Server Storage Performance]( Learn about important considerations for SQL Server Professionals building and managing large databases - storage, lower life cycle environments, performance, IO, backups, snapshots, DBCCs and more....... [By Nitansh Agarwal - ]( [How to monitor backup and restore progress in SQL Server]( SQL Server backups and restores can take a bit of time to complete. In this article we provide ways to give you an idea how close these operations are to completion.... [By Greg Robidoux - ]( [Crosstab queries using PIVOT in SQL Server]( In this tip we look at how to construct a SQL Server PIVOT query with an example and explanation.... [By Laeeq Hamid - ]( [Create Dynamic SSRS Reports Using a Query as an Input Parameter]( In this tip we look at how to generate a dynamic report for Reporting Services that automatically adjusts the layout based on the query passed to the report.... [Twitter]( [spacer] [Facebook]( [spacer] [LinkedIn]( [spacer] [Manage MSSQLTips Subscriptions | Unsubscribe](. Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL}