Parameter Sniffing, Rounding Numbers, Timeseries Data and TDE with HA

Learn about new SQL Server topics from MSSQLTips.com [MSSQLTips.com logo]( [View email in your browser]( [Unclog Performance Issues with SQLGrease]( [Unclog Performance Issues with SQLGrease]( TODAY'S NEWS FROM MSSQLTips Learn something new every day! [mssqltips image]( [Rounding Numbers to the Nearest Integer with T-SQL]( In this article, we look at how to use T-SQL to round to the nearest integer using round, ceiling, floor, and the banker's rounding rule.... [Read Now]( [mssqltips image]( [Sometimes things go sideways]( Finding a root blocker isn’t always easy, much less finding the cause of the blocking. SQLGrease can quickly spot the root blocker and provide the details of what the root blocker was doing, even if it happened in the past.... [Read Now]( [mssqltips image]( [Parameter Sniffing Issue with Temporary Tables in SQL Server 2022]( In this article, we look at how parameter sniffing can still be an issue in SQL Server 2022 when using temporary tables and one way to resolve the issue.... [Read Now]( RECOMMENDED READING ON MSSQLTips [mssqltips image]( [SQL Server Performance Microscope]( 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.... [Read Now]( [mssqltips image]( [Visualize Timeseries Data with Python]( Learn how to use the Plotly library to visualize time series data in Python in this step-by-step article.... [Read Now]( [mssqltips image]( [Controlling Cloud Costs without Sacrificing Availability or Performance]( The objective of this white paper is to help prevent cloud services sticker shock from occurring. ... [Read Now]( ADDITIONAL RESOURCES ON MSSQLTips [mssqltips image]( [Setup SQL Server Transparent Data Encryption with HA]( In this article, we look at how to enable TDE for databases that are already part of a SQL Server AlwaysOn Availability Group.... [Read Now]( [mssqltips image]( [Improve Data Quality for SQL Server Reporting]( Poor data quality for any reason is very expensive in terms of man hours and decision making to all organizations. There are a number of ways to address the issue with both SQL Server Reporting Services and Power BI. Learn about Melissa's solution t... [Read Now]( [mssqltips image]( [Power BI Dynamic X and Y Axis]( In this step-by-step article, learn how to dynamically select what displays on the X or Y axis of a Power BI chart.... [Read Now]( [Manage MSSQLTips Subscriptions | Unsubscribe]( Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL} [tag]