New SQL Standard Article
A new article for the SQL Standard is now available. You can find the article here. The article is by...
2010-05-20
605 reads
A new article for the SQL Standard is now available. You can find the article here. The article is by...
2010-05-20
605 reads
The last post in the series on finding the sizes of your tables showed us how we could find that...
2010-05-19
1,434 reads
On the evening of May 13th, S3OLV held its monthly meeting. We had some really good discussion, and got to...
2010-05-14
692 reads
Once again it looks like I was early for the T-SQL Tuesday event. Last month I submitted my entry on...
2010-05-11
876 reads
It is once again that time of year. It is time to nominate the DBA in your life for the...
2010-05-11
927 reads
This is just a quick note to remind any interested parties that the May S3OLV meeting will be held this...
2010-05-11
467 reads
In the first post of this series I highlighted and described two stored procedures that are shipped from Microsoft. These...
2010-05-05
4,693 reads
In SQL Server there are two stored procedures that help one to determine the size of a table. One is...
2010-05-03
870 reads
Finally I am putting down to paper my marathon race list for this season. Some of my favorite races are...
2010-04-30
1,481 reads
For the April T-SQL Tuesday, I blogged about a report to find information on the BLOBs in a database. I...
2010-04-27
1,228 reads
Quite the title, so let me set the stage first. You have an Azure...
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
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