And I pretend I totally understand the whole query plan
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 still be there.
When the server ran out of both memory and disk space. On both drives.
@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 Noble (@lastashikabi) June 27, 2014
With a promise of another 32 GB of memory for the analytics server just to cancel the project in the last second:
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 / Least / etc. of Sales / New customers / Quotes / etc. for the last… 1 hour / 1 day / 1 week / 4 weeks / […]
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 the solution for us, let me clean my throat and gesture him to take the podium: Click on the windows button, then type in “notepad” in the […]
By definition SQL Server uses the install directory to store its data, unless you’ve taken care of that aspect during installation. The default directory is C:\Program Files\Microsoft SQL Server\MSSQL\MSSQL\DATA Initially, that solution is absolutely fine, until you realize that SQL Server and its rapidly expanding databases are slowly eating up the disk space dedicated for […]