DDL Triggers, SQL Subqueries, Date and Time Conversions Plus T-SQL Tips (MSSQLTips 3/22/2023)

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]( [Use DDL Triggers to Automatically Keep SQL Server Views in Sync]( Learn how to use a SQL Server DDL trigger to automatically refresh SQL Server views when underlying tables are modified.... [Read Now]( [mssqltips image]( [Three Use Case Examples for SQL Subqueries]( In this article, we look at different ways of using subqueries in SQL Server with several examples using financial stock data.... [Read Now]( [mssqltips image]( [Sometimes things go sideways]( Finding a root blocker isn’t always easy, much less finding the cause of the blocking. Slgrease 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]( RECOMMENDED READING ON MSSQLTips [mssqltips image]( [Optimize your costs with Azure SQL Managed Instance]( Migrating your SQL Server data to the cloud can yield immediate cost savings beyond shifting IT budget from a capital expense to an operational expense. You can continue to optimize your costs in the cloud to significantly impact your total cost of o... [Read Now]( [mssqltips image]( [Date and Time Conversions Using SQL Server]( In this article we look at several different date and time formats you can use in SQL Server.... [Read Now]( [mssqltips image]( [Find Your 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]( ADDITIONAL RESOURCES ON MSSQLTips [mssqltips image]( [SQL Server CROSS APPLY and OUTER APPLY]( SQL Server introduced the APPLY operator, which is like a join clause and it allows joining between two table expressions i.e. joining a left/outer table expression with a right/inner table expression. The difference between the join and APPLY operat... [Read Now]( [mssqltips image]( [Share Your Opinions on SQL Server Data Quality]( [Survey] With the proliferation of data across the globe, data quality, accuracy and management present significant challenges for data professionals in the SQL Server community. Share your experiences.... [Read Now]( [mssqltips image]( [SQL NOT IN Operator]( This tip will cover the SQL NOT IN operator and explain the functionality and use cases with several NOT IN examples. ... [Read Now]( [Manage MSSQLTips Subscriptions | Unsubscribe]( Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL} [tag]