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 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,...
By Steve Jones
It’s a day off for Redgate today. This is our annual wellbeing day, where...
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...
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