Joining on NULLs
Watch this week's video on YouTube
It's important to be aware of columns that allow NULL values since SQL Server may handle NULLs differently than you might expect.
Today I want...
2019-03-26
5 reads
Bert Wagner
4 Reasons To Avoid VARCHAR(8000)
Watch this week’s episode on YouTubeWhen first learning SQL Server, I had the brilliant idea of defining every column on...
2019-04-05 (first published: 2019-03-19)
1,600 reads
4 Reasons To Avoid VARCHAR(8000)
Watch this week's video on YouTube
When first learning SQL Server, I had the brilliant idea of defining every column on my table as VARCHAR(8000). After all, the VARCHAR datatype...
2019-03-19
5 reads
4 Reasons To Avoid VARCHAR(8000)
Watch this week's video on YouTube
When first learning SQL Server, I had the brilliant idea of defining every column on my table as VARCHAR(8000). After all, the VARCHAR datatype...
2019-03-19
8 reads
Gaps and Islands Across Date Ranges
Watch this week’s episode on YouTube.In a traditional gaps and islands problem, the goal is to identify groups of continuous...
2019-03-12
5,384 reads
Gaps and Islands Across Date Ranges
Watch this week's video on YouTube
In a traditional gaps and islands problem, the goal is to identify groups of continuous data sequences (islands) and groups of data where the...
2019-03-12
24 reads
Gaps and Islands Across Date Ranges
Watch this week's video on YouTube
In a traditional gaps and islands problem, the goal is to identify groups of continuous data sequences (islands) and groups of data where the...
2019-03-12
2 reads
Dipping into the Cookie Jar
This post is a response to this month’s T-SQL Tuesday #112 prompt by Shane O’Neill. T-SQL Tuesday is a way for the SQL...
2019-03-29 (first published: 2019-03-12)
287 reads
Dipping into the Cookie Jar
This post is a response to this month's T-SQL Tuesday #112 prompt by Shane O'Neill. T-SQL Tuesday is a way for the SQL Server community to share ideas about different database and...
2019-03-12
3 reads
Dipping into the Cookie Jar
This post is a response to this month's T-SQL Tuesday #112 prompt by Shane O'Neill. T-SQL Tuesday is a way for the SQL Server community to share ideas about different database and...
2019-03-12
2 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