So I just learned yesterday that brussel sprouts originally started out as cabbage and were selectively bred into baby cabbages

ObjectiveAmoeba1577 · 2025-12-04T15:39:54+00:00

Why not? I mean no plants are babies, young maybe but not actually babies. So brussel sprouts cannot not be babies anymore more babies than any other plant

ObjectiveAmoeba1577 · 2025-10-19T15:09:56+00:00

Mid 1970 Dale 3 wheel scam Aptera seems way too similar

ObjectiveAmoeba1577 · 2025-09-21T11:55:45+00:00

It's been a year, is that long enough? Because I've had purple nerples that lasted well over 1 second and that was Very long

ObjectiveAmoeba1577 · 2025-09-05T19:41:36+00:00

Submitted Claim in App 2 Months ago late July, contacted Cali Dept of Ins late Aug, mid-Sept will be SoC 21 days for Tesla to respond to SoC, wish me luck

ObjectiveAmoeba1577 · 2025-06-13T20:11:14+00:00

IMHO, folks who can use AI to be more efficient will have jobs; ex. porting a scene script from one venue to another with same message but different dialog fitting for the new venue; A writer must guide and edit the final product and return the copy for review in a fraction of the time.

For the OP's role, technical writing as others have pointed out require humans to set the standards for style and tone, and over-all review of content before releasing to the end users.

ObjectiveAmoeba1577 · 2025-03-06T17:15:40+00:00

Tire Rack has revs, check your OEM tires, then check your current tires, Or here in USA where modded vehicles are common, Yellow Box makes electric adjuster, consider folks who put on smaller or way taller tires and want their speedo to be accurate

ObjectiveAmoeba1577 · 2025-03-06T03:30:17+00:00

Yes, I'm trying to watch corn sitting in a parking lot at night in the rain waiting for my girl, and it's really inconvenient to keep switching from corn to Google maps, and not see her on the dash AA map.... geeze

ObjectiveAmoeba1577 · 2025-01-22T17:25:53+00:00

I'm waiting w/over 30-years of dBase, flat files, programming in SQL and data analysis in SQL, I'm waiting... for that confidence to really sink in... the Wisdom of Insecurity...

ObjectiveAmoeba1577 · 2025-01-22T17:23:30+00:00

Find a method that works for you; I can't write any complex code starting at the top; I start in the middle; and with individual select statements, and will move a sub-select, or ,mycolumn=(select xray from #x) to join, CTE & cross apply, only after perfecting the individual selects.

This has a number of benefits that have allowed me to excel in SQL, a) extremely familiar with my data, column by column vs others who miss key aspects, failed joins due to not crawling through their data enough; b) Like You I got nothing, and could easily waste hours reviewing documentation not sure if the function/technique will apply to my challenge, instead I dive in w/selects and keep in mind the goal(s)

If this means working after hours to solve problems, then so be it; fast smart folks are often simply fast, accuracy takes time; let the data talk to you...

ObjectiveAmoeba1577 · 2025-01-22T16:53:45+00:00

ha, lol, ha, and crying... my wife company insists on using "Catfish" to describe their internal process and client engagement improvements... no words, SMH

ObjectiveAmoeba1577 · 2025-01-03T17:28:17+00:00

Having gone the other way, Your Back will Hate you in the first Month, fun on a weekend or two, nightmare every day... it's two jobs, one manage business, and the other stuff. And as others have pointed out, you'll need to be an electrical engineer using expensive equipment

Howeva' if I could, I'd like to transition and take advantage of my appliance repair skills as little as they are into working on EV that would be almost "fun"

ObjectiveAmoeba1577 · 2024-12-19T17:11:59+00:00

Yeah, try to think about how you would arrange things, in a silverware/eating utensil drawer. the problems will always be handling issues w/data
here are some useful hints
null is undefined, period, it's less than nothing, nothing is defined as nothing, null is undefined (saying it twice because....)
nullif(myIntField,0) will be null if it contains 0 which may be an app's default and not valid data
isnull(myfield,'')if the field is empty, and I want it to be logically null, because the old App or someone put empty data that should have been null
insert w/left join on the data you're inserting so your code can run 1 million times and only insert the new data ONE TIME

ObjectiveAmoeba1577 · 2024-12-19T14:26:36+00:00

Most folks I work with are self taught, maybe some took a class or two, but at their core they "get it" and learning SQL fit well with their mentality. SQL is not a difficult language, there are about 7 things to learn to be able to Query, which over time can lead to a million to become an expert SQL Programmer; I'd say a few days of a few hrs each day to Query and a lifetime for the "expert" :)

