Extended Events and Performance Tuning Knowledge
I’m working on updating my book, Query Performance Tuning Distilled, so that it reflects the new things available in SQL...
2011-10-05
1,821 reads
The Scary DBA
Networking
No, I’m not talking about hubs and switches. I’m talking about people. Networking is a major component of an event...
2011-10-03
1,149 reads
SQL In The City: LA
Just a reminder that there are a few seats left for SQL In The City: LA on the 29th of...
2011-09-30
1,520 reads
Book Review: Smarter, Faster, Cheaper
In my continuing quest to not get personal visits from Buck Woody (blog|twitter) I’m making sure that I make good...
2011-09-26
1,475 reads
SQL Server Execution Plans
I writequitefrequently about SQL ServerExecution Plans. I started in that area just because that’s how you figure out what a...
2011-09-22
824 reads
MicroTraining: Performance Tuning Checklist
I’ve been playing a lot with Google+ and the Hangouts there. I love them. I think they’re opening up a...
2011-09-21
1,010 reads
Statistics in Execution Plans
I was presenting on execution plans when another question came up that I didn’t know the answer to immediately. Yes,...
2011-09-20
1,354 reads
St. Louis SQL Server Users Group Feedback
You know I share what feedback I get from conferences. I don’t usually get feedback from users groups (well, I...
2011-09-16
857 reads
Probe Residual on Hash Match
I have to say, I only recently noticed this on a tool tip:
and this in the property sheet:
The bad news...
2011-09-15
1,681 reads
Meme Monday: Favorite PASS Memory
Have to complete my assignment from the Rockstar this month since I’ve missed the last several (he gets all weepy,...
2011-09-06
600 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