The Reading Poll
This week Steve Jones asks about how important reading is to you, and also about what our digital rights might be in a world where we have connected platforms.
T-SQL Best Practices
This article, the first in a series, discusses T-SQL coding best practices. Join Greg Larsen as he explains how to write queries to optimize SQL Server resources and improve performance.
Estimating Priorities
Steve Jones is more willing to ask for changes in software than the real world. Is that a good thing or not? Read on to find out.
Foreign Keys, Part 2 - SQL School Video
Continuing with his videos on Foreign Keys, MVP Andy Warren shows us how to set constraints between two tables.
Cannot generate SSPI context…
Out of all the problems you can have with SQL Server troubleshooting connectivity issues can be the most challenging. When you factor in the complexities of Active Directory and SQL Server’s interaction with it fixing SSPI errors can be down right baffling...
Checksum Problems, Choosing the Correct Recovery Model and More
Paul S. Randal answers your SQL questions: How can I tell when there’s a checksum problem without waiting until the monthly maintenance plan? Is it true that using a GUID as the clustered index key can lead to performance issues with indexes? How can I choose the correct recovery model? And more!
Creating a table with horizontal partitioning in SQL Server
During the planning phase I found out about the new partitioning feature in SQL Server 2005 and later editions of SQL Server. It is a vast topic with several associated operations and configurations involved. In this tip I will share what I learned about partitioning, show an example to implement horizontal table partitioning along with a comprehensive list of related benefits and considerations.
Estimating Priorities
Steve Jones is more willing to ask for changes in software than the real world. Is that a good thing or not? Read on to find out.
Estimating Priorities
Steve Jones is more willing to ask for changes in software than the real world. Is that a good thing or not? Read on to find out.
Estimating Priorities
Steve Jones is more willing to ask for changes in software than the real world. Is that a good thing or not? Read on to find out.
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
BCA KCP Duri Raya Telp/WA.0821°3111°179
Telp/WA.0821°3111°179 Jl. Duri Utara No.37 B, Duri Sel., Kec. Tambora, Kota Jakarta Barat, Daerah...
BCA KCU WAHID HASYIM Telpon/wa.085373737699
BCA KCU WAHID HASYIM Telpon/wa.085373737699.Jl. K.H. Wahid Hasyim No.183 A-B, Kb. Kacang, Kecamatan Tanah...
BCA KCP Katamso Medan CSTelpon : 0853-73737551
CSTelpon : 0853-73737551 Jl. Brigjend Katamso No.56 B-C, A U R, Kec. Medan Maimun,...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers