/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

 sqlservercode.blogspot.com
SQL Server Code,Tips and Tricks, Performance Tuning: Some numbers that you will know by heart if you have been working with SQL Server for a while
| | www.kevinrchant.com
A unique review of SQL Server index types - Kevin Chant
2.8 parsecs away

Travel
| | I want to do a unique review of SQL Server index types in this post. In order to help raise awareness about some of them.
| | blobeater.blog
SQL Server Bugs & Enhancement Requests | All About Data
3.1 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...
| | erikdarling.com
T-SQL Tuesday: The Last Ticket I Closed - Darling Data
2.7 parsecs away

Travel
| | [AI summary] A SQL Server consultant discusses challenges with foreign key constraints and deadlock issues caused by an eager index spool in a merge operation, leading to the decision to disable the foreign key to improve performance.
| | bobrubocki.wordpress.com
T-SQL Tuesday - Fixing Old Problems with Shiny New Toys - Bob Rubocki
24.2 parsecs away

Travel
| I'm happy to submit this post as part of the T-SQL Tuesday series, started byAdam Machanic.I'm particularly happy because my colleague and friend, Matt Gordon, is hosting this month. Thanks, Matt!The Shiny New SQL Server Toy I want to share is temporal tables. Temporal tables are new to SQL Server with the 2016 release, and...