Why you should not update Primary Key values
Recently I had the chance to take a look at a problematic query in an application. I caught the query...
2015-11-11
3,360 reads
Si vis pacem, para sql
Sql Hints #1 - Don’t update Primary Key values
Recently I had the chance to take a look at a problematic query in an application. I caught the query...
2015-11-11
110 reads
Advice for MAXDOP setting
This post is for the MAXDOP option – how to set it in a SQL Server instance. The option is discussed much on the forums and there are different recommendations...
2015-10-16
14 reads
Advice for MAXDOP setting
This post is for the MAXDOP option – how to set it in a SQL Server instance. The option is discussed much on the forums and there are different recommendations...
2015-10-16
12 reads
Advice for MAXDOP setting
This post is for the MAXDOP option – how to set it in a SQL Server instance. The option is discussed much...
2015-10-16
191 reads
Advice for MAXDOP setting
This post is for the MAXDOP option - how to set it in a SQL Server instance. The option is discussed much...
2015-10-16
856 reads
A look on the CXPACKET wait type
I was given a task to optimize a black-box application. I wasn’t able to see its code, but the database was open for analysis. I caught the queries from...
2015-09-10
6 reads
A look on the CXPACKET wait type
I was given a task to optimize a black-box application. I wasn’t able to see its code, but the database was open for analysis. I caught the queries from...
2015-09-10
12 reads
A look on the CXPACKET wait type
I was given a task to optimize a black-box application. I wasn’t able to see its code, but the database...
2015-09-10
365 reads
A look on the CXPACKET wait type
I was given a task to optimize a black-box application. I wasn’t able to see its code, but the database...
2015-09-10
692 reads
Blogs
Rambling about Data on Wheels – origins, branding, expansion
By DataOnWheels
I have been asked many times about how the name “Data on Wheels” came...
Think Twice Before Enabling Fabric’s Inbound Network Protection
Fabric inbound network protection involves two tenant-level controls: Private Link and Block Public Internet...
Match the Model to the Task, Not the App: An Orchestrator-Worker Pattern in Python
Most apps that call an LLM send every request to the same model. That...
Forums
ALAMAT KANTOR BCA KCP Santa Telp:083831618008
WhatsApp:0838-3161-8008 Jl. Wolter Monginsidi No.54, RT.2/RW.4, Petogogan, Kec. Kby. Baru, Kota Jakarta Selatan, Daerah...
AI Observability Challenges in FinOps as a DBA
Comments posted to this topic are about the item AI Observability Challenges in FinOps...
Migration Challenge: Excessive FULLSCAN Statistics Update Duration Blocking SQL
Hello everyone , I am planning to migrate a database from SQL Server 2014...
Question of the Day
Finding a Database Master Key
Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?
See possible answers