Rebuilding Stats: Twice or Not at All Posted on SSC
Rebuilding Stats was published yesterday on SSC, some nice comments posted to it as well. The main point of the...
2008-07-29
1,471 reads
Rebuilding Stats was published yesterday on SSC, some nice comments posted to it as well. The main point of the...
2008-07-29
1,471 reads
Not all of us work at companies big enough to justify the expense/time it takes to implement something like MS...
2008-07-29
1,439 reads
I saw this post from Rick Strahl about IP6 Addresses in Vista breaking some code, and it immediately made sense...
2008-07-28
1,442 reads
It's downright common these days to download programs as ISO images, but XP doesn't have a native viewer for them....
2008-07-27
1,695 reads
Earlier I wrote Blogging Thoughts - Part 1 where I discussed the various approaches I've seen in blogs (blogging when you...
2008-07-24
1,345 reads
For longer than I care to count I've used the Alt-Tab Powertoy from MS to get a nicer view of...
2008-07-23
1,293 reads
One of the things I've been looking at is different blogging styles and trying to figure out which to recommend...
2008-07-22
1,328 reads
Expert SQL Server trainer Andy Warren brings us a new article on a lesser used feature in SQL server 2005: the ability to disable an index.
2008-07-22
11,125 reads
It's been a while since I had anything up on SSC, a combination of Steve being in good shape on...
2008-07-22
488 reads
I think we all struggle to keep up with various credentials needed to live our internet lives (single sign on...
2008-07-21
543 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