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
Next Monday, March 9, 2026, my one-day live online training SQL Server 2025 Unleashed:...
By HeyMo0sh
As someone who’s worked with data for over 20 years and with many cloud...
By HeyMo0sh
2025 belongs to the AI startups. If you peek into the tech headlines, you’ll...
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