Exploring the Varbinary Type
A brief look at the Varbinary data type and its uses in SQL Server for beginners.
2013-02-07
12,681 reads
Timothy A Wiseman
- Interests: SQL Server, Python, Go, Mathematics, Legal Issues
Single User Performance of SQLite v. SQL Server
A look at the performance of SQL Server compared to SQLite for single user applications.
2012-07-19
7,068 reads
An Informal Look at Database Performance
A review on the basic steps to correct a poorly performing query
2010-09-08
12,480 reads
Going From Many Schemas To One Schema
A Technique to deal with moving data from multiple schemas into one table
2010-08-09
6,401 reads
Undocumented Extended and Stored Procedures
Some useful undocumented extended and stored procedures in SQL Server 2005
2009-11-20 (first published: 2008-05-09)
33,453 reads
2008-12-02
9,122 reads
2008-09-09
12,788 reads
CTEs in Report Creation
A discussion on using CTEs to speed the development and maintenance of reports and enhance readability.
2008-03-31
6,159 reads
Reading Ad Hoc Text Files with OpenDataSource
Discusses the techniques and reasons to use opendatasource for reading text files in SQL Server 2005.
2007-12-13
10,376 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