And I pretend I totally understand the whole query plan
When the Senior DBA sits by me
Continue Reading→
Category: SQL server
Here you can find a collection of posts related to SQL Server.
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 s
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:
Running sum for last 12 months, SQL style
I'm going to tell you a little secret. Come, sit closer. You know your running chart for every other dashboard, showing the SUM / Average / Top
Can’t save hosts file under Win Server 2008 r2
I'm just saving this for myself for future reference, and sharing the info with you in case you would run into the same issue. Brian Smith here has
SQL Server – move database files
By definition SQL Server uses the install directory to store its data, unless you've taken care of that aspect during installation. The default direc