Blog
Discover our latest posts
T-SQL: Cursors vs. WHILE Loops – When to Use Which?
In the world of T-SQL (Microsoft SQL Server), the unwritten law is: "Think in sets, not in rows." However, there are scenarios where row-...
SQL Plan Advice: Now with a Share Feature
SQL Plan Advice: Now with a Share Feature
We’ve all been there: You’re stuck with a slow SQL query, have the execution plan in front o...
Asynchronous email delivery via Service Broker
Classic scenario: you have a stored procedure that does something (creates an order, registers a user, whatever) and at the end an email needs to go ...
MSSQL Performance Skript
A short script to test the performance of an SQL Server.
/* =========================================================...
Enterprise SQL Server Index Maintenance: Multi-Database Automation with Email Reporting
Modern database environments require sophisticated maintenance strategies that can handle multiple databases efficiently while providing comprehensiv...
SQL Logging
A comprehensive logging solution for SQL Server stored procedures that provides structured logging with different severity levels, automatic calle...
MSSQL Script: Move all LOG files in a DB
-- First, create a temporary table to store the file move operations
CREATE TABLE #LogFileChanges (
DatabaseName sysname,
LogicalFi...
Rename MSSQL schema
Unfortunately, this is not so easy. But there is a way.
First create the new schema:
create schema {newschema};
go
N...