January 7, 2020 at 4:24 pm
MVDBA (Mike Vessey) wrote: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.
I can make it worse - because the table is shared between multiple customers, they have the option to "add new fields" - it tries to add a new field and a new field in a view...… ERROR cannot have more than 1024 fields.
if we get another customer we are dead. - I end up going to the devs and saying "which field can I drop" - answer "oh MAYBE anything between 17 and 24" so I do it, everything breaks...… luckily the smart DBA has a DR server with a compressed backup (still nearly a terabyte) and a nice boss who bought him and all the department Redgate toolbelt..... funny how it's my job to restore the data and never the dev team 🙁
MVDBA
January 7, 2020 at 4:28 pm
but....you tested dropping those columns in UAT somewhere and had the devs sign off on what to change and whether it worked correctly, right? Or you'll do that for the next round?
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
January 7, 2020 at 4:36 pm
but....you tested dropping those columns in UAT somewhere and had the devs sign off on what to change and whether it worked correctly, right? Or you'll do that for the next round?
hahahahahahahahahah you make me cry -'m in the middle of devops at the minute - I've only just got us in source control, our devs just do stuff on live ….. THIS WILL CHANGE
MVDBA
January 7, 2020 at 5:13 pm
hahahahahahahahahah you make me cry -'m in the middle of devops at the minute - I've only just got us in source control, our devs just do stuff on live ….. THIS WILL CHANGE
You poor soul... at least now I don't feel as bad that I spend a lot of my time telling night-shift workers on the other side of the planet the way they should have done things and all the things that they don't do that they should have.
January 7, 2020 at 5:55 pm
Grant Fritchey wrote: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!
Unfortunately I don't think it works all the time. It may depend on the distance from the ship being attacked if it is destroyed or not. In Rogue One as the Rebel fleet fled I remember seeing at least one rebel ship destroyed when it hit a Star Destroyer when it "warped in" while the rebel ship was "warping out".
January 7, 2020 at 5:59 pm
Unfortunately I don't think it works all the time. It may depend on the [plot value of the ship entering hyperspace] if it is destroyed or not.
Fixed that for you...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
January 7, 2020 at 6:03 pm
Sean Lange wrote:MVDBA (Mike Vessey) wrote: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.
I can make it worse - because the table is shared between multiple customers, they have the option to "add new fields" - it tries to add a new field and a new field in a view...… ERROR cannot have more than 1024 fields.
if we get another customer we are dead. - I end up going to the devs and saying "which field can I drop" - answer "oh MAYBE anything between 17 and 24" so I do it, everything breaks...… luckily the smart DBA has a DR server with a compressed backup (still nearly a terabyte) and a nice boss who bought him and all the department Redgate toolbelt..... funny how it's my job to restore the data and never the dev team 🙁
This definitely sounds like it should have been done as an EAV table instead of a flat table. Of course, a better (read thought out) design would have been even better.
January 7, 2020 at 6:59 pm
Still haven't seen Star Wars. Was disappointed in 7, 8 was better. Need to go see the last one with my kid. Finding time is the hard part now.
January 7, 2020 at 8:53 pm
I haven't seen it yet either but plan on once I recover from my being sick after visiting my oldest daughter and four grandkids in TN over Christmas.
I honestly don't care what the critics say, I want to see it just because it is Star Wars.
January 8, 2020 at 8:48 am
I went to see ROS with my brother-in-law and nephew between Christmas and New Year and I thought it was pretty good. There were plot holes you could drive a lorry through and some truly terrible lines but it did what I wanted it to do. The important thing was my nephew loved it. It was his first 'grown-up' film and he was a very excited young man. The fact his uncle bought him nearly a pound of pick-and-mix and was encouraging him to eat it all had nothing to do with it.
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
January 9, 2020 at 5:54 pm
Well, I'm finally getting one of my wishes at work and I'm simultaneously happy and worried...
I'm getting complete control over my database backups. We're cloudifying (well, they're calling it a cloud, it's really the same basic setup we've got now except the people managing the underlying hardware are in a different state) our servers (web, SQL, and others,) and the only backups the cloud provides is file-level.
So, initially, I'm going to go with the Ola scripts for the backups rather than trying to roll my own or a maintenance plan or the headaches of purchasing software. Long-term, I'd like to go with a commercial solution just to make it easier for the times I'm on vacation or after I leave, but that's a down-the-road.
Wish me luck (or skill, skill might be better)!
January 9, 2020 at 9:53 pm
Good luck with that. Not sure third party tools make this better, but you're welcome to eval SQL Backup from Redgate if it might help
January 9, 2020 at 10:18 pm
Good luck with that. Not sure third party tools make this better, but you're welcome to eval SQL Backup from Redgate if it might help
Is Redgate backup able to "pull" from database servers to backup servers? I evaluated it once a while back, but it was before all the malware madness, and now I'm reading more often that pulling backups from database servers is better than pushing backups to backup servers.
Viewing 15 posts - 64,306 through 64,320 (of 66,815 total)
You must be logged in to reply to this topic. Login to reply