Technical Article

Social Networking in the SQL Server Community

Like many SQL Server (and other technology) people, I utilize several social networking vehicles to stay in touch with others in the SQL community. Some of those who don’t use Facebook and Twitter (among others) have expressed skepticism of the real value of social networking. Does it work? Does it provide any value beyond entertainment? Can it actually help your career? I believe the answer to all of these queries is Yes.

Technical Article

Statistics Used by the Query Optimizer in Microsoft SQL Server 2008

Microsoft SQL Server 2008 collects statistical information about indexes and column data stored in the database. These statistics are used by the SQL Server query optimizer to choose the most efficient plan for retrieving or updating data. This paper describes what data is collected, where it is stored, and which commands create, update, and delete statistics. By default, SQL Server 2008 also creates and updates statistics automatically, when such an operation is considered to be useful. This paper also outlines how these defaults can be changed on different levels (column, table, and database).

Blogs

Why Database AI Agents need Layers?

By

Third part in my Ai series with databases. When building AI solutions within the...

Un-Migrating From the Cloud: T-SQL Tuesday #199

By

This month we have a very interesting invitation from Koen Verbeeck. He has hosted...

T-SQL Tuesday #199: Back to the on-prem

By

It’s the second tuesday of the month, which means T-SQL Tuesday time! This month’s...

Read the latest Blogs

Forums

BCA KCP Ancol | Tlp/Wa:0817866887

By Layanan 24jam

Tlp/Wa_Cs:0817-866-887. Blok A VI No, Jl. Parang Tritis Raya 3B-3C, RT.8/RW.11, Ancol, Kec. Pademangan,...

How Do the Experts Become Experts?

By Kathi Kellenberger

Comments posted to this topic are about the item How Do the Experts Become...

Stairway to Reliable Database Deployments Level 4 – Preparing for Production Deployment

By Massimo Preitano

Comments posted to this topic are about the item Stairway to Reliable Database Deployments...

Visit the forum

Question of the Day

Secure Communications

As of June 2026, what is the best version of TLS to use with SQL Server?

See possible answers