SET IMPLICIT_TRANSACTIONS ON Is One Hell of a Bad Idea
By default, when you run a query in SQL Server, your delete/update/insert (DUI) is finished as soon as your query finishes. That’s because the default behavior of SQL Server is IMPLICIT_TRANSACTIONS OFF – meaning, SQL Server doesn’t hold your queries open waiting for a COMMIT or ROLLBACK.
AI in Industries
It is important to showcase how Artificial Intelligence is being used in various fields and industries with some facts
Changing Data Types on Large Tables: The INT to BIGINT Conundrum
Changing a data type seems like a simple task unless the table is quite large and downtime must be kept to a minimum. Danny Kruge walks you through the process he created to change an INT to a BIGINT in a large table.
Intervals Part 1 - Definitions and Terms
Learn the basic terms and definitions for intervals in SQL Server.
Troublesome Names
Building a name-and-address database sounds a disarmingly simple task, but if your name happens to be D'Arcy Join, then you probably know, from painful experience, that most programmers don't get it right.
Non-Standard Delimiters for Columns and Rows Using SQL Server Bulk Insert
In this tip, Tim Smith looks at how to use bulk insert to load data into SQL Server when the column and row terminators are not what you typically see.
The DBA's Essential Index Monitoring and Maintenance Tasks
Indexes can be the most critical part of any database. they can drastically improve performance or they can ruin it. Wise management is the key to success.
Blogs
How to Find Expensive Queries in Amazon Redshift
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
Designing a Storage Load Test for SQL Server
I’ve been doing storage load tests for SQL Server for a long time, both...
Forums
How Long is a Long I/O?
Comments posted to this topic are about the item How Long is a Long...
T-SQL Trigonometric Functions in SQL Server
Comments posted to this topic are about the item T-SQL Trigonometric Functions in SQL...
Half of All Engineers
Comments posted to this topic are about the item Half of All Engineers
Question of the Day
How Long is a Long I/O?
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers