/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

www.lucasnotes.com
| | blog.sqlterritory.com

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.
3.0 parsecs

Travel
| |
| | chrisjohnson120.com

This is a little quirk of SQL Server that I ran into a while ago. We've probably all seen or used an INSERT... INTO script before, but just in case: An INSERT... INTO script typically looks something like SELECT * INTO #Test1 FROM dbo.Test1; And it will create a new table (#Test1) from the data...
2.4 parsecs

Travel
| |
| | nocolumnname.blog

Time to read: ~ 6 minutes Words: 1151 Update: Thanks to "kuopaz", for pointing out that I had forgotten to add the unnamed constraint to the example where I say unnamed constraints will work fine. Introduction: Kenneth Fisher (b | t) recently wrote about Re-Evaluating Best Practicesand, reading his post, I couldn't help but agree...
6.5 parsecs

Travel
| |
| | ezyang.github.io

Model Context Protocol servers provide a standard interface for LLMs to interact with their environment. Cursor Agent mode and Claude Code use agents extensively. For example, instead of needing a separate RAG system (e.g., as previously provided by Cursor) to find and feed the model relevant context files, the LLM can instead call an MCP which will let it lookup what files it wants to look at before deciding what to do. Similarly, a model can run tests or build and then immediately work on fixing problems when this occurs. It is clear that Anthropic's built-in MCP servers are useful, and you should use agent mode when you can.
20.8 parsecs

Travel
|