SQLSaturday in Orlando
I imagine many of you have seen or attended a Code Camp, a one day free mini conference type event...
2007-07-23
1,500 reads
I imagine many of you have seen or attended a Code Camp, a one day free mini conference type event...
2007-07-23
1,500 reads
This turned out to be a nice event, better venue than last year. Well organized is always appreciated even at...
2007-07-18
1,370 reads
Not a happy story, but if you've got a child I suspect it will be easy to decide to buy...
2007-07-12
1,389 reads
NewID() is commonly used in the order by to return the result set in random fashion. No idea whether its...
2007-07-09
907 reads
Browsing MSDN this morning and saw the note that they now have Wiki support. If done well it could be...
2007-07-09
601 reads
I recently had the chance to look over a friends shoulder at a query that needed some tuning work. In...
2007-07-06
715 reads
I just got my author copies of the Sybex book for exam 70-444 and have to say the book looks...
2007-07-05
733 reads
My friend and former co-worker Chris Rock just posted at article over at SQLTeam.com that has a pretty good walk...
2007-06-27
1,366 reads
I'm at the bookstore today alternating some work with some professional development time and was reading some of Celko's SQL...
2007-06-20
1,414 reads
SSC had a fairly routine article up recently about The GO Command the Semi Colon Terminator which I read, and...
2007-06-18
1,371 reads
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
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