/explore

Click through on any links that interest you or select the planets on the right to continue exploring the Outer Web.
You are here

 blog.codefarm.me
T-SQL Learning Notes | CODE FARM
| | sqlserverfast.com
Plansplaining, part 11. Merge plans - SQLServerFast
4.6 parsecs away

Travel
| | Welcome to part eleven of the plansplaining series. You will have noticed that this is no longer a monthly series. But when I was asked recently to provide some insight in how a MERGE statement is reflected in an execution plan, I realized that the plansplaining format works fine for this. But first a word...
| | troels.arvin.dk
Comparison of different SQL implementations
4.8 parsecs away

Travel
| | [AI summary] The provided text is a detailed, comprehensive overview of SQL standards, database systems, and their respective features, including information about schemas, tables, views, constraints, and metadata queries. It also touches on differences between SQL dialects (PostgreSQL, MySQL, Oracle, Informix, DB2, MSSQL) in terms of syntax, case sensitivity, and support for SQL standards.
| | www.sqlshack.com
Query optimization techniques in SQL Server: tips and tricks
4.8 parsecs away

Travel
| | In this blog post we will show you step by step some tips and tricks for successful Query optimization techniques in SQL Server.
| | blobeater.blog
SQL Server Bugs & Enhancement Requests | All About Data
27.4 parsecs away

Travel
| T-SQL Tuesday #86: SQL Server Bugs & Enhancement Requests hosted by Brent Ozar. https://www.brentozar.com/archive/2017/01/announcing-t-sql-tuesday-87-sql-server-bugs-enhancement-requests/ I did not want to miss out on this one because I want to mention a connect item that I logged last year which is still active. This is an enhancement request for SQL Server where I got the idea from...