Local Temporary Tables and Table Variables
Peter He examines the differences between temporary tables and table variables in SQL Server, showing when you might want to choose one over the other.
The Price of SQL Server
SQL Server is an expensive product to license. Or is it? Steve Jones asks today if you feel it's expensive, and what price might you want to pay.
Database Indexing Development Lifecycle...Say What?
Creating good indexes on your database doesn't happen by mistake--you need to have a plan. Greg Larsen shows you how, beginning with a discussion on the indexing development lifecycle.
House of Commons Justice Committee Related to The European Union's Data Protection-Retention Directives
Just this past week on Tuesday afternoon, U.K. Information Commissioner Christopher Graham spoke in the Wilson Room for the House...
A Genetic Algorithm Sample in T-SQL
Bill Talada brings us an interesting use of T-SQL. Imagine you have a robot moving around a grid and it needs to complete various actions. How do you find the smart robots across many generations?
Dodge, Dip, Dive, Duck, and Dodge
Laptop issues have Steve Jones upset with Toshiba. Today he talks about the obligations companies have to stand behind their support agreements and not try to dodge them.
Dodge, Dip, Dive, Duck, and Dodge
Laptop issues have Steve Jones upset with Toshiba. Today he talks about the obligations companies have to stand behind their support agreements and not try to dodge them.
Dodge, Dip, Dive, Duck, and Dodge
Laptop issues have Steve Jones upset with Toshiba. Today he talks about the obligations companies have to stand behind their support agreements and not try to dodge them.
Dodge, Dip, Dive, Duck, and Dodge
Laptop issues have Steve Jones upset with Toshiba. Today he talks about the obligations companies have to stand behind their support agreements and not try to dodge them.
Blogs
VPN + SQL Server Connections: Why Long-Working Setups Suddenly Fail with Msg 10054 and “Connection Broken”
By Tim Radney
Over the past few weeks, I’ve been contacted by multiple customers experiencing the same...
Future IT Roles – Agentic Architect and AI Boom!!
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
Free Webinar about Columnstore Indexes
I’m doing a small series on indexing basics for SQL Server, and on May...
Forums
There's Too Much to Learn
Comments posted to this topic are about the item There's Too Much to Learn
How to Calculate Distance Between Coordinates in SQL Server
Comments posted to this topic are about the item How to Calculate Distance Between...
SSoL Support on the OS
Comments posted to this topic are about the item SSoL Support on the OS
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers