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,241 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
13 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
8 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
187 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
796 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
4 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
11 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
355 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
673 reads
Blogs
AI: Blog a Day – Day 8: RAG – Retrieval Augmented Generation
By Vinay Thakur
RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector...
AI: Blog a Day – Day 7: Vector and Vector Databases
By Vinay Thakur
Continuing from Day 6 we learned Embeddings, Semantic Search and Checks, on Day 7...
AI: Blog a Day – Day 6: Embeddings – How AI Understands
By Vinay Thakur
Continuing from Day 5 where we covered notebooks, HuggingFace and fine tuning AI now...
Forums
Not Just an Upgrade
Comments posted to this topic are about the item Not Just an Upgrade
Restoring On Top I
Comments posted to this topic are about the item Restoring On Top I
Designing Delta Tables with Liquid Clustering: Real-World Patterns for Data Engineers
Comments posted to this topic are about the item Designing Delta Tables with Liquid...
Question of the Day
Restoring On Top I
I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?
USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO USE DNRTest GO CREATE TABLE MyTest(myid INT) GO USE master RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACESee possible answers