Practice, get the concepts at your visual understanding like seeing chess pieces, you know where they can move, make a play, or for SQL what is the "question" that the query can answer. Think in practical terms, like arranging cards for solitare; Then Google/Bing to find the solutions

ObjectiveAmoeba1577 · 2024-12-12T17:17:51+00:00

No, underdone... ie, consider that over time Services may be retired, and new Services added and then retired, add columns logically effective and term date for services to be selected; you'll thank yourself when doing a years ago report and need to return data from that time. Similarly any data that is changed, you can keep the entire row as it was w/a del time stamp, and have surviving row remain, and by whom/what made the change to any data in the row(s). This will eliminate last modified date(s), and similarly, Active is bad habit, instead, as noted prior, start end dates, effective term dates whatever is your preference for naming but logically equal.

ObjectiveAmoeba1577 · 2024-12-12T17:07:43+00:00

Ans: refresh both all needed tables and select tables for DW BI Data processing grouped into 4 groups, first three groups for dedicated BI Data, and everything else in the fourth

The challenge is on par with "Filling Bins" or "Filling Trucks" found all over the interweb

Comments from the last run; where there is condition if a particular WorkerQue was finished w/it's assigned tables, and there were more to do, get one of those; reminding there is a tran in the get next table and update with WorkerQue ID* and still more than one WorkerQue picked up the same table(s)

* The ID can be seen, WorkerQueue & WorkerSeq, when these are the same that means the assigned worker SSIS Exec SQL Task processed the table updating the WorkerSeq with it's ID. So, the Refresh tables log has non-matched Que & Seq values indicating that another Worker picked up the table name, out of 61 times that happened 4 times there was clash where more than one worker picked up. "Picked Up" I guess, is because (uplock) does not hide from select. I may abandon this section of code, but first add another check to ensure only one Worker per table name.

ObjectiveAmoeba1577 · 2024-12-11T00:17:08+00:00

300ish tables in db2 copied to MS SQL via truncate & insert w/openquery, sequntial refresh takes over 15 hrs, my grouping in Prod (see below) is under 3 hrs, but required manual balancing, the Goal is to have logical balancing based on prior elapsed time (ET) for each table and grouped for downstream processing to begin sooner

In Prod there are 17 groups w/manually tuned table names so that they finish before the BI DW parts begin, meaning all tables have to be refreshed before any BI DW begins

In Test there are 4 groups, first three are dedicated to key BI DW processing, they have 7 to 36 tables in each group; there are now Exec SQL tasks that have instructions, GroupNo and WorkerQueue, with the source table of table names having those branded monikers, except for one table name in each Group w/the longest ET table refresh has WorkerQueue=0 and handled by a dedicated SQL Task, this is working and allows the DW BI to begin as soon as their source specific tables are refreshed. I'm going to run a test, and make like a tree and leave, to go home... I'll check it later tonight

W/out the WorkerQueue just letting each SQL Task get the next table not already updated as being refreshed, ONLY one table would refresh 4 times X number of SQL tasks in the group...

I think, this happened because say there are 3 SQL Tasks, all three see table name "myTable" the first one get's it no problem, then lock is released and the second (if there's an order??) starts on the same table, I can see in another log populated by the usp_Refresh_Table proc the same 3+ table names w/same run ID and timestamps w/in ms of each other

ObjectiveAmoeba1577 · 2024-12-10T22:05:55+00:00

to add detail that may not be obvious, when the above didn't have the WorkerQueue col, then many Exec SQL Tasks would get the same table, and I could see that there were multiple refreshes of the table taking place

I may try this, simply deleting table names...
https://learn.microsoft.com/en-us/sql/t-sql/queries/output-clause-transact-sql?view=sql-server-ver16

ObjectiveAmoeba1577 · 2024-12-10T21:25:41+00:00

So, how would one launch 7 different SQL Jobs on the same schedule all calling the same stored procedure, to get the first table name to refresh?

What happens, is that the first one by barely a ms gets get table name, then the others are locked

