SELECT *

SELECT * feels convenient, but in SQL Server it bloats I/O, burns network bandwidth, blocks covering-index usage, and makes code brittle when schemas change. Specify only the columns you...

2025-10-02

53 reads

Blog Post

SQL Server is Slow, part 3 of 4

In parts 1 and 2 of this series, we’ve gathered info and done the triage just like anyone in almost any industry does At this point you’ve: Defined what...

2025-10-27 (first published: )

1,746 reads

Blog Post

Back in the EU

I flew to Amsterdam last night and hopefully by the time this publishes I’ll be at my hotel, catching up on messages and prepping for another Simple Talk Podcast...

2025-09-29

18 reads

Blogs

Take Time to Gain Perspective

By

Probably the best piece of advice I ever received is to take time to...

The Fringe Festival

By

I was lucky enough to take a vacation a decade ago in Edinburgh with...

Demo for Parameter Sniffing and Memory Grant Feedback

By

Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...

Read the latest Blogs

Forums

Alamat Kantor BCA KCU BOGOR Tlp:08217555651

By layanan_Bca88

WA CS 628217555651 Jl. Ir. H. Juanda No.28, RT.03/RW.02, Paledang, Kecamatan Bogor Tengah, Kota...

Alamat Kantor BCA KCU Sukabumi Tlp:08217555651

By m4rt1n4

WA CS 628217555651 Jl. A. Yani No.33-35, Gunungparang, Kec. Cikole, Kota Sukabumi, Jawa Barat...

Alamat Kantor BCA KCU Karawang Tlp:08217555651

By R4nt4u

WA CS 628217555651 Jl. Interchange Karawang Barat, Purwadana, Karawang, 41361, Purwadana, Telukjambe Timur, Karawang,...

Visit the forum

Question of the Day

The SQL Server MCP Server

How do I get an MCP server for my SQL Server 2025 database from Microsoft?

See possible answers