January 1, 2020 at 11:14 pm
Happy New Year to all.
January 1, 2020 at 11:15 pm
Happy New Year to all.
Same back at ya, Lynn.
--Jeff Moden
Change is inevitable... Change for the better is not.
January 2, 2020 at 12:05 pm
Happy New Year
May your late-night emergency call-out bleepers be kind to you this year.
I'm back in the office after the festivities. Nothing seems to have changed, except I think the heating has been off, as it's a bit nippy in here. It's quiet - but that's because there's only a few of us in. Next week things should be back to what passes for normal.
Thomas Rushton
blog: https://thelonedba.wordpress.com
January 2, 2020 at 12:17 pm
Happy New Year all, hope you enjoyed the festivities, and the break (if you got one). I was working most of the days, or otherwise with family, so I can't wait till the weekend! 🙂
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 2, 2020 at 1:25 pm
Grant Fritchey wrote:Happy Yuletide! Merry Christmas! Happy New Year!
Star Wars sucks (not the first two, chronological, films, just all the rest)!
Looking forward to going to see 1917 though.
3 words that nearly destroyed my faith in star wars
"Jar Jar Binks"
I can undarestand it if "JAR" (PK\x03\x04) is a reference to Java Archived/Compressed file 😉
😎
January 6, 2020 at 3:24 pm
Unexpected gifts from nowhere... I now have a second "Ice Breaker/Litmus Test" question for interviews. No need to pile on folks. I'm just a little gob-smacked that someone has been working with SQL for at least 1 year and 7 months (according to their post history), claims to be "newbie", and then doesn't know such a thing and (apparently) made no effort on their own to find out.
https://www.sqlservercentral.com/forums/topic/difference-between-numeric-and-decimal
I guess things like this shouldn't surprise me anymore.
--Jeff Moden
Change is inevitable... Change for the better is not.
January 6, 2020 at 9:35 pm
Unexpected gifts from nowhere... I now have a second "Ice Breaker/Litmus Test" question for interviews. No need to pile on folks. I'm just a little gob-smacked that someone has been working with SQL for at least 1 year and 7 months (according to their post history), claims to be "newbie", and then doesn't know such a thing and (apparently) made no effort on their own to find out.
https://www.sqlservercentral.com/forums/topic/difference-between-numeric-and-decimal
I guess things like this shouldn't surprise me anymore.
Considering that NUMERIC and DECIMAL are synonymous. I will add one for you. In some dynamic code I am reworking numeric is treated as a floating number and decimal as fixed decimal when converting to a character representation.
January 7, 2020 at 9:19 am
Jeff Moden wrote:Unexpected gifts from nowhere... I now have a second "Ice Breaker/Litmus Test" question for interviews. No need to pile on folks. I'm just a little gob-smacked that someone has been working with SQL for at least 1 year and 7 months (according to their post history), claims to be "newbie", and then doesn't know such a thing and (apparently) made no effort on their own to find out.
https://www.sqlservercentral.com/forums/topic/difference-between-numeric-and-decimal
I guess things like this shouldn't surprise me anymore.
Considering that NUMERIC and DECIMAL are synonymous. I will add one for you. In some dynamic code I am reworking numeric is treated as a floating number and decimal as fixed decimal when converting to a character representation.
Lynn, can I swap jobs?
I have a table with 1024 columns, labelled col1,col2,col3 etc. for each customer col3 might store a differerent value (car parking spaces, staff count, number of police incidents etc) - now there is also a trigger on that table that calls a stored proc (meaning we can only update one row at a time)…. so I have a cursor and in the where clause of the cursor is a non-deterministic function (with another cursor in it) - the function executes against 50 million rows and returns 3 or 4 rows...…..MADNESS
developer solution - "get better hardware, we've had this for a year"
My solution : "LEARN TO WRITE KEY VALUE PAIRS, NORMALISE, AND STOP USING SQL LIKE YOU USE C# (BADLY)
MVDBA
January 7, 2020 at 2:56 pm
As to the last film. How long have they known that they could launch a ship into space warp or whatever they're calling it and destroy every single thing in it's path? Why wasn't this a common tactic. Throw a droid on a derelict and launch it at the enemy. Heck, purpose build a bunch of rails with a warp drive and throw them at the enemy. Not to mention, blast enemy installations with it. Death Star? No problem. Throw five or six of those rails at it. Done. Fixed it.
Or, let's say they just figured it out. If they're not using it all over the place in the next movie, it's stupid. You just found one of the single most devastating weapons in the universe, but you're going to go back to star fighters? Nope. Space battles suddenly look like Jutland. No heavy concentrations of ships because of this new terror weapon. Everyone is scattered & isolated in a far flung cloud where you try to coordinate attacks of the fleet.
Again, that would be a great movie done right. I'm anticipating more simulations of the Battle of Midway combined with Dam Busters, just with additional stupid.
Good! Use your aggressive feelings, boy. Let the hate flow through you!
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
January 7, 2020 at 3:02 pm
Good! Use your aggressive feelings, boy. Let the hate flow through you!
HA!!
From the reviews I've heard, I was right though.
It's a real shame. I did love the universe set up by the first two (chronological) movies. Then, it slipped and slid into utter crap.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 7, 2020 at 3:06 pm
Lynn Pettis wrote:Jeff Moden wrote:Unexpected gifts from nowhere... I now have a second "Ice Breaker/Litmus Test" question for interviews. No need to pile on folks. I'm just a little gob-smacked that someone has been working with SQL for at least 1 year and 7 months (according to their post history), claims to be "newbie", and then doesn't know such a thing and (apparently) made no effort on their own to find out.
https://www.sqlservercentral.com/forums/topic/difference-between-numeric-and-decimal
I guess things like this shouldn't surprise me anymore.
Considering that NUMERIC and DECIMAL are synonymous. I will add one for you. In some dynamic code I am reworking numeric is treated as a floating number and decimal as fixed decimal when converting to a character representation.
Lynn, can I swap jobs?
I have a table with 1024 columns, labelled col1,col2,col3 etc. for each customer col3 might store a differerent value (car parking spaces, staff count, number of police incidents etc) - now there is also a trigger on that table that calls a stored proc (meaning we can only update one row at a time)…. so I have a cursor and in the where clause of the cursor is a non-deterministic function (with another cursor in it) - the function executes against 50 million rows and returns 3 or 4 rows...…..MADNESS
developer solution - "get better hardware, we've had this for a year"
My solution : "LEARN TO WRITE KEY VALUE PAIRS, NORMALISE, AND STOP USING SQL LIKE YOU USE C# (BADLY)
Ouch!!! This sounds a lot like a bunch of stuff I dealt with about 15 years on a long term consultancy. They had multiple nested stored procs with cursors with multiple entry points into the nested set of procs. The outer procs all created temp tables that were referenced by the inner procs. Nested cursors in most of them. The original author had left the company and nobody could unravel the mess that was left behind. Fortunately they had a large plotter so I was able to document the current process and show a visual path of just how crazy the whole thing was. Took me and about 4 other people close to a year to unravel that disaster. This was a nightly process that took several hours. Once we were done it was running in less than a couple minutes.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
January 7, 2020 at 3:53 pm
Like all art, it means different things to different people. I was born in '78, so only got to see Return of the Jedi in the theater, guess which movie was my favorite? And to me, Star Wars in general was the end-all and be-all of sci-fi growing up, so it's nostalgia. Prequels basically ruined that for me.
Rogue One trailer popped up that first time, I actually teared up and choked out "many bothans died..." ( and then, where were the bothans?)
But, I've come to see things in a different lens through my son, who still has only seen the lego versions of the movies (he's too scared by all the blaster scenes just yet, this may be the year). If these new movies, although it's just the old ones turned inside out, manage to inspire him to imagine bigger things and turn him on to more fantastic stories, then they've done their job.
Plus, turns out Lucas is an idiot and wanted to do some sort of "inner space" version of things with the midichlorians. Thank goodness that didn't happen.
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
January 7, 2020 at 3:57 pm
Rogue One trailer popped up that first time, I actually teared up and choked out "many bothans died..." ( and then, where were the bothans?)
None for the Death Star; they all died for the plans of the Death Star II. 😉
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 7, 2020 at 4:06 pm
see? learn something new every day. Now we just need a Guns of Navarro/Mission Impossible/James Bond movie about Bothans that ties right into Jedi
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
Viewing 15 posts - 64,291 through 64,305 (of 66,815 total)
You must be logged in to reply to this topic. Login to reply