PASS Summit 2013 – Day 3: Query Tuning, Memory Internals, SSIS and PowerShell
This is actually the first formal day of the PASS Summit, but it’s my third day here. I have already...
2013-10-17
390 reads
Guy Glantser
PASS Summit 2013 – Day 2: The PASS Spirit
This is my second day into the PASS Summit 2013, and the excitement is still rising. My first day was...
2013-10-16
391 reads
PASS Summit 2013 – My First Day and Paul White
This is my first time to attend the PASS Summit. I was very excited about it, and I planned to...
2013-10-15
317 reads
How Much Unallocated Space do I Have in My Database Files
In a previous post, I wrote about when and how to shrink your database files. The bottom line was that...
2013-08-13
2,345 reads
My Summary of 24 Hours of PASS
Once a year, just before the annual PASS Summit, there is a promotional event called 24 Hours of PASS. The...
2013-08-05
438 reads
When and How to Shrink Your Database
Most DBAs know that shrinking a database is a bad thing. But in many cases, there is no DBA around,...
2013-08-01
604 reads
Blogs
TempDB Internals – What’s New (SQL Server 2016 to 2022)
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
AI: Blog a Day – Day 2: Generative AI, Multimodal Systems, and Agent AI
By Vinay Thakur
continuing from Day 1 where we covered the history of AI and GPT family,...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
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