Internal Process Guides
Microsoft Cloud
Support Calls
Bacas
Generic SQL Queries
- T-SQL Script: Backup with Date-Time Stamp
- T-SQL Script: Check SQL Server Version
- T-SQL Script: Check SQL Server Name
- T-SQL Script: Find Duplicates in a Table
- T-SQL Script: Set a Database Offline
- T-SQL Script: Identify orphaned users in SQL Database
- T-SQL Script: Get the Space used in SQL Database
- T-SQL Script: Fix orphaned users in SQL Database
- T-SQL Script: Create a SQL Server login
- T-SQL Script: Generate sequential numbers (without identity)
- T-SQL Script: Kill all sessions for a database
- T-SQL Script: Rebuild all indexes
- T-SQL Script: Update statistics
- T-SQL Script: Automatic Index Maintenance Script
- T-SQL Script: Generate INSERT statements from existing data
- T-SQL Script: List all foreign keys referencing a table
- T-SQL Script: Check index usage (find unused indexes)