Trapping Online Index Operations
Recently I wrote an article about Capturing Online Index Operations. In that article, I discussed a problem that I had...
2015-01-29
1,327 reads
Jason Brimhall
Minor ailments and Healthy SQL
One of the things that DBAs love to do is keep their servers running and healthy. A healthy server, after...
2015-01-13
821 reads
Minor ailments and Healthy SQL
One of the things that DBAs love to do is keep their servers running and healthy. A healthy server, after all, is your ticket to a stress free day...
2015-01-13
1 reads
Effects of Max Mem on Plan Cache
Reading a Microsoft Article (which can be found here) while making sure I understood what can cause a query plan to...
2015-01-07 (first published: 2015-01-05)
7,922 reads
Effects of Max Mem on Plan Cache
Some effects on plan cache and max memory settings
Related Posts:
The Curiously Large CASE Statement March 20, 2019
Maintenance Plan Owner - Back to Basics December 13, 2018
ArithAbort and...
2015-01-05
4 reads
Las Vegas UG This week
What a fun week we have tuned up for the folks in Las Vegas. It is the first full week...
2015-01-05
541 reads
Las Vegas UG This week
What a fun week we have tuned up for the folks in Las Vegas. It is the first full week of January and there is this huge convention going...
2015-01-05
3 reads
Happy Holidays
Quick and simple for today. Happy Holidays to you!
Related Posts:
Always Waiting, Waiting WaitingFinally, it has happened…On the Seventh Day…September 2014...
2014-12-26
642 reads
Happy Holidays
Quick and simple for today. Happy Holidays to you!
Related Posts:
Easy Permissions Audit January 21, 2019
T-SQL Tuesday Participation Over the Years December 19, 2018
Quick Permissions Audit January...
2014-12-26
1 reads
T-SQL Tuesday 61: A Season of Giving
Tis the season for TSQL Tuesday. Not only is it that season again, but it is also the Holiday season. During this season, many people start to think about...
2014-12-09
5 reads
Blogs
Don’t Miss Out – SQL Server 2025 Unleashed Training Starts Next Monday!
Next Monday, Marchg 9, 2026, my one-day live online training SQL Server 2025 Unleashed:...
What is ALM in Fabric?
By HeyMo0sh
As someone who’s worked with data for over 20 years and with many cloud...
The Most Successful Startups in 2025 — And What They Have in Common
By HeyMo0sh
2025 belongs to the AI startups. If you peek into the tech headlines, you’ll...
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