SQL Server Bootcamp 2026 | Brno | Windows User Group – Czech Republic
September 4th, 2026 — from 09:00 to 18:00 Link: SQL Server Bootcamp 2026 | Brno | Windows User Group – Czech Republic Are you interested in the upcoming innovations within …
Shrink Data Files to Appropriate Target Size
If you need to shrink data files for any reason, despite the potential negative impact on future performance due to file growth and fragmentation, this script can be used to …
SQL Studio Generated by AI (Copilot & Claude)
A lightweight SSMS‑style SQL dashboard built in PowerShell and WPF. It loads multiple SQL files as tabs, executes queries across one or more servers, displays results in an embedded browser, …
Availability Group – How to Reduce False Failovers During Short Infrastructure Outages
To reduce false failovers during short infrastructure outages, it is common to increase: 1. LeaseTimeout — communication timeout between SQL Server Availability Group and WSFC from 20s to 60s SQL: …
Unique Incremental Number for Each Inserted Row without Using an IDENTITY Column
If you need to generate a unique incremental number for each inserted row without using an IDENTITY column, you must protect the MAX() value lookup inside a transaction. This prevents …
Database in SUSPECT State Due to DTC: How to Resolve
DATABASE REPAIR CHECKLIST Step 1 — Find the stuck distributed transaction If you see a GUID → go to Step 2.If you see all zeros → go to Step 3. …
SQL Index Creation Tutorial (Part 3): Composite Index Construction
Example: Estimated Execution Plan: 1. Open the index properties and select the Predicates section: 2. Copy the content: 3. Paste it into a prepared query and clean up the unnecessary …
Optimize Linked Server Performance with MAXDOP Settings
The working solution is to set Openquery:
SQL Index Creation Tutorial (Part 2): Performance and Execution Plans
Data source: Original query Estimated Execution Plan 1 Estimated Subtree Cost: 586.232 → far too high, indicating long execution time and heavy server load. The plan shows: Creating indexes Index …