/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

 chrisjohnson120.com
INSERT INTO with IDENTITY columns | Chris Johnson
| | blog.sqlterritory.com
Foreign Keys and Index Usage Stats - SQLTerritory.com
3.9 parsecs away

Travel
| | In this post, I'm checking if Foreign Key constraints check does updates index usage statistics DMV. I also provide quick demo code I used for my test.
| | nocolumnname.blog
Using Parentheses with Joins - No Column Name
5.2 parsecs away

Travel
| | If this have no name, I'm calling it the Itzik Join
| | datasavvy.me
Databricks Unity Catalog primary key and foreign key constraints are not enforced - Data Savvy
4.5 parsecs away

Travel
| | I've been building lakehouses using Databricks Unity catalog for a couple of clients. Overall, I like the technology, but there are a few things to get used to. This includes the fact that primary key and foreign key constraints are informational only and not enforced. If you come from a relational database background, this unenforced...
| | blobeater.blog
SQL Server Bugs & Enhancement Requests | All About Data
25.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...