Database Management Tools, CTEs, Temp Tables, and more (MSSQLTips)

Learn about new SQL Server topics from MSSQLTips.com [MSSQLTips.com logo]( [View email in your browser]( [SQL Server Integration Services Tutorial - Start Learning]( TODAY'S NEWS FROM MSSQLTips Learn something new every day! [mssqltips image]( [Feature Rich Database Management Tool and IDE for 40+ Platforms]( Learn about Aqua Data Studio which is a feature-rich management tool and IDE for over 40 database platforms such as SQL Server, Oracle, MySQL, Snowflake, and many more. ... [Read Now]( [mssqltips image]( [SQL Server CTE vs Temp Table vs Table Variable Performance Test]( In this tip we will go through a few simple SELECT queries in order to compare the performance using each type of object, temp table, table variable and a CTE, to store the temporary data. ... [Read Now]( [mssqltips image]( [Today - Accelerate SQL Server Application Migrations to the Cloud]( AWS Migration Hub Orchestrator enables you to automate and simplify migrating multiple applications to the AWS Cloud. It helps to streamline and simplify the migration process, reducing the time, cost, and risk associated with cloud migrations.... [Read Now]( RECOMMENDED READING ON MSSQLTips [mssqltips image]( [Calculating Costs for Microsoft SQL Server]( This white paper looks at how costs can be controlled with sufficient understanding of the Microsoft SQL Server licensing process.... [Read Now]( [mssqltips image]( [Simple way to Import XML Data into SQL Server with T-SQL]( In this tip we look at a simple way to import a simple XML document into a SQL Server table.... [Read Now]( [mssqltips image]( [SQL Server Monitoring On-premises and Cloud for Management and DBAs]( The use of SQL Server in the cloud continues to grow, but there is still the need to manage on-premises installations. Learn about one tool that can help you manage all of your SQL Server installations whether they are on-premises or in the cloud to ... [Read Now]( ADDITIONAL RESOURCES ON MSSQLTips [mssqltips image]( [SQL Server Stored Procedure Input Parameter, Output Parameter and Return Value]( In this tip we look at how to write SQL Server stored procedures to handle input parameters, output parameters and return codes.... [Read Now]( [mssqltips image]( [Cleanse Your SQL Server Data Warehouse]( Data Quality | SSIS Workflow | Downloadable Solution - How can we clean, validate and enhance our Contact dimension in our SQL Server Data Warehouse without writing code?... [Read Now]( [mssqltips image]( [SSRS IIF, Switch and Choose Functions for Dynamic and Appealing Reports]( Learn how to use IIF, Switch and Choose logical functions in SSRS reports to make your reports more dynamic and more appealing to report users.... [Read Now]( [Manage MSSQLTips Subscriptions | Unsubscribe]( Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL} [tag]