February 7, 2017 at 11:52 am
Ed Wagner - Tuesday, February 7, 2017 11:17 AMLynn Pettis - Tuesday, February 7, 2017 11:11 AMNope, not Silver Spoon but falls in the same category.
I read that post. Yes, definitely in the same SS category. I'm waiting for a followup question asking the same thing again.
Just give him a script for a full backup, if he can tell the difference then it's "differential"
😎
February 7, 2017 at 11:54 am
GAAAAAAAAAAAAAAAAAAAAAAAAAAHHHHHHHHHHHHHHH!
That moment when you're coding off a vended system, realize there's a problem, and then find out that the vendor doesn't care there's duplicated data in the history table. "Just grab the highest ID" as if there isn't the possibility of multiple records with nearly identical data being present, but also duplicated.
Can I just throw this thing in the lagoon now?
EDIT: For the record, our vendor contacts are really nice people. I have nothing against them. I'm just frustrated with this stupid table.
February 7, 2017 at 12:12 pm
Sean Lange - Tuesday, February 7, 2017 10:39 AMI think you should convert this to a scalar function....you know, for performance. :laugh:
That might be a good idea. I´ll keep trying to improve it.
February 7, 2017 at 12:22 pm
Luis Cazares - Tuesday, February 7, 2017 12:12 PMSean Lange - Tuesday, February 7, 2017 10:39 AMI think you should convert this to a scalar function....you know, for performance. :laugh:
That might be a good idea. I´ll keep trying to improve it.
Sounds about right😉
February 7, 2017 at 12:56 pm
Eirikur Eiriksson - Tuesday, February 7, 2017 12:22 PMLuis Cazares - Tuesday, February 7, 2017 12:12 PMSean Lange - Tuesday, February 7, 2017 10:39 AMI think you should convert this to a scalar function....you know, for performance. :laugh:
That might be a good idea. I´ll keep trying to improve it.
scalarˈskeɪlə/MATHEMATICSPHYSICSadjective
Sounds about right😉
Are you implying that a multidimensional table-valued time-warping vector function would improve things, Eirikur? 🙂
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
February 7, 2017 at 2:09 pm
Brandie Tarvin - Tuesday, February 7, 2017 11:53 AMGAAAAAAAAAAAAAAAAAAAAAAAAAAHHHHHHHHHHHHHHH!That moment when you're coding off a vended system, realize there's a problem, and then find out that the vendor doesn't care there's duplicated data in the history table. "Just grab the highest ID" as if there isn't the possibility of multiple records with nearly identical data being present, but also duplicated.
Can I just throw this thing in the lagoon now?
EDIT: For the record, our vendor contacts are really nice people. I have nothing against them. I'm just frustrated with this stupid table.
Hysterical Data?
'Nearly Identical' data and Duplicated Data are 2 different things.
Highest ID sounds like they might be journaling all history, where someone can ever press enter on a screen and it writes a new record, changed or not.
So it may be intentional design on their part.
Or maybe not......
February 7, 2017 at 2:22 pm
Brandie Tarvin - Tuesday, February 7, 2017 11:53 AMGAAAAAAAAAAAAAAAAAAAAAAAAAAHHHHHHHHHHHHHHH!That moment when you're coding off a vended system, realize there's a problem, and then find out that the vendor doesn't care there's duplicated data in the history table. "Just grab the highest ID" as if there isn't the possibility of multiple records with nearly identical data being present, but also duplicated.
Can I just throw this thing in the lagoon now?
EDIT: For the record, our vendor contacts are really nice people. I have nothing against them. I'm just frustrated with this stupid table.
Do I really want to consider applying for that job, even if I could work remotely ........ :hehe:
February 7, 2017 at 3:22 pm
Phil Parkin - Tuesday, February 7, 2017 12:56 PMEirikur Eiriksson - Tuesday, February 7, 2017 12:22 PMLuis Cazares - Tuesday, February 7, 2017 12:12 PMSean Lange - Tuesday, February 7, 2017 10:39 AMI think you should convert this to a scalar function....you know, for performance. :laugh:
That might be a good idea. I´ll keep trying to improve it.
scalarˈskeɪlə/MATHEMATICSPHYSICSadjective
Sounds about right😉
Are you implying that a multidimensional table-valued time-warping vector function would improve things, Eirikur? 🙂
Spot on Phil
😎
February 8, 2017 at 2:21 am
Lynn Pettis - Tuesday, February 7, 2017 11:08 AMTalking about Silver Spoon, Gail?
I was wondering if it was the Canine from Cymru...
...and, by the looks of things, I would have been wrong.
Thomas Rushton
blog: https://thelonedba.wordpress.com
February 8, 2017 at 5:11 am
I actually hated the series when it came out, but watched it religiously (we had crap SF on TV back in the day).
"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
February 8, 2017 at 5:49 am
Greg Edwards-268690 - Tuesday, February 7, 2017 2:09 PMBrandie Tarvin - Tuesday, February 7, 2017 11:53 AMGAAAAAAAAAAAAAAAAAAAAAAAAAAHHHHHHHHHHHHHHH!That moment when you're coding off a vended system, realize there's a problem, and then find out that the vendor doesn't care there's duplicated data in the history table. "Just grab the highest ID" as if there isn't the possibility of multiple records with nearly identical data being present, but also duplicated.
Can I just throw this thing in the lagoon now?
EDIT: For the record, our vendor contacts are really nice people. I have nothing against them. I'm just frustrated with this stupid table.
Hysterical Data?
'Nearly Identical' data and Duplicated Data are 2 different things.
Highest ID sounds like they might be journaling all history, where someone can ever press enter on a screen and it writes a new record, changed or not.
So it may be intentional design on their part.Or maybe not......
Nearly identical as in I'm only interested in 5 columns which would be duplicated, so I'd have to add another column which I'm not interested in to get the true unique, but that column would screw up my result set and cause other issues.
February 8, 2017 at 5:50 am
Grant Fritchey - Wednesday, February 8, 2017 5:11 AMAnd Captain Apollo is dead.I actually hated the series when it came out, but watched it religiously (we had crap SF on TV back in the day).
Hay, but the tight outfits on the ladies were nice, as I was in my early twenties and single.
February 8, 2017 at 7:21 am
Lynn Pettis - Tuesday, February 7, 2017 2:22 PMBrandie Tarvin - Tuesday, February 7, 2017 11:53 AMGAAAAAAAAAAAAAAAAAAAAAAAAAAHHHHHHHHHHHHHHH!That moment when you're coding off a vended system, realize there's a problem, and then find out that the vendor doesn't care there's duplicated data in the history table. "Just grab the highest ID" as if there isn't the possibility of multiple records with nearly identical data being present, but also duplicated.
Can I just throw this thing in the lagoon now?
EDIT: For the record, our vendor contacts are really nice people. I have nothing against them. I'm just frustrated with this stupid table.
Do I really want to consider applying for that job, even if I could work remotely ........ :hehe:
To be fair, the job up for grabs has nothing to do with this vended system. Only 3 DBAs work on this system and we're all in Jacksonville, working for a small AOR.
February 8, 2017 at 7:26 am
So much fun trying to track database migrations to new servers, trying to keep track of which DB is going to which server and which are done and not...
I keep myself mostly on-track by taking DBs that have been migrated offline on their old servers, but it'd be nice to have something "graphic" as well...
Visio would be perfect for what I'm thinking of doing (yeah, it'd be a spaghetti tangle of lines, but if it works for me, who cares?) but in the time it would take for me to get Visio on my work laptop, I'll probably be done with the migration...
So, instead, I'm selecting all the db names and states from my registered servers, copying those results into a temp table and adding a couple fields to track QAs / Prods and Old / New servers, then joining things up. Then those results get copy / pasted in Excel so I can color code things a bit...
Gotta be a better way to track this, but thankfully this is a once-in-a-while thing (as in, either the OS on the servers is no longer supported by MS, the version of SQL is no longer supported, or there's a mandate from higher up to move to a new OS / SQL)
February 8, 2017 at 8:21 am
Grant Fritchey - Wednesday, February 8, 2017 5:11 AMAnd Captain Apollo is dead.I actually hated the series when it came out, but watched it religiously (we had crap SF on TV back in the day).
I liked the first few seasons, but then things started getting a little out there towards the end of the original series.
Viewing 15 posts - 57,391 through 57,405 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply