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,292 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,124 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 Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
By Vinay Thakur
continuing from Day 1 where we covered the history of AI and GPT family,...
Comments posted to this topic are about the item A Quick Restore
Comments posted to this topic are about the item Guarding Against SQL Injection at...
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers