I will make this short and sweet for you. If there is something you want to do to all tables in your database, there is a command for you. I wil
sp_msforeachtable
Continue Reading→
The thing with cursors
So our aggregated databases have experienced some loading errors lately, and until that gets fixed, I have to collect the data straight from the field
Cast datetime as varchar
I stumbled upon this great Q+A on Stack Overflow when I was looking for options to cast datetime for a report. (The customer didn't like our standard
When a blocked procedure alert comes in
And I realize I was the one who launched those procedures
When the Senior DBA sits by me
And I pretend I totally understand the whole query plan
Fun fact – SQL server truncates
Tl;dr - SQL server 2008R2's results to grid output truncates string values above 43,680. Conclusion: if half of your script is missing, it might st
The morning after SQL server failed three times in one night
Today was the day
When the server ran out of both memory and disk space. On both drives.
When I talk with my ex supervisor about my current supervisor
@annahadnagy It really is the only way to "supervise" you. Give you a hammer and some gaff tape and leave you alone for a few hours. — Jason Nobl
When the leadership team works my hopes up
With a promise of another 32 GB of memory for the analytics server just to cancel the project in the last second: