Table Partitioning in SQL Server: A Practical Guide to Managing Very Large Tables (VLDBs)
Introduction When we first start working with SQL Server, most tables are small enough and we do not think much about their size. But over time, a table can collect millions or even billions of rows. For example, an online shopping application may store every order ever placed, a banking system may retain years of […]
SQL DROP COLUMN Without Breaking Code
Adding a column is relatively easy, since the applications can just ignore it in most cases. But taking a column away can be a little bit more work, as you may have to trick the applications into believing the column is still there. I often see systems where deprecated columns have stayed around “forever” — because people are too afraid to remove them, or because they don’t have the access or capability to modify the source code of the affected applications.
My PASS Summit West 2026
In a few days I’ll be heading up I-5 to Seattle for PASS Summit West, November 9–11, and I’m excited for the week ahead! Part of that is for the event itself. PASS Summit West has a new home this year at the Hyatt Regency Seattle, with sessions, meals, the exhibit hall and evening events […]
Packing and Decoding Device Status Codes with LEFT_SHIFT() and RIGHT_SHIFT() in SQL Server
Some systems store several small status values through a single packed integer. For example, a device integration may require tracking operating mode, alert level, and zone information as one status code rather than separate values in different columns. That creates a practical reporting problem. The packed value may be convenient for an integration format, but […]
SQL Server 2016 end of support: how to choose your upgrade path
SQL Server 2016 reached the end of extended support in July 2026, which means it no longer receives regular security updates unless you pay for Extended Security Updates (ESUs).
Importing Excel files into SQL Server, Azure Edition
How to Use Azure Functions to insert Excel Files into an Azure SQL Database.
Planning for Change
Change is inevitable, so Steve says we ought to plan, and prepare, for things to be different in the future.
Migrate a VLDB with SQL Server Log Shipping
You just had a great weekend. You go grab your coffee and before you take a sip a manager grabs you and says, “we need your help.” We need to migrate a very large database to our new data center. We need to keep the data in sync and have a short period of downtime when we cutover.
Blogs
Reading Blogs: T-SQL Tuesday #204
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
Are Blogs Still Relevant? - T-SQL Tuesday #204
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
How I Built RAG for My Accounting App on Bedrock and pgvector
The first version of my accounting assistant could not find a single purchase of...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Alamat Telp BCA KCP Kutoarjo Hub/Wa. 0817-819-444
Jl. Pangeran Diponegoro No.120, RT.002/RW.010, Serdo Barat, Kutoarjo, Kec. Kutoarjo, Kabupaten Purworejo, Jawa Tengah...
Slow - Linked server query
Hi I have this slow query that is pulling data from a linked server....
Question of the Day
Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers