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 mm/dd/yyyy format.) I actually like the third answer the most, because it gives you a chart on all the styles. A pretty helpful shortcut, if you ask me. […]
And I realize I was the one who launched those procedures
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
My brother asked me to come up with some pictures to show her girlfriend the many beautiful places of this world. Being the dedicated overachiever I am, in return I handed over a website. Where should Linke go? is a 3D ‘slideshow’ built on Hakim El’s reveal library. Of course it’s optimized to mobile and […]
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 / […]