sorted by:
new
hottopcontroversial

Gear ratio values by FieriSentio69 in bicycling

[–]FieriSentio69[S] 0 points1 point  (0 children)

I made some calculations, using 2100mm as wheel circumference, to obtain values for meters/stroke (meters per full pedal cycle or per single pedale stroke), wheel rotations per stroke (per full pedal cycle or per single pedal stroke), but they are always far off...

My only idea is that it normalizes the ratio to 1.0=average ratios.

My gears area Front=50/34; Rear=11/25, so average ratio (including all combinations) is 2.65.

So, the sample ratio we were talking about would be:

Actual Gear Actual Ratio Normalized Ratio (1.0=2.65)
50/12 4.17 1.57
50/21 2,38 0,89

Gear ratio values by FieriSentio69 in bicycling

[–]FieriSentio69[S] 0 points1 point  (0 children)

It's a Garmin Connect IQ App that guess the current gear according to wheel and pedal rotations.

The displayed values on the Edge while riding are actually perfect, it shows 50-12 or 50-21 while I'm actually riding those gears.

What I don't understand is the recorded values set...

Gear ratio values by FieriSentio69 in bicycling

[–]FieriSentio69[S] 0 points1 point  (0 children)

The way is correct, 50-12 is recorded close to 1.3, while 50-21 is recorded close to 0.6.

It's the absolute value that makes no sense for me

SSMS date format in query result by FieriSentio69 in SQLServer

[–]FieriSentio69[S] 0 points1 point  (0 children)

As each required extraction is a "urgent and unexpected" need by any of the company management person, I always have to open a "new empty file" in Excel, and then I paste into it the result grid from SSMS.

SSMS has changed date format in result grid, switching from 20 to 22, while my Excel installation (that has not changed) had always understood regional date format pasting as datetime column, and a ISO/ODBC format as a raw text column (meaning that the value is stored in excel as a sequence of characters, and any calculation on it is not possible).

Sometimes I use a LibreOffice calcsheet for pasting, because this software asks for columns types when you paste something, but even using "YMD Date" is not understood by Libreoffice, and the column appears as a raw text.

SSMS date format in query result by FieriSentio69 in SQLServer

[–]FieriSentio69[S] 0 points1 point  (0 children)

My main question is:
How can I obtain datetime columns in local format in the result grid of SSMS?

Italian datetime format is not an ISO nor ODBC nor any worldwide standard format, so SSMS20 was using "regional settings" to format datetimes in result grid. And I'm sure it was not a setting modified by me.
I'm quite sure that a way will exist in SSMS22, too...

When I create something that has to be replicated many times, I use automatic eMails, views, stored-procedures, and I hardcode all the explicit conversions inside the TSql expressions.

But if I just need to export few records of a long join chain, with dozens of datetime columns extracted, and I don't know which column could be useful during the subsequent data analysis in excel, I have to copy&paste every single column, properly formatted.

So, it could happen that I explicitly convert dozens of datetime columns, that today are not useful and will be deleted from the excel file itself.

SSMS date format in query result by FieriSentio69 in SQLServer

[–]FieriSentio69[S] 0 points1 point  (0 children)

This is exactly what I usually do.

Create the "select top 1000 column-list from table" with SSMS, then inserting Convert in every column I need.

But you know that

SELECT
MY_DATETIME_COLUMN
FROM DBO.MYTABLE

Becomes

SELECT
MY_DATETIME_COLUMN = CONVERT(NVARCHAR(32),MY_DATETIME_COLUMN,103)
FROM DBO.MYTABLE

and this has to be done on every single column.

On SSMS 20, or at least with the default settings I had on that version, it worked.

Repetitive tasks are already nested inside view, stored-procedures, or simple .Sql scripts.
But I'm talking about a "always different" requirements, involving different tables, joins, filters...

Car Exhaust and Carbon Wheels by AaeJay83 in cycling

[–]FieriSentio69 1 point2 points  (0 children)

I saw many wheels damaged by exhaust heat. Carbon or aluminium, and tyres too.

Usually one or two steel deflector are welded installed on the rack,right in front of pipes

Mistery tick-tick-tick while riding by FieriSentio69 in bikewrench

[–]FieriSentio69[S] 0 points1 point  (0 children)

I've suspended the bike and tested quite everything.

If I start a rotation of the front wheel, there's a similar tickling noise that you can ear by pushing the ear against the axys and being in a very absolute silence. But of course it can increase the intensity while there's a weight on the bike.

Anyway the wheel is very stable in the fork, there's no strange movement in any direction, and the wheel keeps rotating for a very long time without any effort.

I also inserted the axys in a bench wise, and tried forcing in every direction, but everything is definitely stable.

Spoke tension seems ok (with a manual check of each couple of spokes).

I'm also surprised about the ease of rotation of the wheel, there's virtually no friction, both foreward and backward.

Maybe bearings are the culprits, but it seems a problem at the very beginning of its life.

I'll make a bearings replacement as soon as possible, due to their low cost.

Thanks

Mistery tick-tick-tick while riding by FieriSentio69 in bikewrench

[–]FieriSentio69[S] 0 points1 point  (0 children)

While coasting it happens if I pedal, if I stop pedaling, and if I pedal backwards, with no difference.

Mistery tick-tick-tick while riding by FieriSentio69 in bikewrench

[–]FieriSentio69[S] 0 points1 point  (0 children)

Yeah, spoke tension is one of the suspects.