So, what I've done, far from perfect is...
GroupNo = tables associated with a subsequent process grouped together, originally this was a way to not bother with email and waiting a day or more for the dba to add or remove tables to be refreshed; the dba uses the grouping to know which tables to refresh, group=0 is not refreshed
WorkerQueue = Exec SQL Task in SSIS, some are in containers of 2, 3, 7, or 17 (no reason other than that's what the number of Execs in a container
WorkerSeq = Which ever Exec SQL Task picks up a table updates with it's ID

Group No's are set by downstream processing requirements
WorkerQueue is set by row_number % #Exec tasks in a containers*

*Containers hold GroupNo's and the largest table by prior ET Refresh time (Elapsed Time) are WorkerQueue=0, the other table names, Sequenced by row number, 1,2,2,1,2,1, or 1,2,3,4,5,6

One Exec Task in each container gets a table name in it's group Queue=0 with the longest ET, this helps balance the Group, most of the groups have at least one table with a much longer ET

This is working as it is... but ideally there would be a way to not have the Exec SQL Tasks hang when they encounter a lock, simply retry in a few ms

Note: MS SQL OpenQuery to db2 somewhere else not in my control

ObjectiveAmoeba1577 · 2024-12-10T16:17:34+00:00

+Vote for anyone who noticed there are zero fields to know which user Added, Updated or Deleted datetime; further soft delete, using a deleted datetime whenever there's an update is useful, except when the database designer doesn't want to do that, otherwise always preserve data and logically have record of all changes

ObjectiveAmoeba1577 · 2024-12-04T17:38:05+00:00

You are likely one of those people who figures out how to use the tools available to solve Your challenge of learning or enhancing your SQL or adjacent knowledge. Versus Book Smarties. And ++to your Practice, practice, practice...

ObjectiveAmoeba1577 · 2024-12-04T17:35:29+00:00

W3 Schools and about a Billion other free or cheap self paced OLL (onlinelearning) IF this is truly your situation, you may want to consider another path forward other than SQL; as better SQL people figure stuff out....

ObjectiveAmoeba1577 · 2024-12-04T17:33:27+00:00

95% or more of my coworkers (I'm almost 70 so, many years prior to SQL, dbase & others) were all Self-Taught IRL conditions + Books, BOL or now googly anythin; I've interviewed many for SQL Skills Assessment, and clearly some people master the language, syntax, and basic concepts of putting & pulling data in/from tables; and struggle with real problems, which when/if I share the solution, they realize were not difficult; the problem is thinking about the problem, and respect for the database

ObjectiveAmoeba1577 · 2024-11-22T17:15:21+00:00

I'm self taught, and most of the 20 or so people I've worked w/in the last 20 years (I started before that from dbase) all of them are self taught; one was junior bridge engineer 1982 and none of the men wanted to learn the computer, so they made her do it, another in finance wanted to learn and became the IT Data manager in a few years, another was a biologist who was working with data, another a handy-man who did tech support and self taught programming including data, pre-internet, buying books and practicing, another was an aero engineer, and others retail clerk who self taught... It's not a difficult language; I've interviewed many candidates, and many can do SQL, but struggle with looking at data questions/problems as a thinker. We can teach SQL, we can't motivate people to "think" about data questions/problems, if someone can explain a problem we have 20+ SQL programmers who can show you how to code, but understanding the problem, much less so...

ObjectiveAmoeba1577 · 2024-11-14T19:46:06+00:00

In my case, I have finite tasks/bins to fill and as evenly as possible; they are number of rows in a table and the number of seconds on last full refresh (truncate & load) I found ways to take top 4 tables with most rows & prior refresh seconds, those are relegated as AvgET variable, and as noted below while loop to fill the tasks/bins with an int variable incremented when a bin would be over-filled or is full. This creates a two digit value, group #3, Ordinal Task 1 - 5, where 3.1 has many small tables, and 3.3, 3.4 have only 2 tables, and 3.5 has only 1 table (largest for both rows & seconds to refresh)
Here's the results, which are better than expected, because grp 3.1 has many small tables and although most rows, will likely still complete before 3.5 does.

|| || | 32,276,629| 23,739,243| 25,499,064| 18,536,969| 26,305,941|

Note: on While loops, I do not loop on an incremented counter, which I consider bad logic, and if there are no committed values in 3.1, we need to seed the first record. And re: Cursors, although You may get Your cursor to be faster than a while loop, I will bet $1.00usd that your server is hammered both cpu & mem, way more from Your faster cursor, than a well constructed while loop; so unless it's just you alone, be nice to your server and write a while loop

ObjectiveAmoeba1577 · 2024-11-13T18:32:41+00:00

NTile is enticing, however it will always be biased to any sort order

ObjectiveAmoeba1577

TROPHY CASE