TIL

Today I Learned

A collection of small things I learn on a day-to-day basis using different programming languages. I write these useful techniques and code snippets down to help me understand and remember them.

Table of contents:

• Categories
  • AI
  • Python
  • T-SQL

Categories

AI

• Chain of Thought
• Principles for Crafting Prompts
• Rewriting Questions
• System Messages
• Use Cases for Coding

Python

• The Zen of Python

T-SQL

• Backup and Restore
• Clear Cache
• Database Integrity
• Dependencies
• Detach and Attach
• Error Handling
• Extended Properties
• Hashing
• Index Fragmentation
• Index Usage
• Job Information
• Missing Index
• Reorganize or Rebuild Index
• sp_WhoIsActive
• Update Statistics
• Window Functions