Trigger Trivia Posted on SSC
A short article but interesting I think, with some good comments already. I think in general triggers are under used,...
2007-11-13
583 reads
A short article but interesting I think, with some good comments already. I think in general triggers are under used,...
2007-11-13
583 reads
We were lucky enough to have Joe come to Orlando to speak at SQLSaturday and we also talked him into...
2007-11-12
805 reads
One of the things I discuss in my Successful Technical Speaking class (it's a
free class, usually once a quarter)...
2007-11-12
611 reads
I'm just finishing up sending out thank you emails to the volunteers, speakers, and sponsors that helped make our first...
2007-11-12
611 reads
We (End to End Training) will be hosting our Celko on SQL seminar tomorrow (Nov 9th). It's not too late...
2007-11-07
687 reads
I happened to get an email asking me to vote for a product that was being featured in one of...
2007-11-07
658 reads
Replication usually involves data, but it can also include stored procedures as well. SQL Server expert trainer Andy Warren brings us a look at how you can ensure that your stored procedures move as well.
2007-11-05
7,656 reads
Most people 'set it and forget it' when it comes to replication, not realizing that changes to rows on the...
2007-11-05
410 reads
I was just reading the October 2007 issue and they have done what magazines are apt to do; redesign themselves...
2007-11-05
603 reads
Steve is the guy who wrote Code Complete (get rev 2 if you buy) which I consider to be required...
2007-11-05
478 reads
By Vinay Thakur
RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector...
By Vinay Thakur
Continuing from Day 6 we learned Embeddings, Semantic Search and Checks, on Day 7...
By Vinay Thakur
Continuing from Day 5 where we covered notebooks, HuggingFace and fine tuning AI now...
Comments posted to this topic are about the item Not Just an Upgrade
Comments posted to this topic are about the item Restoring On Top I
Comments posted to this topic are about the item Designing Delta Tables with Liquid...
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