Query Optimization, SQL Download Links, CROSS APPLY, OUTER APPLY, and more

[MSSQLTips.com logo]( [View email in your browser]( TODAY'S NEWSÂ FROM MSSQLTips Learn something new every day! [mssqltips image]( [Building an Enterprise Resource Planning (ERP) Database System]( Building a database for a new application is quite an effort. In this article, we look at how you could start building an ERP system database.... [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]( [Deep SQL Query Optimization with SQL Grease]( 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.... RECOMMENDED READINGÂ ON MSSQLTips [mssqltips image]( Storage) [Array Based Snapshots for the SQL Server DBA]( Storage) In this article, you will learn about the different types of snapshots and why every DBA should consider them for their tool arsenal.... [mssqltips image]( [SQL Server Static Data Masking with DataVeil]( Learn how to use production-like data for testing and development, but mask sensitive data quickly and efficiently with DataVeil.... [mssqltips image]( [Webinar: SQL Server Performance Benchmarking and Optimization]( Learn about SQL Server Performance Benchmarking and Optimization on AWS for a successful migration to the cloud.... ADDITIONAL RESOURCESÂ ON MSSQLTips [mssqltips image]( [SQL Server Download Quick Links]( SQL Server download quick links are included in this tip for the SQL Server engine, Express Edition, Service Packs, tools and more. Be sure to bookmark this page to use as a quick and comprehensive reference guide.... [mssqltips image]( [SQL Server CROSS APPLY and OUTER APPLY]( Learn about SQL Server CROSS APPLY and OUTER APPLY and how they differ from regular JOINs and how to use these along with scripts and a video. ... [mssqltips image]( [Getting Started with Power Query M Language in Excel]( This article introduces M language concepts and examples of using M to manipulate data in Excel.... [Manage MSSQLTips Subscriptions | Unsubscribe]( Edgewood Solutions LLCÂ PO Box 682 | Wilton, NH 03086Â [Privacy Statement]( Sent to: {EMAIL}Â [tag]