SQL Serverのクエリのコストを評価するには実行計画を取得する必要がある.最近のバージョンではクエリストアでクエリのコストを視覚化することが可能となった.今回はSQL Serverの実行計画を取得する従来の方法と,クエリストアを表示する方法を紹介する.元にした記事は日平均気温の過去30日間の移動平均をSQL Serverのウィンドウ関数を用いて計算するである.
医療機関テーブルに二次医療圏コードを追加する
医療機関テーブルには二次医療圏コードが存在しない.そのため,ある医療機関がどの二次医療圏に属しているかを調べるには空間データを調べる必要がある.空間データは計算コストが高く,テーブルの結合条件に STWIthin() メソッドを使うのは時間がかかる.そのため,医療機関テーブルに二次医療圏コードを追加しようと考えた.
ホームジムを再建する
個人的な事情で転職した.引越に伴い,ジムを移転したのでその経緯を報告しよう.
Ubuntu に SQL Server をインストールする
Ubuntu 環境に SQL Server をインストールする方法を書き記しておく.公式サイトはクイック スタート: Ubuntu に SQL Server をインストールし、データベースを作成である.
Office365のPowerPointで開発リボンを表示する方法
ちょっとした小技.Office 365 サブスクリプションでは「開発」タブが隠されていて初期状態では見られない.これを出す方法を見つけたので紹介する.
Google FormからSQL Serverへデータを移行するには
Google フォームから SQL Server にデータを移行する作業が続いたので,その際に得られた知見を公開する.
減量期のまとめ
減量にあたり,学術論文を読んだりトレーナーの講習を受けたり書籍を読んだりと自分なりに勉強してきた.2019 年 1 月 13 日で減量を終了し,今後しばらくは増量期に入るつもりだが,自分なりの総括をしておきたい.
PubMedで筋トレと炭水化物について論文検索してみた
前回に引き続き PubMed による検索.今回のテーマは増量であるが,増量に関しては検索結果は期待できない.
検索式は ((strength training) AND carbohydrate) AND systematic review である.これは詳細検索になる.結果は 31 件.そのうちめぼしい論文は以下の 3 編である.
- Resistance Training Prevents Muscle Loss Induced by Caloric Restriction in Obese Elderly Individuals: A Systematic Review and Meta-Analysis.
- Dietary Intake of Competitive Bodybuilders.
- The effect of exercise on the cardiovascular risk factors constituting the metabolic syndrome: a meta-analysis of controlled trials.
2 本目がそそるのだが,残念ながら有料論文だ.とりあえず要約だけコピペしてくる.
有料論文でも別ルートから全文が入手できる…かも
こういう時でも,諦めずに検索し続けると思わぬところから全文が手に入ったりする.まず試したいのはタイトルでの Google 検索だ.Google Scholar じゃないのか?と思うかも知れないが,通常の検索でよい.
論文特化型の検索だと公式の論文サイトからしか拾ってこないのだが,時々著者が自分のサイトで論文を公開してくれている場合がある. 今回はビンゴ!だった.
ResearchGate というサイトにあった.右上に Download full-text PDF というボタンがあるだろう?これがそうだ.
Dietary Intake of Competitive Bodybuilders.
BACKGROUND:
Competitive bodybuilders are well known for extreme physique traits and extremes in diet and trainingmanipulation to optimize lean mass and achieve a low body fat. Although many of the dietary dogmas in bodybuilding lack scientific scrutiny, a number, including timing and dosing of high biological value proteins across the day, have more recently been confirmed as effective by empirical research studies. A more comprehensive understanding of the dietary intakes of bodybuilders has the potential to uncover other dietary approaches, deserving of scientific investigation, with application to the wider sporting, and potential health contexts, where manipulation of physique traits is desired.
OBJECTIVE:
Our objective was to conduct a systematic review of dietary intake practices of competitive bodybuilders, evaluate the quality and currency of the existing literature, and identify research gaps to inform future studies.
METHODS:
A systematic search of electronic databases was conducted from the earliest record until March 2014. The search combined permutations of the terms ‘bodybuilding’, ‘dietary intake’, and ‘dietary supplement’. Included studies needed to report quantitative data (energy and macronutrients at a minimum) on habitual dietary intake of competitive bodybuilders.
RESULTS:
The 18 manuscripts meeting eligibility criteria reported on 385 participants (n = 62 women). Most studies were published in the 1980-1990s, with three published in the past 5 years. Study methodological quality was evaluated as poor. Energy intake ranged from 10 to 24 MJ/day for men and from 4 to 14 MJ/day for women. Protein intake ranged from 1.9 to 4.3 g/kg for men and from 0.8 to 2.8 g/kg for women. Intake of carbohydrate and fat was <6 g/kg/day and below 30% of energy, respectively. Carbohydrate intakes were below, and protein (in men) intakes were higher than, the current recommendations for strength athletes, with no consideration for exploration of macronutrient quality or distribution over the day. Energy intakes varied over different phases of preparation, typically being highest in the non-competition (>6 months from competition) or immediate post-competition period and lowest during competition preparation (≤6 months from competition) or competition week. The most commonly reported dietary supplements were protein powders/liquids and amino acids. The studies failed to provide details on rationale for different dietary intakes. The contribution of diet supplements was also often not reported. When supplements were reported, intakes of some micronutrients were excessive (~1000% of US Recommended Dietary Allowance) and above the tolerable upper limit.
CONCLUSION:
This review demonstrates that literature describing the dietary intake practices of competitive bodybuilders is dated and often of poor quality. Intake reporting required better specificity and details of the rationale underpinning the use. The review suggests that high-quality contemporary research is needed in this area, with the potential to uncover dietary strategies worthy of scientific exploration.
一つ興味深い記述がある.検索式だ. ‘bodybuilding’, ‘dietary intake’ and ‘dietary supplement’ で検索している.後で同じキーワードを適用してみることにしよう.
おっと,参考文献リストに randomised controlled trial が 2 編あるな.一応リンクを踏んでおこう. なになに,1 件目はチェックリスト作成について.これは直接関係なさそう.2 件目はどうだ?何かリンク先と PDF の内容がずれてる.これは PDF の方が正しい.タイトルは「過食中の体重増加,エネルギー消費量および体組成に及ぼす食餌たんぱく質含量の影響」だ.この論文もチェック対象に昇格させよう.
Effect of Dietary Protein Content on Weight Gain, Energy Expenditure, and Body Composition During Overeating
A Randomized Controlled Trial
Context
The role of diet composition in response to overeating and energy dissipation in humans is unclear.
Objective
To evaluate the effects of overconsumption of low, normal, and high protein diets on weight gain, energy expenditure, and body composition.
Design, Setting, and Participants
A single-blind, randomized controlled trial of 25 US healthy, weight-stable male and female volunteers, aged 18 to 35 years with a body mass index between 19 and 30. The first participant was admitted to the inpatient metabolic unit in June 2005 and the last in October 2007.
Intervention
After consuming a weight-stabilizing diet for 13 to 25 days, participants were randomized to diets containing 5% of energy from protein (low protein), 15% (normal protein), or 25% (high protein), which they were overfed during the last 8 weeks of their 10- to 12-week stay in the inpatient metabolic unit. Compared with energy intake during the weight stabilization period, the protein diets provided approximately 40% more energy intake, which corresponds to 954 kcal/d (95% CI, 884-1022 kcal/d).
Main Outcome Measures
Body composition was measured by dual-energy x-ray absorptiometry biweekly, resting energy expenditure was measured weekly by ventilated hood, and total energy expenditure by doubly labeled water prior to the overeating and weight stabilization periods and at weeks 7 to 8.
Results
Overeating produced significantly less weight gain in the low protein diet group (3.16 kg; 95% CI, 1.88-4.44 kg) compared with the normal protein diet group (6.05 kg; 95% CI, 4.84-7.26 kg) or the high protein diet group (6.51 kg; 95% CI, 5.23-7.79 kg) (P=.002). Body fat increased similarly in all 3 protein diet groups and represented 50% to more than 90% of the excess stored calories. Resting energy expenditure, total energy expenditure, and body protein did not increase during overfeeding with the low protein diet. In contrast, resting energy expenditure (normal protein diet: 160 kcal/d [95% CI, 102-218 kcal/d]; high protein diet: 227 kcal/d [95% CI, 165-289 kcal/d]) and body protein (lean body mass) (normal protein diet: 2.87 kg [95% CI, 2.11-3.62 kg]; high protein diet: 3.18 kg [95% CI, 2.37-3.98 kg]) increased significantly with the normal and high protein diets.
Conclusions
Among persons living in a controlled setting, calories alone account for the increase in fat; protein affected energy expenditure and storage of lean body mass, but not body fat storage.
系統的レビューから無作為化比較試験へ
調子に乗って別の検索式を試してみる.((strength training) AND carbohydrate) AND randomised controlled trial だとどうだろう?検索結果は 516 件に増えた.さすがにこれは全部チェックできないのでキーワードを加えて絞ることにする.
先程候補に上げたキーワードの一つ dietary intake を加えてみる.検索結果は 89 件に減った.これならタイトルチェックができそうだ.検索式は ((((strength training) AND carbohydrate) AND randomised controlled trial)) AND dietary intake となる.
キーワードを systematic review から randomised controlled trial に切り替えて何してるんだ?と思われたかも知れない.
これはエビデンスレベルの変更を行っている.系統的レビューが最もエビデンスレベルが高い.二番目に高いのが無作為化比較試験だ.系統的レビューであっても,元になる論文のレベルが低いと結果もあまり信頼できない.個人的なこだわりだが,質の低い系統的レビューよりも質の高い 1 本の無作為化比較試験の方が真実を射抜いている可能性がある.
ちょっとここでチートをしてみる.表示件数を 100 件に増やし,ブラウザの検索を使って carbohydrate というキーワードを検索する.該当は 18 件だが最初の 3 件は無関係なので無視.16 件目以降も無関係だ.
かなり興味深い検索結果だ. タイトルを見ているだけで関心のある論文に迫っているのが分かる.
- Effects of different macronutrient consumption following a resistance-training session on fat and carbohydrate metabolism.
- Minimal nutrition intervention with high-protein/low-carbohydrate and low-fat, nutrient-dense food supplement improves body composition and exercise benefits in overweight adults: A randomized controlled trial.
- Carbohydrate feeding during recovery alters the skeletal muscle metabolic response to repeated sessions of high-intensity interval exercise in humans.
- Increased p70s6k phosphorylation during intake of a protein-carbohydrate drink following resistance exercise in the fasted state.
Effects of different macronutrient consumption following a resistance-training session on fat and carbohydrate metabolism.
The effect of consuming meals of different macronutrient content on substrate oxidation following resistance exercise was examined in 9 resistance-trained men (26.2 +/- 2.4 years). Subjects completed 3 resistance exercise bouts of 8 exercises and 1 warm-up set (50% of 10 repetition maximum [RM]), which were followed by 3 sets of 10 repetitions (72.7 +/- 1.9% 10RM), with 60 seconds of rest between sets. Forty-five minutes after exercise, subjects consumed meals of high fat (HF, 37% carbohydrate, 18% protein, and 45% fat), high carbohydrate (HC, 79% carbohydrate, 20% protein, and 1% fat), or water (CON). Fat and carbohydrate oxidation were determined at 15-minute periods after meal consumption for 165 minutes. Blood was collected at preexercise (pre), premeal (0 minutes), and 15, 30, 45, 60, 90, 120, 150, and 180 minutes postmeal and was analyzed for insulin, glucose, triacylglycerols, and glycerol. There were no significant differences among the meal conditions for fat and carbohydrate oxidation. Insulin and glucose concentrations were significantly higher (p < 0.05) following HC at 15, 30, 45, 60, and 90 minutes compared to HF and CON. Triacylglycerol concentrations were significantly higher (p < 0.05) following HF at 90, 120, 150, and 180 minutes compared to HC and CON. Fat and carbohydrate oxidation were not affected by differences in macronutrient meal consumption after an acute bout of resistance training. Different macronutrient consumption does influence insulin, glucose, and triacylglycerol concentrations after resistance exercise.
Minimal nutrition intervention with high-protein/low-carbohydrate and low-fat, nutrient-dense food supplement improves body composition and exercise benefits in overweight adults: A randomized controlled trial.
BACKGROUND:
Exercise and high-protein/reduced-carbohydrate and -fat diets have each been shown separately, or in combination with an energy-restricted diet to improve body composition and health in sedentary, overweight (BMI > 25) adults. The current study, instead, examined the physiological response to 10 weeks of combined aerobic and resistance exercise (EX) versus exercise + minimal nutrition intervention designed to alter the macronutrient profile, in the absence of energy restriction, using a commercially available high-protein/low-carbohydrate and low-fat, nutrient-dense food supplement (EXFS); versus control (CON).
METHODS:
Thirty-eight previously sedentary, overweight subjects (female = 19; male = 19) were randomly assigned to either CON (n = 10), EX (n = 14) or EXFS (n = 14). EX and EXFS participated in supervised resistance and endurance training (2x and 3x/wk, respectively); EXFS consumed 1 shake/d (weeks 1 and 2) and 2 shakes/d (weeks 3-10).
RESULTS:
EXFS significantly decreased total energy, carbohydrate and fat intake (-14.4%, -27.2% and -26.7%, respectively; p < 0.017), and increased protein and fiber intake (+52.1% and +21.2%, respectively; p < 0.017). EX and EXFS significantly decreased fat mass (-4.6% and -9.3%, respectively; p < 0.017), with a greater (p < 0.05) decrease in EXFS than EX and CON. Muscle mass increase only reached significance in EXFS (+2.3%; p < 0.017), which was greater (p < 0.05) than CON but not EX (+1.1%). Relative VO2max improved in both exercise groups (EX = +5.0% and EXFS = +7.9%; p < 0.017); however, only EXFS significantly improved absolute VO2max (+6.2%; p = 0.001). Time-to-exhaustion during treadmill testing increased in EX (+9.8%) but was significantly less (p < 0.05) than in EXFS (+21.2%). Total cholesterol and LDL decreased only in the EXFS (-12.0% and -13.3%, respectively; p < 0.017). Total cholesterol-to-HDL ratio, however, decreased significantly (p < 0.017) in both exercise groups.
CONCLUSION:
Absent energy restriction or other dietary controls, provision of a high-protein/low-carbohydrate and -fat, nutrient-dense food supplement significantly, 1) modified ad libitum macronutrient and energy intake (behavior effect), 2) improved physiological adaptations to exercise (metabolic advantage), and 3) reduced the variability of individual responses for fat mass, muscle mass and time-to-exhaustion – all three variables improving in 100% of EXFS subjects.
Carbohydrate feeding during recovery alters the skeletal muscle metabolic response to repeated sessions of high-intensity interval exercise in humans.
Exercise training under conditions of reduced carbohydrate (CHO) availability has been reported to augment gains in skeletal muscle oxidative capacity; however, the underlying mechanisms are unclear. We examined the effect of manipulating CHO intake on the acute metabolic response to high-intensity interval exercise, including signaling cascades linked to mitochondrial biogenesis. Ten men performed two trials in random order separated by >or=1 wk. Each trial consisted of a morning (AM) and afternoon (PM) training session (5 x 4 min cycling at approximately 90-95% of heart rate reserve) separated by 3 h of recovery during which subjects ingested a high-CHO drink (HI-HI) or nonenergetic placebo (HI-LO) before PM exercise. Biopsies (vastus lateralis) revealed that muscle phosphocreatine and ATP content were similar after AM exercise but decreased to a greater extent during PM exercise in HI-LO vs. HI-HI. Phosphorylation of p38 mitogen-activated protein kinase (MAPK) and AMP-activated protein kinase (AMPK) increased approximately 4-fold and 2-fold, respectively, during AM exercise with no difference between conditions. After PM exercise, p38 MAPK phosphorylation was higher in HI-LO vs. HI-HI, whereas AMPK was not different between conditions. Peroxisome proliferator-activated receptor gamma coactivator 1-alpha (PGC-1 alpha) gene expression increased approximately 8-fold during recovery from AM exercise and remained elevated during PM exercise with no differences between conditions. Cytochrome oxidase subunit 4 (COXIV) mRNA was also elevated 3 h after AM exercise, with no difference between conditions. These data provide evidence that p38 MAPK is a nutrient-sensitive signaling molecule that could be involved in the altered skeletal muscle adaptive response reported after exercise training under conditions of restricted CHO intake, but further research is required to confirm this hypothesis.
Increased p70s6k phosphorylation during intake of a protein-carbohydrate drink following resistance exercise in the fasted state.
The present study aimed at comparing the responses of myogenic regulatory factors and signaling pathways involved in muscle protein synthesis after a resistance training session performed in either the fasted or fed state. According to a randomized crossover study design, six young male subjects participated in two experimental sessions separated by 3 weeks. In each session, they performed a standardized resistance training. After the sessions, they received during a 4-h recovery period 6 ml/kg b.w. h of a solution containing carbohydrates (50 g/l), protein hydrolysate (33 g/l), and leucine (16.6 g/l). On one occasion, the resistance exercise session was performed after the intake of a carbohydrate-rich breakfast (B), whereas in the other session they remained fasted (F). Needle biopsies from m. vastus lateralis were obtained before (Rest), and 1 h (+1h) and 4 h (+4h) after exercise. Myogenin, MRF4, and MyoD1 mRNA contents were determined by RT-PCR. Phosphorylation of PKB (protein kinase B), GSK3, p70(s6k) (p70 ribosomal S6 kinase), eIF2B, eEF2 (eukaryotic elongation factor 2), ERK1/2, and p38 was measured via western blotting. Compared with F, the pre-exercise phosphorylation states of PKB and p70(s6k) were higher in B, whereas those of eIF2B and eEF2 were lower. During recovery, the phosphorylation state of p70(s6k) was lower in B than in F (p = 0.02). There were no differences in basal mRNA contents between B and F. However, compared with F at +1h, MyoD1 and MRF4 mRNA contents were lower in B (p < 0.05). Our results indicate that prior fasting may stimulate the intramyocellular anabolic response to ingestion of a carbohydrate/protein/leucine mixture following a heavy resistance training session.
Twitter でフォローしていたアカウントが興味深い論文を紹介してくれていた.
Carbohydrate restriction: Friend or foe of resistance-based exercise performance?
It is commonly accepted that adequate carbohydrate availability is necessary for optimal endurance performance. However, for strength- and physique-based athletes, sports nutrition research and recommendations have focused on protein ingestion, with far less attention given to carbohydrates. Varying resistance exercise protocols, such as differences in intensity, volume, and intraset rest prescriptions between strength-training and physique-training goals elicit different metabolic responses, which may necessitate different carbohydrate needs. The results of several acute and chronic training studies suggest that although severe carbohydrate restriction may not impair strength adaptations during a resistance training program, consuming an adequate amount of carbohydrate in the days leading up to testing may enhance maximal strength and strength–endurance performance. Although several molecular studies demonstrate no additive increases in postexercise mammalian target of rapamycin 1 phosphorylation with carbohydrate and protein compared with protein ingestion alone, the effects of chronic resistance training with carbohydrate restriction on muscle hypertrophy are conflicting and require further research to determine a minimal carbohydrate threshold necessary to optimize muscle hypertrophy. This review summarizes the current knowledge regarding carbohydrate availability and resistance training outcomes and poses new research questions that will better help guide carbohydrate recommendations for strength and physique athletes. In addition, given that success in physique sports is based on subjective appearance, and not objective physical performance, we also review the effects of subchronic carbohydrate ingestion during contest preparation on aesthetic appearance.
残念ながら,この論文は公開後日が浅いこともあって全文を先程のルートで公開してくれている訳ではなかった.アカウント取得の時点でつまづいている.
この記事の最初に紹介した論文も実はいい線行っている.前回の減量に関する記事に紹介したほうがよかったかも知れない.これから精読に入ろう.読み込めたらまた紹介する.
追記
炭水化物または蛋白質,筋トレ,系統的レビュー,メタ解析から糖尿病と癌を削り取った検索式は ((((((protein) OR carbohydrate) AND strength training) AND systematic review) AND meta analysis) NOT diabetes) NOT cancer となる.この検索結果は 20 件.これまで見てきた論文が半分近くある.
減量に関する論文検索
今,減量の仕上げにかかっているところである.巷には減量に関するノウハウが溢れているが,アカデミックな裏付けが欲しいと考え,文献検索を行った.
“減量に関する論文検索” の続きを読む自分の背中を見たい?そんなあなたにCamera Plusを
筋トレをしていて,「自分の背中を見たい.それもリアルタイムで」,そう思ったことのある人は俺だけではないはずだ.今回は 120 円でそんな願いを叶えよう.
“自分の背中を見たい?そんなあなたにCamera Plusを” の続きを読む