Indexes Aren’t Always the Answer
There’s a tendency to think all problems can be solved with an index or two (or partitions, or other performance...
2011-06-20
981 reads
There’s a tendency to think all problems can be solved with an index or two (or partitions, or other performance...
2011-06-20
981 reads
I bought my E6500 almost three years ago, giving away what was a perfectly good Latitude to trade up to...
2011-06-17
560 reads
Today we have a guest editorial from Andy Warren. Are there particular phrases that you use in technology that resonate with you and have particular meanings? Andy shares a few of his favorites.
2011-06-16
152 reads
I took a vacation recently (well, a really long weekend) and as I like to do, visited a few book...
2011-06-16
672 reads
From time to time I get asked about how PASS Board members are compensated, so I thought it would make...
2011-06-15
688 reads
I haven’t tried this, but run across a reference to hashtagart that looks pretty interesting as a way to use...
2011-06-14
631 reads
Note: This is a good, bad, and ugly post. We took some chances, got some things right, got more than...
2011-06-13
989 reads
I finished reading Make the Impossible Possible: One Man”s Crusade to Inspire Others to Dream Bigger and Achieve the Extraordinary...
2011-06-10
791 reads
The school my daughter attends gives each student a workbook type thing at the beginning of each year, and it...
2011-06-09
601 reads
I spend a lot of time just looking at events, watching for new ideas. At our recent SQLRally we had...
2011-06-07
640 reads
By HeyMo0sh
As a DevOps professional, I’ve seen firsthand how cloud costs can quickly spiral out...
By Steve Jones
AI is everywhere. It’s in the news, it’s being added to every product, management...
By Vinay Thakur
RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector...
Hi, ssms is free here. I can think of other reasons to do this...
I've written some documentation on using different Markdown types of files on GitHub. It's...
Comments posted to this topic are about the item Not Just an Upgrade
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