Execution Plans, Performance Tuning and Rum
This is me on the last cruise
In just a few more weeks I’ll be setting sail on the first of...
2015-01-06
1,082 reads
Grant Fritchey
- Twitter: @https://twitter.com/gfritchey
- Website: https://scarydba.com
- LinkedIn: https://www.linkedin.com/in/grant-fritchey/
- Bluesky: https://bsky.app/profile/gfritchey.bsky.social
Speaker of the Month: January 2015
I love it that my first post of the new year is going to be Speaker of the Month. I’m...
2015-01-02
422 reads
“Pretty Plans vs. Performance” or “Grant Gets Pwned”
If you get an execution plan that looks like this:
I wouldn’t blame you for immediately thinking about query tuning. Especially...
2014-12-29 (first published: 2014-12-19)
6,158 reads
Speaker of the Month: December 2014
For the month of November I was at the PASS Summit and Live360, so I didn’t get to find new...
2014-12-08
551 reads
Speaker of the Month: November 2014
I have been very remiss in my blogging of late. Apologies.
One thing I haven’t blogged about is Speaker of...
2014-12-05
505 reads
PASS Summit 2014 Speaker Idol
For the first time ever at the PASS Summit, a competition was held to select a speaker for the 2015...
2014-11-13
779 reads
I’m Still Not on the Board
I’m just back from the PASS Summit 2014. What a great event. But this year, it was a little different....
2014-11-11
692 reads
PASS Summit 2014: WIT Luncheon
Since I’m starting on the board in January, I’ve stopped taking part in the bloggers table during keynotes. First time...
2014-11-06
621 reads
Database Lifecycle Management
There are lots of people who talk about Application Lifecycle Management. But, the database is a major part of every...
2014-10-31 (first published: 2014-10-20)
6,978 reads
Navel Gazing
I love negative feedback. Well, not really. I love constructive feedback. I love the feedback that gives me things to...
2014-10-17 (first published: 2014-10-12)
6,595 reads
Blogs
Building the Team: Roles and Responsibilities in FinOps
By HeyMo0sh
In my experience, FinOps success has never been just about tools or dashboards. It...
Tooling for Success: The Best FinOps Tools and Technologies
By HeyMo0sh
As a DevOps person, I know that to make FinOps successful, you need more...
From Planning to Practice: Setting Up Your FinOps Framework
By HeyMo0sh
As someone who works in DevOps, I’m always focused on creating systems that are...
Forums
Restoring On Top II
Comments posted to this topic are about the item Restoring On Top II
SQL Art 2: St Patrick’s Day in SSMS (Shamrock + Pint + Pixel Text)
Comments posted to this topic are about the item SQL Art 2: St Patrick’s...
Breaking Down Your Work
Comments posted to this topic are about the item Breaking Down Your Work
Question of the Day
Restoring On Top II
I have a database, DNRTest, that has a number of tables and other objects in it. The other day, I was trying to mock up a test and ran this code on the same server:
-- run yesterday CREATE DATABASE DNRTest2 GO USE DNRTest2 GO CREATE TABLE NewTable (id INT) GOToday, I realize that I need a copy of DNRTest for another mockup, and I run this:
-- run today USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO RESTORE DATABASE DNRTest2 FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens? See possible answers