Missing Indexes, Archiving Data, Replication Issues and more

[MSSQLTips.com logo]( [View email in your browser]( TODAY'S NEWSÂ FROM MSSQLTips Learn something new every day! [mssqltips image]( [Raising the Cost Threshold for Parallelism (CTFP) Affects SQL Server Missing Indexes]( This article explores how raising the Cost Threshold for Parallelism (CTFP) affects missing index recommendations in SQL Server along with examples you can follow. ... [mssqltips image]( [From hiccups to nausea SQLGrease can help]( SQLGrease collects query level performance statistics to determine the root cause of performance issues, and in some cases provides recommendations on fixing them. Try SQLGrease free for 30 days.... [mssqltips image]( [Compare SQL Server XACT_STATE vs @@TRANCOUNT Functions]( This article will compare the SQL Server XACT_STATE and @@TRANCOUNT functions and illustrate the differences with examples. The goal is to reduce the confusion between these two functions, allowing for the correct function to be applied to particular... RECOMMENDED READINGÂ ON MSSQLTips [mssqltips image]( [SQL Server Stored Procedures Tutorial]( This tutorial look at how to create stored procedures in SQL Server to be able to reuse the code for various purposes.... [mssqltips image]( [Find SQL Server Query Issues Fast]( 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.... [mssqltips image]( [Amazon RDS Custom for SQL Server]( Learn about scenarios that make Amazon RDS Custom the ideal choice for SQL Server in the AWS Cloud - managed services with application flexibility and granular control to the OS and database.... ADDITIONAL RESOURCESÂ ON MSSQLTips [mssqltips image]( [SQL Server at Scale - Using an Archive Table]( In this article, we look at strategies for archiving SQL Server data using partitioning and different archive tables.... [mssqltips image]( [Enabling Academic Research with Real-World Data Sets]( Learn how Melissa for Education is helping students with research projects, cyber security, GIS data, medical research, datathons and more.... [mssqltips image]( [Correct SQL Server Transactional Replication Issues]( Learn how to address SQL Server transactional replication issues with these easy-to-follow steps using T-SQL and SSMS to troubleshoot and fix issues.... [Manage MSSQLTips Subscriptions | Unsubscribe]( Edgewood Solutions LLCÂ PO Box 682 | Wilton, NH 03086Â [Privacy Statement]( Sent to: {EMAIL}Â [tag]