No. Next question.
Although, that answer can be slightly, ever so slightly, nuanced…
Parameter sniffing is a good thing. But, like a...
2015-04-06 (first published: 2015-03-30)
7,273 reads
One of my favorite events of the year is the SQL Saturday in Silicon Valley. They’ve had four of them...
2015-04-03
605 reads
Simple paramaterization occurs when the optimizer determines that a query would benefit from a reusable plan, so it takes the...
2015-04-02 (first published: 2015-03-24)
6,974 reads
Hello all,
It’s been a while since my last update. Sorry. I’ve just been traveling and presenting and working on books...
2015-03-31
1,093 reads
Last year I purchased a Lenovo W530. Nightmares then ensued. Nice laptop if you just want to use it as...
2015-03-25
608 reads
The question came up at SQL Rally, “Can you use Extended Events to monitor for query timeouts?”
My immediate response was...
2015-03-20 (first published: 2015-03-12)
7,642 reads
The PASS SQL Saturday events are meant to be a place to grow the pool of speakers, provide a mechanism...
2015-03-16
836 reads
2015-03-16
171 reads
It’s not a question of scheduling. I just haven’t been to lots of community events in the last several months...
2015-03-13
573 reads
I get around quite a bit.
Next week I’ll be visiting three cities in Germany talking to user groups in Frankfurt,...
2015-03-09
658 reads
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
By Vinay Thakur
continuing from Day 1 where we covered the history of AI and GPT family,...
By Steve Jones
It’s a day off for Redgate today. This is our annual wellbeing day, where...
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...
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