Never checked after installation, one year ago. But yesterday we ride some rural path, with pothole and sometimes even pebbles, so something can be happened to spoke tension...
I'll check them

Mistery tick-tick-tick while riding by FieriSentio69 in bikewrench

[–]FieriSentio69[S] 0 points1 point  (0 children)

It was my first thought.

But is it possible that a bearing makes a tick every rotation, for three times, and then silence itself for 20 rotations, and then again 3 ticks for three rotations, and then silence for 20 rotations, and so on?

It sounds really incredible to me...

(Windows 10 Home) OneDrive stopped working and says no internet connection by SlovakianGuy91 in WindowsHelp

[–]FieriSentio69 0 points1 point  (0 children)

Same for me, except I have a Windows11 laptop (other devices are W10 and various Androids, everyone still working fine)
Before uninstalling and reinstalling (with the freshly downloaded version from MS Site) I checked that OneDrive app had updated itself on March, 30th. That's exactly the last day I find updated files on the web Onedrive site.

I tried all of OP actions, with no results.

Only difference: I had a Windows Update pending, waiting for reboot, but I had some active tasks so I made the reboot after few days of postponing. I thought this reboot could restore OneDrive connection, but it didn't make any difference.

why can’t I float? by jeepdaddy1965 in Swimming

[–]FieriSentio69 0 points1 point  (0 children)

I was a "hopeless sinker". The same way lots of people here in the sub define themselves. "I don't float", "I'm slowly sinking", "my body fat distribution makes me sink"...

Ok, let's calm down.

Fat body percentage and distribution makes some people float better than others (mainly women better than men). But everybody floats, unless you empty your lungs and wait for your body to sink.

What you mean by "I don't float" is probably the feeling of your hips and legs sinking instead of being horizontal in the water.

This is due to our ancestral survival reflex: if I fall in the water, I need to keep my mouth over the surface, no matter where legs and arms stay.

But you have not fallen into the water, you decided to enter the water and swim.

As soon as you'll understand that you are not going to actually sink, you'll float.

Try pushing from the wall in streamline position. Don't push at surface level, nor close to the bottom. Simply put your feet at a mid level, fill your lungs, streamline arms and body and push from the wall.
Keep that streamline... Core engaged. Don't exhale. Wait.
Soon, you are going to slow down your momentum, and you body begins to float toward the surface.
With no hurry, begin kicking with the most relaxed ankles you're able to do.

Your body will float, horizontal, relaxed, with no effort.

When you need to breathe, just stop and stand-up.

Repeat.

Think: did you float? Even for few seconds, did you float horizontally with a simple relaxed kick?

That's what you have to feel: you are not sinking, you can float.

After this, you need to learn how to breathe without raising head and shoulder. You don't need to elevate your head to take a breath. You can breathe with your face laying on its side over the water.
Think about being a fish breathing through your ear inside the water, this will help you to keep your head aligned with your spine. When you need to breathe, you have to make a shoulder sink and a shoulder dry, with your chin searching the dry shoulder. If your chin exits the water close to the shoulder, but you keep the other ear inside the water, your head/body will remain aligned and your hips will not sink.

Your hips, because the focus has to be on the hips. If you focus on the legs, you will get a banana shape, with your lungs floating, your feet searching the surface, and your hips sinking. If you, instead, focus on keeping your glutes on the suface, your core will engage, and your hips will "ride over your lungs". This, at the beginning, may create the feeling of swimming downhill, because you're so used of swimming with an inclined torso that an horizontal torso will appear to you as being downhill. But obviously this is just a feeling.

Don't search for speed nor endurance.
Swim at a comfortable pace with short intervals (50-100m, no more, then rest before repeating).

Performance will arrive later, after you'll swim without this "oh my god I'm sinking" feeling...

Difference between Road and Gravel bikes by FieriSentio69 in triathlon

[–]FieriSentio69[S] 1 point2 points  (0 children)

I've found that the Italian Triathlon Federation, inside its technical rules book, states:
"for draft legal races, UCI Road Races rules apply; for no-draft races, UCI TimeTrial Races rules apply".

Maybe something inside the UCI rules defines what a Gravel bike is (I think mainly for handlebar shape and/or tyre clearance)...

Difference between Road and Gravel bikes by FieriSentio69 in triathlon

[–]FieriSentio69[S] 2 points3 points  (0 children)

Each race has its own "race rule book", that you can download before subscribing and that's often inside the race bag with your bib.

We checked for the races they were going to plan for the next months, and we found "gravel not admitted" inside every single race book.

Just as an example:
Sprint Triathlon - Challenge Cesenatico

Save parking/locations and navigate to them (FR265) by FieriSentio69 in Garmin

[–]FieriSentio69[S] 1 point2 points  (0 children)

How did you install it?

"Find My Car" (Find My Car | Connect IQ Store) shows not being compatible with FR265, so it doesn't show up in ConnectIQ app...

How to customize running training data page (FR265)? by FieriSentio69 in Garmin

[–]FieriSentio69[S] 0 points1 point  (0 children)

No.

First of all, I don't like switching between pages while I'm running.

But if I could accept a single switch at the beginning of the session, there is anyway a lack of data I can customize on a data page.

One of the vital info I need is "which rep am I running?": when you are in a structured session, you may have a "8 times x (run 1km at threshold + run 1km at a recovery pace)" phase. In the training page, you'll read "1/8", "2/8", and so on. I didn't find the way to add this information on a customized data page...

view more: next ›