SQL JOIN Performance Issues, Data Warehousing Best Practices, Disaster Recovery Strategies and CREATE TABLE

Learn about new SQL Server topics from MSSQLTips.com [MSSQLTips.com logo]( [View email in your browser]( TODAY'S NEWS FROM MSSQLTips Learn something new every day! [mssqltips image]( [Data Warehousing Best Practices for SQL Server]( In this article, we look at things you should consider when building or enhancing a data warehouse to ensure you follow standards and best practices.... [Read Now]( [mssqltips image]( [Strategies for Disaster Recovery in the Cloud]( This webinar will discuss disaster recovery (DR) challenges in the cloud and explore common misconceptions about cloud resilience and the need for a robust backup and DR strategy for SQL Server.... [Read Now]( [mssqltips image]( [SQL Server Performance Issues using SQL JOIN]( In this article, we look at the performance impact of using temporary tables in SQL JOINs and whether a temporary table or a table variable performs any differently.... [Read Now]( RECOMMENDED READING ON MSSQLTips [mssqltips image]( [Best Practice: Encrypt Every SQL Server Database]( Learn why Becton Dickinson has selected DBDefence to protect their SQL Server data across numerous medical devices in a cost effective manner.... [Read Now]( [mssqltips image]( [Create a Table in Microsoft SQL Server]( Learn how to create a table in SQL Server using T-SQL along with several different examples that build upon each other to create the final table.... [Read Now]( [mssqltips image]( [SQL Server and DB2 Performance Insights]( The DBI Web Performance Suite for SQL Server and DB2 is a database performance collection, analysis and recommendation tool to help you troubleshoot and tune your database systems.... [Read Now]( ADDITIONAL RESOURCES ON MSSQLTips [mssqltips image]( [SQL Date Format Options]( Learn SQL date format options with the SQL CONVERT function when working with date data types in SQL Server.... [Read Now]( [mssqltips image]( [Bringing SQL Server Data Quality Tools to Your Company]( Learn how and why you should be using Melissa's data quality components that fully integrate into SSIS packages to fix data problems and save your company money.... [Read Now]( [mssqltips image]( [Connect to SQL Servers in another Domain]( You may find that you need to connect remotely to a SQL Server using Windows Authentication that is in another domain. In this tip, we walk through the steps on how this can be done.... [Read Now]( [Manage MSSQLTips Subscriptions | Unsubscribe]( Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL} [tag]