A Minor Rant About Statistics
If you've ever taken a look at the auto generated statistics that SQL builds (typically on non indexed columns when...
2008-03-19
1,336 reads
If you've ever taken a look at the auto generated statistics that SQL builds (typically on non indexed columns when...
2008-03-19
1,336 reads
Had lunch with a friend in the business yesterday that is involved with vulnerability scans for a large company and...
2008-03-18
1,583 reads
Tjay Belt forwarded me the information about the Utah Code Camp this year. Still early in the process, no schedule...
2008-03-18
1,524 reads
Just a reminder that the event is this Saturday. The tentative schedule has been posted and it looks like I'll...
2008-03-17
1,487 reads
I've been emailing back and forth with IndyTechfest organizer John Magnabosco over the past year as we've traded notes about...
2008-03-16
697 reads
Saw a mention of this in the latest MSDN Magazine, you can download Reflector.SQL2005Browser and install it as an add-in for...
2008-03-13
799 reads
Yesterday I posted Building YOUR Brand that described a formula for becoming rich and famous. Well, perhaps richer than you are...
2008-03-12
559 reads
Between teaching classes, attending community events, and participating in the local user group I get to have a lot of...
2008-03-11
676 reads
Just spoke with Brian this morning to get an event update for SQLSaturday #3:
122 attendees registered so far (event is...
2008-03-11
483 reads
Friday I gave another iteration of our free Sucessful Technical Speaking class, upgraded some since the last version, and this was...
2008-03-10
548 reads
By Vinay Thakur
it has been a year since i have not written much on the blog...
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
By DataOnWheels
I have been active in the data community throughout my career. I have met...
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