Prevent Duplicate Records, Scaling SQL Server, Calculating Work Days, and more

[MSSQLTips.com logo]( [View email in your browser]( TODAY'S NEWSÂ FROM MSSQLTips Learn something new every day! [mssqltips image]( [Prevent Duplicate Records in SQL using a Filtered Index]( In this article, I share how an SQL Server filtered index solved the problem of preventing duplicates for new rows in a table. ... [mssqltips image]( [Loop through a Table without a Cursor]( Comparison of SQL loop through table row options with a SQL Server Cursor versus a While Loop. ... [mssqltips image]( [Performance Testing with SqlQueryStress]( In this webinar, we will look at how to use SqlQueryStress, a free tool that allows SQL developers to mimic multiple users running one or more queries at once to help build better queries.... RECOMMENDED READINGÂ ON MSSQLTips [mssqltips image]( [Calculating Costs for Microsoft SQL Server]( This white paper looks at how costs can be controlled with a sufficient understanding of the Microsoft SQL Server licensing process.... [mssqltips image]( [Exploring Whether Storage is the Root Cause of Your Performance Woes]( Learn how to unravel the many layers of the SQL Server infrastructure stack responsible for performance issues. We'll explore common bottlenecks, actual storage issues, network connectivity, and virtualization nuances. You'll leave with enough knowle... [mssqltips image]( [Secrets to Fast, Easy High Availability for SQL Server in Amazon Web Services]( Learn how to quickly build a two-node HA cluster for SQL Server in the AWS cloud.... ADDITIONAL RESOURCESÂ ON MSSQLTips [mssqltips image]( [SQL Server at Scale - Using an Archive Table, Part 1]( In this series of articles, we look at strategies for archiving data from your production systems and the impact on systems and management of your databases.... [mssqltips image]( [SQL Server at Scale - Using an Archive Table - Part 2]( In this article, we look at strategies for archiving SQL Server data using partitioning and different archive tables.... [mssqltips image]( [Calculating Work Days for Power BI Reports using NETWORKDAYS Function]( In this article, we look at calculating working days for Power BI reports using the new NETWORKDAYS function.... [Manage MSSQLTips Subscriptions | Unsubscribe]( Edgewood Solutions LLCÂ PO Box 682 | Wilton, NH 03086Â [Privacy Statement]( Sent to: {EMAIL}Â [tag]