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 databases for each report. That is, go in the database, pull the data, load into temp. Go in the next database, pull the data, load into temp. Go in next, […]
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. […]
Today I learned that apparently the best wings in Rochester can be found at *drumroll* the Klassy Cat. This was shocking news to me. Imagine the last place on Earth where you would look for wings, and you have the Klassy Cat. (As the name suggests, people come here for other sort of entertainment.) And […]
And I realize I was the one who launched those procedures
And I pretend I totally understand the whole query plan
I have quite a few friends living in Liberia. They have been posting about Ebola for two months now. Today a patient died in a hospital in Texas and the US is losing their shit. Mind you, in the meantime more than 2K people died in Liberia. Fox News, of course, is creating the hype […]
Meanwhile, at the database department, we’re butchering English like it’s our job: Anna Hadnagy: very replace Anna Hadnagy: much database Anna Hadnagy: so new? Matthew S.: sooo new, wow Matthew S.: very proceed to testing much Anna Hadnagy: rly Anna Hadnagy: wow. Anna Hadnagy: much thanks. Matthew S.: so welcome.
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.
On the 11.08.2014 23:04 Atom wrote: > > So on one side there’s your fleet which is historically tougher than a $2 ribeye. > > On the other side there’s going to be a team of bug-eyed dildo mong ringpieces fighting with only poor English language skills, sharpened garden tools, and weaponised unicorn farts. > […]