Maximale Anzahl Zeilen je Datenseite und minimale Datensatzgröße
(DE)
In einer meiner letzten Master-Classes tauchte die nicht ganz ernste aber dennoch...
2014-10-29
1,439 reads
Well, it is that time of year again. The Professional Associations for SQL Server (PASS) annual summit. This year we...
2014-10-29
1,250 reads
The log file tends to fascinate me. In fact one of my favorite posts is where I looked into the...
2014-10-29
1,811 reads
I am extremely excited to share that the first event of Porto.Data is all set for the 20th of November...
2014-10-29
134 reads
I was working on a demo recently and needed to show that a little monitoring can help you catch schema...
2014-10-29
1,126 reads
In early October my third book was published. I have been blessed to be able to work with Joes2Pros for my...
2014-10-29
1,877 reads
SQLSaturday Tampa is the first SQLSaturday in Florida for 2015, scheduled for February 28th, 2015. The event is held at...
2014-10-29
1,260 reads
I certainly hadn’t planned on creating a part two of my post on clustered index columns but in the comments...
2014-10-29 (first published: 2014-10-20)
6,079 reads
I committed to studying for MCSA SQL Server 2012 and taking the certification exams by the end of the year…last...
2014-10-28
606 reads
This is the last article in a mini-series diving into the existence of ghosts and how to find them within...
2014-10-28
769 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