text:
This film compilation is available to borrow from various Hampshire Libraries. Search the library catalogue to see which Hampshire libraries hold this film. It is also available for reference only at Hampshire Record Office. You can also search our online catalogue to find other archive films and sound recordings we hold relating to this topic.
A BBC South item from 1964 with commentary by John Arlott.
BBC South; 1964; B/W; sound
Local newsreel showing the traditional procession of the new Mayor of Romsey and Corporation to Romsey Abbey on Sunday 16 November 1913.
Film-maker unknown; 1913; B/W; silent
A selection of extracts from fílms taken by Dr G H Johnson and his family, including a Pageant in the Abbey grounds, the opening of the new Romsey & District Hospital, and the introduction of mains drainage to the town.
Dr G H Johnson & family; 1931-34; B/W; silent
A professional short documentary charting the history of the two abbeys of Romsey and Mottisfont.
Columbia Pictures; 1937; B/W; sound
Amateur film footage of the Romsey Show in September 1939.
D S Cole; 1939; B/W; silent
Colour silent footage of the Queen and Prince Philip marking 350 years of Borough status for the town.
Dr P Johnson; 1957; Colour; silent
Extracts from an amateur film featuring Sir Harold Hilliers Nursery and Arboretum during the 1960s.
G Adcock; 1960s; Colour; silent


text:
Post some comments or else… Part Deux
You enjoy this site? Well, then, this requires your assistance. Good content needs good comments to keep more good content coming.
Yesterday we threatened a stock photo of a house if we didn't see more comments pronto. Today, we up the ante.
Remember this iconic image?
And if you're too young to remember it, well, you can read it, can't you?
Thought you could.
We don't think we have to spell it out, now, do we?
Fine. We'll spell it out. Post some more comments or the dog gets it.
And don't give us any crap about this dog probably being dead already since the magazine cover was from January, 1973. He's been brought back to life… in Bucharest.
This is also your Weekend Open Thread, not that that ever made any difference.

subset: commoncrawl


text:
Parents, peers and mass media: their influence on children's food behavior
Cornell Univ., 1974 - Cooking - 244 pages
From inside the book
9 pages matching questionnaires in this book
Where's the rest of this book?
Results 1-3 of 9
What people are saying - Write a review
We haven't found any reviews in the usual places.
b The Food Variables
9 other sections not shown
Common terms and phrases
advertising Alterations answer asked attitudes Birth Order bread Canada Canada's Food Guide candy causal cereal cheese Children at Levels children's food behavior coded as follows Coherence commercials consumed Cornell University correlation coefficient counsellors dependent variable different food items diversity of foods Education of Mother endogenous variable favorite foods favorite lunch food consumption food group Food Habits food preferences Food Variables foods provided foods requested Gefilte fish girls High N indicated influence items sent Kendall Tau knowledge of nutrition level of education Level of Significance magazines majority of children mass media meat Medium milk Mother's Level Needed Each Day Number of Children Number of Mothers Number of Trades Nutrition Education nutrition information nutrition knowledge path analysis path coefficients Path Model Percent of Children Polyunsaturated fats programs questionnaires receptive to food regression Response Frequency role Sanjur Sesame Street STATUTORY COLLEGE summer Table television Toronto values variety of foods Vitamin


text:
Donovan Niesen necesitaba un nuevo diseño de página web y lanzó un concurso de diseño en 99designs.
Un ganador ha sido elegido entre 41 diseños de 9 diseñadores freelance.
Hunters Rreserve - http://www.huntersreserve.com
Hunters Reserve creates wild game meat products with our customers' high standards in mind. All of our products are produced, inspected and packaged according to USDA guidelines. Our meats are naturally lean, low in cholesterol and farm raised to ensure the most tender and flavorful cuts available to our customers.
Hunters, fishers and other wild game sports enthusiasts or just those who enjoy the products of these excursions.
We need an overall template update with particular focus on the home page, product grid, product view and recipes page.
* Looking for a softer and more rustic theme. Think old wood, trees, cabins
* Live animal pictures are not a good idea when selling meat, silhouettes/shapes are OK
* Real HTML text wherever possible for search engine optimization
Home Page
* We will be removing the left and right columns currently present
* Using a large image and some text as a large feature and then smaller boxes for the main categories below, similar to http://www.swisscolony.com/
* Have some featured products
* 2-3 callout boxes (filler text OK for now)
Grid page
* http://www.huntersreserve.com/products
* Attractive image and text describing the category (filler/placeholders OK)
* Utilize the "Shop by" elements on the left-hand column and cart/comparison on the right-hand column
* Have callouts available on right-hand column
Product detail page
* http://www.huntersreserve.com/pheas…sages.html
* Spruce up cart/related products right-hand column
* Create callout for perishable items saying "Item is Perishable, can only be shipped 2nd Day Air"
* Spruce up "You may also be interested in the following products" at the bottom
Recipes page
* Recipes will be grouped by category
I will provide as much imagery as we have for inspiration. We are very open to creative ideas.


text:
Great News!
Nothing is by chance and there is no such thing as coincidence. God loves us more than I could prior see. So if you have a good use for the domain name that you were looking for, be inspired, trust your Spirit, and make a fair offer that lets us continue our work helping others. It will be warmly received!
But you are free to call Sean anytime at 815-429-3254. God bless you, thank you for being here, and make it a Great Day!


text:
True Wild Life | Mouse | The mouse is a small rodent that is spread widely throughout nearly every country. The mouse is found in all corners of the globe, including parts of Antarctica. Many people today like to keep the mouse as pets because of the small size and quiet temperament of the mouse. The mouse is also used a lot in scientific research though the mouse is not an easy animal to examine.
The mouse is often easy prey around the world for small mammals, birds and reptiles. Due to this the mouse generally does not live for much longer than a few months in the wild, mainly because the mouse is small easy prey for many mammals and birds. The mouse though has been known to get up to a few years old when kept as a pet.
Mice can be harmful pests at times, through damaging and eating crops and spreading diseases through their parasites and feces. It is because of the pest problems caused by mice, that domestic cats are thought to have been introduced into common households.
The gestation period in female mice is less than a month, and the female mouse has an average litter size of about six baby mice, although the mouse litter size is commonly higher than six. The baby mice are known as pups and these mice pups are born with no hair and with their eyes and ears closed. Mouse babies are weaned when they are around three weeks old. There are nearly 40 different known species of mouse found throughout the world. The different mouse species range in size and colour that is generally dependent on their environment.


text:
Two weeks after the quick KL trip in June, I went back to Malaysia again. This time I went for my PADI Open Water Certification with my friends AP and Melvin. We managed to get a really sweet deal with Simply Scuba for only S$365 at the diving expo earlier that year! Their SSI Certification is even cheaper, but since our other friends all have PADI we decided to make things less complicated and got the same thing.
Getting to Tioman was quite the journey. Friday night after work, we took a 6-hour night bus to Mersing. We arrived at Mersing around 1-2AM and resumed our journey with another 3-hour night ride on the jetty. I was fully asleep throughout the jetty ride (I'm talented at catching some Z's no matter the situation), but AP and M went up to the dock to see night stars and was treated a view of starry skies!
We arrived around 5am and was assigned to our respective room, and went for a quick nap before going off to our first lessons at 8am.
Our room was complete shit. I guess accommodations for diving trip is not always the best, and we didn't pay that much at all for this trip anyway, so it was alright. I consider myself not very high maintenance but I definitely was having problems with the bathroom being a bit sketch and missing tiles here and there… let's just say I was pretty ecstatic to be back in Singapore after that.
HOWEVER! We did have an awesome beach access from our room! This was the sunset view right outside our door….
AP and I went for the Open Water certification while M went off on his own to do his advanced certification. We did a total of five dives in two days and now we are a happy, certified divers :D
I found diving to be relaxing and natural. I didn't have any problems being under water and have to thank my dad for putting me in the water since I was a 6 months old baby. I guess all those swimming lessons I did when I was younger is good for something!
In one of the dives, which involved descending down via a rope, I was the first one in the water going down. This was an example of when visibility was low and we couldn't see anything beyond five feet in front of us. Our instructor had to help one of the group members who was having trouble so we were left slowly descending down by ourselves.
It was really creepy being the first one down. At some point, I looked back to AP, who was right behind me and wanted to tell her that I really can't descend more because I was scared, but then managed to tell myself to keep going. There is just something eerie being in an open space yet not being able to see anything around. It was one of our deepest dives at 18 meters down.
There was also another dive where the current was incredibly strong, that we didn't have to fin our feet to get around. Just stay still and the current will take you away. Of course, this had to be done cautiously and under supervision of an experienced diver, or else you might end up getting lost. There was actually a group of 7 divers who were lost in the sea for over 24 hours that same weekend. They were really lucky to be spotted by some Indonesian fisherman the next day.
On the way back, I tried the infamous Ramly Burger at the Mersing terminal. I wanted to see what the buzz was all about, and while yes, it was delicious, I will never touch Ramly burger again. Why? Because I got a REALLY bad diarrhea that night after getting back to Singapore. I'm just thankful it started after I'm safely in my apartment and not while I was still in Tioman, or worse… on the bus ride to Singapore -_-. I referred to this incident as "getting ramly-ed".


text:
Are you frustrated with education today—your own, your child's, or your students'? Do you sense that true reform requires more than innovative classroom technology, standardized tests, or skills training?
Then this book is for you. It presents an older tradition—the Great Tradition—of education in the West that is waiting to be heard.
Since antiquity, the Great Tradition has defined education first and foremost as the hard work of rightly ordering the human soul, helping it to love what it ought to love, and helping it to know itself and its maker. In the classical and Christian tradition, the formation of the soul in wisdom, virtue, and eloquence took precedence over all else, including instrumental training aimed at the inculcation of "useful" knowledge.
Edited by historian Richard Gamble, this acclaimed anthology reconstructs a centuries-long conversation about the goals, conditions, and ultimate value of true education. Spanning more than two millennia, from the ancient Greeks to contemporary writers, it includes substantial excerpts from more than sixty seminal writings on education. Represented here are the wisdom and insight of such figures as Xenophon, Plato, Aristotle, Seneca, Cicero, Basil, Augustine, Hugh of St. Victor, Bonaventure, Thomas Aquinas, Martin Luther, John Calvin, Erasmus, Edmund Burke, John Henry Newman, Thomas Arnold, Albert Jay Nock, Dorothy Sayers, C. S. Lewis, and Eric Voegelin.
In an unbroken chain of giving and receiving, the Great Tradition embraces the accumulated wisdom of the past and reminds us of what education really is: an initiation into a body of truth. This unique collection is designed to help parents, students, and teachers reconnect with this noble legacy, to articulate a coherent defense of the liberal arts tradition, and to do battle with the modern utilitarians and vocationalists who dominate educational theory and practice.
Additional Information
|ISI Books
|What They're Saying...
"Today we are witnessing a revolution in education manifested by growing legions of homeschooling families and new classical schools. Richard M. Gamble has done an invaluable service in assembling this rich anthology of the educational wisdom that was foolishly left behind and forgotten—wisdom that we can no longer do without. This is a book for every home library and for teachers and students alike."
"The Great Tradition provides a treasury of insights into Western education that no school leadership can afford to ignore. Something will speak to everybody with a mildly curious mind: headmasters who want help with the curriculum (Quintilian), parents who want to raise wise and virtuous children (Chrysostom), lovers of the classics (Philip Melanchthon), students setting life goals (Basil The Great), teachers who want help focusing their efforts (Aristotle), the historically curious (from Plato to C. S. Lewis), and board members setting priorities (Paul Elmer More). Every now and then someone does the world the invaluable favor of reminding us how we got here and what we've left behind. Richard M. Gamble has done so for a new generation."
"An impressive new volume of selected readings which trace the thread of education as it is woven into our cultural fabric, spanning more than 2,000 years, from the ancient Greeks to contemporary writers. . . . Gamble has delivered a rich resource for families, teachers and schools—yes, even public schools, if they would use it. Home educators are certain to find it an invaluable addition to their library."
"Masterfully edited by Gamble, [this] is a unique anthology best described in the term given by Mortimer Adler years ago—conversation. . . . If there is any hope for an educational Renaissance, especially within the liberal arts, it will have to occur with a sense of the authentic and primarily formative education exemplified by the readings in this book."
"Having Gamble's collection in hand will help readers understand the sorry state of things, and grasp how we can work to improve education at all levels. This reasonably priced treasury is recommended for all academic collections, as well as for superintendents and principals everywhere."
|Eligible for Readers Club Discount
You may also be interested in the following product(s)
The Great Books Set


text:
Realignment proposal: Folsom, Oak Ridge would join SFL
Folsom and Oak Ridge high schools, featuring powerful football programs, would join the Sierra Foothill League for the 2014-15 school year as part of the next Sac-Joaquin Section realignment, officials disclosed Monday.
Already including Granite Bay, the reigning CIF Division I football state champion, Roseville, Woodcreek, Del Oro, Rocklin and Nevada Union, section officials proposed moving Folsom and Oak Ridge into the SFL "to create a Division I foothill league."
The section also recommended giving the new SFL a fourth playoff berth in "most team sports." All schools in the SFL would compete in Division I in the playoffs except for Del Oro and "most likely" Rocklin, which would be in Division II.
Folsom won the Division II section championship this past season and lost to De La Salle in the CIF Open Division NorCal playoffs, and Oak Ridge lost to Granite Bay in the Division I final.
Also, Oakmont would move to the Division III Capital Athletic League under realignment and Valley Christian Academy would remain in the Division VII Sacramento Metro Athletic League.
The new CAL would consist of Oakmont, Casa Roble, Christian Brothers, El Camino, Placer, Sacramento and Vista del Lago. Oakmont, Casa Roble and Christian Brothers currently compete in the Division II Capital Valley Conference.
The new SMAL would be comprised of Valley Christian, Vacaville-Buckingham Charter, Cristo Rey, Faith Christian, Sacramento Adventist, Sacramento Country Day and Wilton Christian.
A final proposal is scheduled to be sent to schools for a vote in early April. The new realignment takes effect in August 2014.
The proposed realignments, analysis and issues in all divisions can be found at www.cifsjs.org. Click on "governance" and then "realignment."
Contact Bill Poindexter at email@example.com. Follow him on Twitter at BillP_RsvPT.


text:
A NEW river crossing WILL land in Thurrock, the Government has confirmed.
Despite pleas from Thurrock's MPs, ministers have refused to look again at options D and E, which would link Kent with Canvey Island or Southend.
At a debate in Westminster, Thurrock MP Jackie Doyle-Price revealed a new crossing next to the current Thurrock to Dartford one - option A - would fail to deal with the borough's clogged up road network and could lead to the closure of Vopak's vital West Thurrock fuel terminal - causing problems for the regions fuel supply.
She added option C, landing between Tilbury Fort and Coalhouse Fort in East Tilbury, would also add to traffic woes on the A13.
Ms Doyle-Price criticised Thurrock Council and Essex County Council for their lack of vision, saying "poor leadership" had "let residents down".
Stephen Metcalfe, the South Basildon and East Thurrock MP, said options D and E could help the growth of Southend Airport.
But transport minister Robert Goodwill, said options D and E would not be revisited. The government is taking a closer look at concerns over options A and C, such as further improvements which may be required on the M25 and A13.


text:
DTFP needed a new logo design and created a contest on 99designs.
A winner was selected from 42 designs submitted by 12 freelance designers.
Downtown Food Pantry
We are a Christian supported food pantry devoted to helping the hungry of our small rural community. In two years we have experienced tremendous growth moving from a small classroom to a new 8,700 square foot building. We would like a more polished professional image to increase awareness in the community so we will be able to attract additional volunteers and philanthropic giving.
Our target audience is anyone who desires to help the hungry in our community such as other churches, community organizations or individuals. We are always seeking volunteers to work in our pantry and we are always in need of financial support.
Include some representation of a Christian symbol such as a shepherd, angel or cross
We want to show that we are compassionate, kind, and treat our clients with dignity and respect.
We would like a logo that shows well in both black and white as well as color.
Find out how a design contest works or learn more about our logo design services.


text:
The Farm Pay It Forward With Free Groceries for Strangers
Although Nashville trio the Farm are the newcomers to the country music scene, they are making an impact not only in the entertainment industry, but also in the lives of random strangers. The band recently bought the groceries of several grocery store shoppers, bringing the phrase 'be grateful' to a whole new life.
The trio visited Albany's WGNA, and after promoting their song 'Be Grateful,' they headed out to several local business, including a grocery store, where they graciously paid for the groceries of several unsuspecting shoppers.
"We're here to try and pay it forward a little bit. We have a lot of blessings in our life, and our song is about counting your blessings, so we're going to sneak into this grocery store and see if we can buy some people some groceries," band member Nick Hoffman shared. The 'Home Sweet Home' hitmakers certainly have a lot to be grateful for and excited about, as their debut album was a promise of good things to come.
After the Farm began paying it forward, other shoppers began paying it forward as well, giving each other money -- and even fortune cookies. It goes to show that random acts of kindness are contagious!


text: George Pickett (1825-1875) was a U.S. military officer and later a Confederate major general during the Civil War (1861-65). A hero of the Mexican-American War (1846-48), Pickett entered the Civil War in 1861 and served as a brigade commander at the Battles of Seven Pines and Williamsburg before being wounded at the Battle of Gaines' Mill. Pickett is best known for his participation in the Battle of Gettysburg in July 1863, when his division was decimated during a massive frontal assault that became known as "Pickett's Charge." After Gettysburg, Pickett commanded troops in North Carolina and later participated in the defense of Petersburg. Pickett's humiliating defeat at the Battle of Five Forks in April 1865 triggered a Confederate retreat that led to Robert E. Lee's surrender at Appomattox. A controversial figure during and after the Civil War, Pickett lived his later life as a farmer and insurance agent. He died in 1875 at the age of 50.


text:
After the opening Mass for the Jesuit's General Congregation and the election of the congregation officers last week, the Jesuit press office wasn't exactly rolling out reams of reports. In fact, there was nothing.
Father Jose DeVera, the press officer, and his staff were patient with repeated phone calls and gave a general idea of what the 225 congregation delegate were doing, but that's all. And an e-mail to a Jesuit friend on the inside didn't yield anything more than a teasing rebuke from Father DeVera, who found out about it.
So, until his office sent out a press release today announcing that the General Congregation had accepted the resignation of Father Peter-Hans Kolvenbach as superior general, the only thing to do was looked at the photographs taken by Jesuit Father Don Doll and surf the Internet for new entries from Jesuit delegate-bloggers. Two writing in English are Father Dave Schultenover, a professor of theology at Marquette University in Milwaukee, and Father Fernando Franco, a Basque-born member of the Jesuit's Gujarat province in India and director of the Jesuits' Social Justice Secretariat in Rome.
The rest of the week promises to be even quieter as the delegates devote Tuesday through Friday to silence, prayer and quiet conversations in preparation for the election Saturday of the society's 30th superior general.


text:
Religion, the erotic and violence are among the major subjects of Italian painter Michelangelo Merisi, also known as Caravaggio's (1571-1610) composed paintings. Using models whom he often engaged straight from the street, he employed a highly realistic and mostly unconventional way of depicting scenes from biblical stories. He painted saints with dirty soles and with blood gushing from their injured bodies, and the faces in his art include not only the young but also the old and wrinkled.
This international loan exhibition comprises 36 paintings (original works, originals ascribed to the artist and copies created during Caravaggio's lifetime).


text:
We live-blogged all the action in the stock market on Friday. For a concise rundown of the day\'s trading activity, see Market Snapshot.
- Sort by:
- Oldest
- Newest
- 9:14 am
- Trying for a higher open
- by Victor Reklaitis
- Add a Comment
Good morning.
Stock futures are pointing to a higher open for Wall Street.
They had been in the red, with the blame going to worries about President Obama authorizng airstrikes in Iraq.
But then U.S. stock futures turned positive, with some market watchers giving credit to a Russian news service's report about Russia want to de-escalate its conflict with Ukraine.
Photo credit: Reuters
- 9:18 am
- Airstrikes happening, productivity
- by Victor Reklaitis
- Add a Comment
Peter Cardillo, chief market economist at Rockwell Global Capital, said traders may have overreacted initially to yesterday's Iraq airstrike news, with the action exacerbated by light summertime trading.
He noted the S&P 500 stayed above 1,900 on Thursday, and it's managed to hold around the lower end of its trading range for the week.
"There is an appetite for stocks around this level," Cardillo told MarketWatch in a phone interview earlier this morning.
Those airstrikes have actually just taken place, but that hasn't hit stock futures much. A productivity report also beat expectations, but the market reaction was relatively muted.
- 9:27 am
- Gap gains; Zynga zapped
- by Victor Reklaitis
- Add a Comment
Gap /quotes/zigman/227242/delayed /quotes/nls/gps GPS has been gaining premarket on its better-than-expected monthly sales data.
Zynga /quotes/zigman/7720406/delayed /quotes/nls/znga ZNGA is a big loser after its disappointing quarterly report.
Read more about today's jumpiest stocks in our Movers & Shakers column.
Photo credit: Getty Images
- 9:33 am
- Add a Comment
Stocks are up slightly in the early going.
The S&P 500 is up 0.3% at 1,914.73, while the Dow is up 0.2% at 16,405.20. The Nasdaq Composite advances 0.1% to 4,339.76.
- 9:43 am
- Gap Inc. gaps higher on same-store sales
- by William Watts
- Add a Comment
Among early gainers, clothing retailer Gap Inc. jumped 5.1% leaving a, well, gap on the daily chart.
The company late Thursday reported July sales that topped estimates and offered an upbeat forecast for second-quarter earnings.
- 9:52 am
- Stocks holding gains
- by William Watts
- Add a Comment
Stocks are struggling to hold on to gains, with the Nasdaq briefly dipping into negative territory before finding its footing.
S&P 500 — up 0.2% at 1,912.99
DJIA — up 0.2% at 16,397.94
Nasdaq Composite up 0.2% at 4,342.84
- 9:57 am
- Will 'buy the dip' turn into 'sell the bounce''
- by William Watts
- Add a Comment
Will the "buy-the-dip mentality" give way to "sell the bounce?"
That will be the abiding September question in the markets, writes Bank of America Merrill Lynch chief investment strategist Michael Hartnett in a note:
Recent market weakness has ironically coincided with stronger economic news in US and China (but not in Europe); our economists believe monetary policy will remain loose in US and Europe; we nonetheless think the era of excess liquidity is coming to an end, so for "buy the dip" to continue to work US and emerging market earnings per share needs to impress, China's economic momentum needs to continue and, of course, a credit "event" must be avoided.
- 10:05 am
- Wholesale inventories rise
- by William Watts
- Add a Comment
Data on June U.S. wholesale inventories seemed to have little bearing on stocks. Inventories rose 0.3%.
- 10:21 am
- Still down for week
- by Victor Reklaitis
- Add a Comment
The 3 main indexes continue to hold modest gains, but they're still looking at a down week.
S&P 500 -0.7% for week
Dow -0.6% for week
Nasdaq -0.4% for week
The small-cap Russell 2000 is firmly in the green for the week though (+0.7%), bucking the negative trend. That's certainly a change of pace for the Russell, which is still underperforming the other indexes for 2014 to date.
- 10:35 am
- Barely higher
- by Victor Reklaitis
- Add a Comment
The S&P 500 and Dow are now barely positive after briefly dipping into the red.
It's been a choppy morning as investors keep track of global conflicts… from Iraq to Ukraine-Russia to Gaza.
Dow +0.04%
Nasdaq -0.1%
Russell 2000 +0.1%
- 10:37 am
- Big outflows
- by Victor Reklaitis
- Add a Comment
U.S. equity funds endured $16.4 billion in outflows in the week ended Wednesday, according to Lipper data.
That marked the biggest exodus from stock mutual funds and stock ETFs since the week ended Feb. 5 — six months ago.
Read more here.
Is this a great sell signal, or should investors take it with a grain of salt? MarketWatch's Bill Watts recently wrote that Citgroup strategists say big inflows or outflows are " not a useful indicator of future gains or losses. "
- 10:44 am
- Newscast: Millions more may qualify for loans
- by Anora Mahmudova
- Add a Comment
Look for economic growth to speed up for the rest of the year. MarketWatch's Ann Cates reports
- 10:55 am
- Tekmira moves closer to approval on Ebola drug
- by Anora Mahmudova
- Add a Comment
Via Russ Britt:
Shares of Tekmira Pharmaceuticals Corp. jumped by more than 21% at one point Friday after the Canadian drug maker said U.S. regulators are moving closer to approving its anti-Ebola drug for use on those infected with the deadly disease.
Tekmira said in a press release late Thursday that the U.S. Food and Drug Administrationverbally confirmed that it has modified the status of the drug TKM-Ebola to a partial clinical hold from a full clinical hold, thus enabling the potential use of the treatment.
Jointly developed with the Pentagon's medical countermeasures office, TKM-Ebola currently is in Phase 1 testing. Both U.S. and Canadian shares of Tekmira were up nearly 17% in recent action.
- 11:14 am
- War Cental live stream
- by Sue Chang
- Add a Comment
War in Gaza, Russia-Ukraine tensions and U.S. airstrikes on Iraq are some of the geopolitical risks moving the financial markets. MarketWatch has a live stream to filter the latest headlines to keep investors posted on developments from various hotspots.
- 11:37 am
- Oversold or not?
- by Anroa Mahmudova
- Add a Comment
Here is a chart with some technical analysis from Charlie Bilello or Pension Partners:
% of $SPX stocks above 50-day MA in oversold zone here but if this is a deeper correction (2010/11/12), will go lower pic.twitter.com/DmoggzNByW
— Charlie Bilello, CMT (@MktOutperform) August 8, 2014
- 11:41 am
- Weekly losses capped
- by Anroa Mahmudova
- Add a Comment
Stocks are marching higher. Today's gains are capping weekly losses for the main benchmarks:
Dow +0.48%
Nasdaq +0.3%
- 11:47 am
- Sanctions weigh on Russian economy
- by Sue Chang
- Add a Comment
Russia's economy is paying a hefty price for President Vladimir Putin's aggressive policies on Ukraine.
Sales of new cars in Russia sank 22.9% in July as real disposable incomes decline and the weak ruble inflated prices of imported cars and auto parts.
"The economy is now on track to post its weakest growth in a decade, apart from the 2009 contraction because of the global crisis, and the propensity to save among households is rising on the back of uncertainty and Western sanctions."
- 12:04 pm
- GM asks owners to park SUVs outside
- by Sue Chang
- Add a Comment
General Motors' /quotes/zigman/1466682/delayed /quotes/nls/gm GM comedy of errors continues.
The automaker is urging owners of about 189,000 recalled sport-utility vehicles to park their vehicles outside until their faulty power window switches can be replaced, according to reports.
The reason? The switches risk catching fire, even when unattended and replacement parts might not be available until October.
Affected models are 2006-2007 Chevrolet TrailBlazer, GMC Convoy, Buick Rainier, Isuzu Ascender and Saab 9-7x.
Shares of GM are up 0.8%.
- 12:45 pm
- Newscast: McDonald's sales hammered in July
- by Sue Chang
- Add a Comment
Global sales at the golden arches fell 2 and a half percent last month because of the food safety scare in China and weakness in the U.S.
- 1:01 pm
- Small-caps outperformed this week
- by Anora Mahmudova
- Add a Comment
Stocks are trading higher but are still on track for modest weekly losses. Small-cap stocks, however, defied this trend.
The Russell 2000 is up 0.5% on Friday and it's up 0.9% over the week.
- 1:13 pm
- Lox futures
- by Ben Eisen
- Add a Comment
And now for the news we've been waiting for all morning: answers to your questions about how Russian sanctions on Norwegian salmon will affect the price of your bagel and lox. MarketWatch's Victor Reklaitis reports:
"Thanks to new Russian sanctions on Norwegian salmon, prices for the fish could fall by 10% or 12% in Europe but U.S. shoppers shouldn't expect that same decrease, according to one seafood expert…
While Norwegian producers are likely to send more salmon to the U.S. now that Russia has banned their fish, that additional supply probably won't lead to lower prices in the U.S. in the next few weeks and months, he said."
- 1:25 pm
- Junk a red flag for stocks?
- by Ben Eisen
- Add a Comment
Here's one from late Thursday, in case you missed it: junk bond mutual funds and ETFs had a record $7.1 billion in outflows during the week ended Wednesday, as the market continues to experience turbulence. There have now been four straight weeks of fund outflows as the market takes a breather from its strong outperformance over the post-crisis years, per Lipper data. At right is a chart showing the drop of an ETF that tracks a high yield bond index.
With junk bonds often serving as a gauge of risk sentiment for equity investors, should stock buyers be nervous? Yahoo! Finance's Michael Santoli weighs in with a Friday column:
"The support of overly generous credit markets – with the feast on junk bonds at the center – has been maybe the best thing stocks have had going for them. Make no mistake, those markets are still flush and money is still cheap there, with so-called high-yield bonds yielding less than 6% even after this recent purge. This market needs to settle down in order for stocks to put in a reliable bottom."
- 1:28 pm
- Stocks jump
- by Ben Eisen
- Add a Comment
Stocks just made a pretty notable junk higher here, push all three major indexes higher on the week. Here's where we are:
S&P: +0.9% on the day, +0.1% on the week
Dow: +1% on day; +0.2% on week.
Nasdaq: +0.7% on day; + 0.3% on week
- 1:31 pm
- Safe haven reverse
- by Ben Eisen
- Add a Comment
The safe haven bid looks to be coming off. Treasurys sharply cut gains and gold is now lower.
- 1:36 pm
- Russia ends military exercises
- by Ben Eisen
- Add a Comment
The shift in market sentiment is being attributed to a reduction in tensions between Russia and Ukraine, with Russia's Interfax reportedly saying that Russia ended military exercises near the Ukraine border and have returned to their bases.
- 1:42 pm
- Snapping two week Dow decline?
- by Ben Eisen
- Add a Comment
With the Dow now positive on the week, it's poised to break a two-week streak of declines. A third week would make it the first such streak in 12 months, per MarketWatch's Tomi Kilgore
- 1:48 pm
- Rally in the comments section
- by Ben Eisen
- Add a Comment
Let's get some MarketWatch readers in on this conversation. Here's what's happening in the comments section:
- chuck karabin writes " This is just [a] suckers' rally. It'll look good on paper but is not going to last. There will be another leg down when it ends. You play the rally but be nimble so you don't get trapped"
- Says Ernest Terry " I can't lose in this market, just throwing darts a blue chips and cha ching no matter what the news or fundamentals are or how many fleas might be on that dog."
- Glenn Cheswick muses "Nice market action going into a weekend full of headline risks is a bullish sign."
- 1:53 pm
- Big gainers in this move higher
- by Ben Eisen
- Add a Comment
Here's what's leading the S&P 500 as we look to finish up the week on a strong note, from the Movers & Shakers Column with Sue Chang and Angela Johnson:
Nvidia Corp. /quotes/zigman/80597/delayed /quotes/nls/nvda NVDA : The chipmaker said late Thursday that second-quarter profit jumped 33%, and it released third-quarter forecasts that topped Wall Street estimates. +7.4%
Monster Beverage Corp. /quotes/zigman/8035590/delayed /quotes/nls/mnst MNST : The energy drink company late Thursday reported better-than-expected adjusted earnings of 81 cents for the second quarter. +6.2%
Gap Inc. /quotes/zigman/227242/delayed /quotes/nls/gps GPS : July retail sales were better than expected, and the clothing maker provided a rosy outlook for second-quarter results. +5.8%
- 1:56 pm
- Ross Stores pops
- by Ben Eisen
- Add a Comment
Ross Stores Inc. /quotes/zigman/77604/delayed /quotes/nls/rost ROST has a nice 3.4% pop a day after its second-quarter earnings report. It's trading at nearly $67, which is getting some buzz on Twitter. Here's one person who is pleased
Nice to see Ross Stores get some love. The shares were under $62 last month. $ROST
— Eddy Elfenbein (@EddyElfenbein) August 8, 2014
- 2:04 pm
- A decade from now
- by Ben Eisen
- Add a Comment
We know you're focused on the day's trading action, but here's some long-term perspective on the market, courtesy of Citi's Bruce Rolph:
"The next decade is likely to be different than the past three as the interest rate tailwind may become an equity market headwind. While investors and the economy have enjoyed the benefits of lower inflation since the early 1980s and commensurately more affordable debt financing capacity, the future might prove less accommodative. A number of employment data suggest the Fed may have to alter course and even the so-called 'dot chart' argues for higher rates down the line than current futures markets highlight."
Photo credit: Bloomberg
- 2:07 pm
- What do you think this pop is signaling?
- by Ben Eisen
- Add a Comment
- 2:13 pm
- Sectors leaders
- by Ben Eisen
- Add a Comment
The S&P 500 sectors that are doing the best here are: utilities and consumer discretionary.
On the utilities front, it's all bout Dominion Resources Inc. /quotes/zigman/253585/delayed /quotes/nls/d D (2.8%) and Consolidated Edison Inc. /quotes/zigman/208045/delayed /quotes/nls/ed ED (2.3%).
Within consumer discretionary, check out Gap Inc. /quotes/zigman/227242/delayed /quotes/nls/gps GPS (5.8%) and CBS Corp /quotes/zigman/393390/delayed /quotes/nls/cbs CBS (4.2%).
- 2:24 pm
- Driving the markets: global conflict
- by Ben Eisen
- Add a Comment
The latest Market Snapshot is out, so head over there for MarketWatch's story on the day's trading action. A salient quote:
"Equities are likely to trade sideways throughout August and be driven by geopolitical headline news," said Terry Sandven, chief equity strategist at U.S. Bank Wealth Management. "From a technical standpoint, it is a good time to add to positions as we do not expect a 10% correction at this point."
- 2:26 pm
- Dow's all green
- by Ben Eisen
- Add a Comment
All but two of the 30 Dow components are now in black as the blue chip index hangs onto its gains. The biggest gainers are Home Depot Inc. /quotes/zigman/229488/delayed /quotes/nls/hd HD and American Express Co. /quotes/zigman/217470/delayed /quotes/nls/axp AXP .
- 2:29 pm
- Signs of change
- by Ben Eisen
- Add a Comment
Here's a fun chart that shows just how much the shipbuilding industry has changed in the last 100 years, courtesy of The Economist:
Ahoy! Today's #Dailychart reveals how shipbuilding changed over a century http://t.co/tGt9HmUXmB pic.twitter.com/Rd4o2B44gD
— The Economist (@TheEconomist) August 8, 2014
- 2:37 pm
- Looking ahead
- by Ben Eisen
- Add a Comment
So what's on the docket for next week? Adrian Miller at GMP Securities suggests that while global warfare should remain a dominant theme, we may see a return to focus on U.S. economic growth, which was on the backburner this week:
"Assuming Russia truly de-escalates Ukraine tensions and the U.S.'s military intervention in Iraq proves limited, we expect a refocus on fundamentals that suggest a steady improvement in U.S. growth, which should see equity prices higher and corporate spreads tighter as work of the demise of the high yield market has been greatly exaggerated "
Economic reports include retail sales and business inventories on Wednesday, and the producer price index and industrial production on Friday. See MarketWatch's full economic calendar here.
- 2:42 pm
- Market timers suffer
- by Ben Eisen
- Add a Comment
MarketWatch's Mark Hulbert has a column out Friday reminding investors how difficult it is to time the market. Here's an anectore:
Consider what happened to Richard Russell, the renowned editor of the Dow Theory Letters advisory service, in the wake of his almost-perfect sell advice within a day of the bull-market top in August 1987 — two months before the worst single-day crash in U.S. history.
What happened next is telling. As the market battled back, Russell stayed out of stocks — and didn't get back in until August 1989, when the market was near the same level it had been when he issued his call to sell two years earlier.
Read Hulbert's full column here. He's not the only warning against market timing: Chuck Jaffe tells investors "You can read the headlines, just don't trade on them."
Photo credit: Getty Images
- 2:45 pm
- Index check
- by Ben Eisen
- Add a Comment
Let's do a quick station identification, errr check on the indexes as stocks trade right near their intraday highs:
S&P 500: up 18 points at 1,927.41
Dow: up 148 points at 16,515.56
Nasdaq: Up 32 points at 4,367.49.
- 2:52 pm
- "Everything in this room is eatable"
- by Ben Eisen
- Add a Comment
Zynga Inc. /quotes/zigman/7720406/delayed /quotes/nls/znga ZNGA is one of the day's big losers, currently down 5.7%. Analysts have been dropping their price targets on the stock left and right. MarketWatch's Rex Crum writes about one analyst who uses a Willy Wonky quote to describe what's happening over at the social gaming company:
"Everything in this room is eatable, even I'm eatable! But that is called cannibalism, my dear children…frowned upon in most societies."
Explaining that one is going to take a bit more space than we've got time for. Head over here to read the full piece.
- 2:55 pm
- Newscast: Global tensions ease in Ukraine
- by Anora Mahmudova
- Add a Comment
Investors react to the news from Russia's Interfax that military exercises near Ukraine have ended.
- 3:07 pm
- Ukraine trumps Iraq: Investors' 3 biggest worries
- by Anora Mahmudova
- Add a Comment
Via William Watts:
Investors on Friday proved that they've been a lot more worried about Ukraine and the potential for a deeper conflict between the West and Russia than they are about fresh U.S. military action in Iraq.
Here's a rundown of the three fears that present the biggest potential worries for investors right now:
Russian invasion of Ukraine
Cutting off Russian gas
The Middle East
- 3:17 pm
- News headlines vs S&P 500
- by Anora Mahmudova
- Add a Comment
Here is an interesting chart about the S&P 500 and news headlines:
Here you go. News coverage for 'Russia', 'Gaza' and 'Iraq' against the $SPX: http://t.co/xwNsEFtxik
— John Kicklighter (@JohnKicklighter) August 8, 2014
- 3:37 pm
- Good day for stocks
- by Anora Mahmudova
- Add a Comment
Friday is turning out to be a good day for stocks.
Both the S&P 500 and Dow are up 1%. But volumes are thin on this early-August Friday. The benchmark index still has a long way to recover last week's losses.
S&p 500 +1.05%
Dow +1%
Nasdaq +0.82%
- 3:54 pm
- Gold loses safe-haven bid
- Add a Comment
Gold futures end the week above $1,300 an ounce but lost ground in Friday's session as worries eased over Ukraine.
- 4:06 pm
- Stocks end on strong note
- by William Watts
- Add a Comment
Stocks finish the Friday session and the week on a strong note, with the S&P 500 and Dow posting their biggest one-day point and percentage gains since March 4. The major indexes all see weekly gains as Ukraine fears moved to the back burner.
S&P 500 — up 22.01 points, or 1.2%, at 1,931.59. For the week, the S&P rises 0.3%.
DJIA — up 185.66, or 1.1%, at 16,553.93. That leaves the Dow up 0.4% for the week after two consecutive weekly losses.
Nasdaq Composite — up 35.93, or 0.8%, to 4,370.90, booking a 0.4% gain for the week.


text:
THE SQL Server Blog Spot on the Web
Most tuning efforts for data-changing operations concentrate on the SELECT side of the query plan. Sometimes people will also look at important storage engine considerations like locking and transaction log throughput that can have dramatic effects. As a consequence, a number of common practices have emerged, such as avoiding large numbers of row locks and lock escalation, splitting large changes into smaller batches of a few thousand rows and combining a number of small changes into a single transaction in order to optimize log flushes.
This is all good of course, but what about the data-changing side of the query plan – the INSERT, UPDATE, DELETE or MERGE operation itself – are there any query processor considerations we should take into account? The short answer is yes. The query optimizer considers different plan options for the write-side of an I/U/D/M query, though there isn't a huge amount of T-SQL language support that allows us to affect these choices directly. Nevertheless, there are things to be aware of, and things we can look to change.
Side note: In this post I am going to use the term update (lower case) to apply to any operation that changes the state of the database (INSERT, UPDATE, DELETE and MERGE in T-SQL). This is a common practice in the literature, and is used inside SQL Server too as we will see.
First a bit of background. All query plans execute using a demand-driven iterator model, and updates are no exception. Parent operators drive child operators (to the right of the parent) to do work by asking them for a row at a time. Take the following simple AdventureWorks INSERT for example:
DECLARE @T AS TABLE (ProductID int);
INSERT @T (ProductID)
SELECT p.ProductID
FROM Production.Product AS p;
Plan execution starts at the far left, where you can think of the green T-SQL INSERT icon as representing rows returned to the client. This root node asks its immediate child operator (the Table Insert) for a row. The Table Insert requests a row from the Index Scan, which provides one. This row is inserted into the heap, and an empty row is returned to the root node (if the INSERT query contained an OUTPUT clause, the returned row would contain data). This row-by-row process continues until all source rows have been processed. Notice that the XML show plan output shows the Heap Table Insert is performed by an Update operator internally. Ok, on to the matter at hand:
Wide per-index update plans have a separate update operator for each clustered and nonclustered index. It is always possible for the optimizer to produce this type of plan; the options described later have not been (or cannot be) implemented when certain engine features are used. For example, if the update target has an indexed view defined on it, a wide update plan has to be used to maintain the indexed view. An example per-index update plan is shown below:
This plan updates the base table using a Clustered Index Delete operator. This operator may also read and output extra column values necessary to find and delete rows from nonclustered indexes. The iterative delete activity on the base table is driven by the Eager Table Spool on the top branch. The spool is eager because it stores all the rows from its input in a worktable before returning the first row to its parent operator (the Index Delete on the top branch). The effect is that all qualifying base table rows are deleted before any nonclustered index changes occur.
The spool in this plan is a common subexpression spool. It is populated once and then acts as a row source for multiple consumers. In this case, the contents of the spool are consumed first by the top-branch Index Delete, which removes index entries from one of the nonclustered indexes. When the Sequence operator switches to asking for rows from the lower branch, the spool is rewound and replays its rows for the second nonclustered index. Note that the spool contains the UNION of all columns required by nonclustered index changes.
Narrow per-row updates have a single update operator which maintains the base table (heap or clustered) and one or more nonclustered indexes. Each row arriving at the update operator updates all indexes associated with the operator before processing the next row. An example:
DECLARE @T AS TABLE (pk int PRIMARY KEY, col1 int UNIQUE, col2 int UNIQUE);
DECLARE @S AS TABLE (pk int PRIMARY KEY, col1 int, col2 int);
INSERT @T (pk, col1)
FROM @S AS s;
The execution plan viewed using SQL Sentry Plan Explorer shows the nonclustered index maintenance explicitly (hover over the Clustered Index Insert for a tooltip showing the names of the nonclustered indexes involved):
In SQL Server Management Studio, there is no information about the nonclustered index maintenance in the graphical plan or tooltips, we need to click on the update operator (Clustered Index Insert) and then check the Properties window:
This shows the clustered index and two nonclustered indexes being maintained. Because all indexes are updated for each row streaming through the update operator, this plan shape is also known as a per-row update plan.
The query optimizer uses cost-based reasoning to decide whether to update each nonclustered index separately (per-index) or as part of the base table changes (per-row). An example that updates one nonclustered index per-row, and another per-index is shown below:
CREATE TABLE #T (pk int IDENTITY NOT NULL, col1 int, col2 varchar(8000) DEFAULT '');
ALTER TABLE #T ADD CONSTRAINT PK_T PRIMARY KEY (pk);
CREATE INDEX nc1 ON #T (col1);
CREATE INDEX nc2 ON #T (col1) INCLUDE (col2);
The combination strategy can be seen with Plan Explorer (click to expand in a new tab):
The details are also displayed in the SSMS Properties window when the Clustered Index Insert operator is selected as well.
The third form of update is an optimization of the per-row update plan for very simple operations. The cost-based optimizer still emits a per-row update plan, but a rewrite is subsequently applied to collapse the reading and writing operations into a single operator:
-- Simple operations
DECLARE @T AS TABLE (pk int PRIMARY KEY, col1 int);
INSERT @T (pk, col1) VALUES (1, 1000);
UPDATE @T SET col1 = 1234 WHERE pk = 1;
DELETE @T WHERE pk = 1;
The complete execution plans (and extracts from the XML plans) are shown below:
The UPDATE and DELETE plans have been collapsed to a `Simple Update` operation, while the INSERT is simplified to a `Scalar Insert`. We can see the original optimizer output tree with trace flags 3604 and 8607:
INSERT @T (pk, col1) VALUES (1, 1000) OPTION (RECOMPILE);
UPDATE @T SET col1 = 1234 WHERE pk = 1 OPTION (RECOMPILE);
DELETE @T WHERE pk = 1 OPTION (RECOMPILE);
The trace output for the INSERT statement shown above is:
Notice the two physical operators: a constant scan (in-memory table) containing the literal values specified in the query; and a stream update operator that performs the database changes per row. All three statements produce a similar optimizer tree output (and all use a stream update). We can prevent the single-operator optimization being applied with undocumented trace flag 8758:
This exposes the expanded per-row update plans produced by the optimizer before the single-operator rewrite:
Single operator plans can be significantly more efficient than the original multiple-operator form in the right circumstances, for example if the plan is executed very frequently.
From this point forward, I'm going to use simple AdventureWorks DELETE examples, but the general points apply equally well to INSERT, UPDATE and MERGE as well. The examples will not have a complicated SELECT component, because I want to concentrate on the update side of the plan rather than the reading side.
It's worth emphasising again that per-row update plans are an optimization that is not available for every update query. The optimizer favours a per-row plan if the expected number of rows at the update operator is low. In the example below, the optimizer expects to delete 25 rows:
This plan updates the base table (a clustered index in this case) and all nonclustered indexes in sequence per row. The row source here is an ordered scan of a nonclustered index, which means rows will not generally be presented in clustered index key order to the update operator.
An unordered stream like this tends to result in random I/O (assuming physical I/O is required at all, of course). If the plan is expected to process only a small number of rows, the optimizer decides it is not worth adding extra operations to encourage sequential I/O.
If the expected number of rows is a bit larger, the optimizer may decide to build a plan that applies prefetching to one or more update operators. The basic idea is the same as ordinary prefetching (a.k.a read-ahead) for scans and range seeks. The engine looks ahead at the keys of the incoming stream and issues asynchronous IOs for pages that will be needed by the update operator soon. Prefetching helps reduce the impact of the random I/O mentioned a moment ago. An example of prefetching on the update operator is shown below for the same query and an expected cardinality of 50 rows:
The prefetching is unordered from the perspective of the clustered index. Neither SSMS nor Plan Explorer show the prefetch information prominently. In Plan Explorer, we need to have the With Unordered Prefetch optional column selected. To do this, switch to the Plan Tree tab, open the Column Chooser, and drag the column to the grid. The unordered prefetch property is ticked for the Clustered Index Delete operator in the screenshot below:
In SSMS, click on the Clustered Index Delete icon in the graphical plan, and then look in the Properties window:
If the query plan were reading from the clustered index, the read operation would issue regular read-ahead, so there would be no point prefetching from the Clustered Index Delete as well. The example below shows the expected cardinality increased to 100, where the optimizer switches from scanning the nonclustered index with unordered prefetching to scanning the clustered index. No prefetching occurs on the update operator in this plan:
Where the plan property With Unordered Prefetch is not set, it is simply omitted – it does not appear set to False as you might expect.
Where rows are expected to arrive at an update operator in non-key order, the optimizer might consider adding an explicit sort. The idea is that presenting rows in key order will encourage sequential I/O for the index pages. The optimizer weighs the cost of the sort against the expected benefits of avoiding random I/O. The execution plan below shows an example of a sort being added for this reason:
The sort is on Transaction ID, the clustering key for this table. With the incoming stream now sorted, the update operator can use ordered prefetching. The plan is still scanning the nonclustered index on the read side, so read-ahead issued by that operator does not bring in the clustered index pages needed by the update operator. Ordered prefetching tends to result in sequential I/O, compared with the mostly random I/O of unordered prefetching. The With Ordered Prefetch column is also not shown by default by Plan Explorer, so it needs to be added as we did before:
Not every update operator with ordered prefetching requires a sort. If the optimizer finds a plan that naturally presents keys in nonclustered index order, an update operator may still use ordered prefetching.
When the optimizer decides to explore a plan alternative that requires ordered input to an update operator, it will set the DML Request Sort property for that operator. Plan Explorer shows this setting in the update operator tooltip:
SSMS shows With Ordered Prefetch and DML Request Sort in the Properties window:
Sorting and ordered prefetching may also be considered for the nonclustered indexes in a per-index update plan.
This plan shows all three update operators with DML Request Sort set. The Clustered Index Delete does not require an explicit sort because rows are being read (with internal ordering guarantees) from the Clustered Index Scan. The two non-clustered indexes do require explicit sorts, however. Both nonclustered index update operators also use ordered prefetching; the clustered index update does not because the scan automatically invokes read-ahead for that index.
The next example shows that each update operator is considered separately for the various optimizations:
That plan features unordered prefetching on the Clustered Index Delete (because the row source is a scan of a nonclustered index), an explicit sort with ordered prefetching on the top branch Index Delete, and unordered prefetching on the bottom branch Index Delete.
Is the following a per-index or per-row update plan?
It appears to be a per-index plan because there are two separate update operators, but there is no blocking operator (eager spool or sort) between the two. This plan is a pipeline: each row returned from the seek will be processed first by the Clustered Index Delete and then by the Index Delete. In that sense, the both updates (clustered and nonclustered) are certainly per-row.
The important thing is not the terminology, it is being able to interpret the plan. Now we know what the various optimizations are for, we can see why the optimizer chose the plan above over the seemingly equivalent but more efficient-looking narrow plan:
The narrow plan has no prefetching. The Seek provides read-ahead for the clustered index pages, but the single non-clustered index has nothing to prefetch any pages from disk it might need. By contrast, the previous wide update plan has two update operators. The Clustered Index Delete has no prefetching for the same reason as in the narrow plan, but the Index Delete has unordered prefetching enabled.
So, although the smaller narrow plan looks like it ought to be more efficient, it might perform less well if nonclustered index pages are required from disk and unordered prefetching proves effective. On the other hand, if all required nonclustered index pages are in memory at the time the query is executed, the wide plan might perform less well since it features an extra operator and has to perform all the work associated with prefetching (even though ultimately no physical reads are issued).
You may have noticed a lack of performance numbers (I/O statistics, elapsed times and so on) in this post. There is a good reason for this. The optimizations presented here are quite dependent on SQL Server configuration and hardware. I don't want you drawing general conclusions based on the performance of the rather ordinary single SATA drive in my laptop, the 256MB of RAM I have allowed for my SQL Server 2012 instance, and some rather trivial AdventureWorks examples.
It depends, naturally.
If the data structures you are changing are very likely to be in memory, and/or if you have a very fast random I/O system, the optimizer's goal of minimizing random I/O and enhancing sequential I/O may not make much sense for you. The strategies the optimizer employs may well end up costing you much more than they save.
On the other hand, if your system has a much smaller buffer pool than database working set size, and your I/O system works very much faster with large sequential I/O than with smaller random I/O requests, you should generally find the optimizer makes reasonable choices for you, subject to the usual caveats about useful up-to-date statistics and accurate cardinality estimation, of course.
If your system fits the optimizer's model, at least to a first approximation, you will usually find that narrow update plans are best for low cardinality update operations, unordered prefetching helps a bit when more rows are involved, ordered prefetching helps more, and explicit sorts before nonclustered index updates helps most of all for the largest sets. That is the theory, anyway.
The problem I see most often is with the optimization that is supposed to help most: the explicit sort before a nonclustered index update. The idea is that sorting the input to the index update in key order promotes sequential I/O, and often it does. The problem occurs if the workspace memory allocated to the sort at execution time proves to be too small to perform the sort entirely in memory. The memory grant is fixed based on cardinality estimation and row size estimates, and may be reduced if the server is under memory pressure at the time.
In any case, however it occurs, a sort that runs out of memory spills whole sort runs to physical tempdb disk, often repeatedly. Unsurprisingly, this is not at all good for performance, and can result in queries that complete very much slower than if the sort had not been introduced at all. SQL Server reuses the general Sort operator for sorting index keys – it does not have a sort specially optimized for index updates which could make a best effort to sort within the memory allocated, but never spill to disk. Perhaps I should suggest this on Connect :)
The narrow plan optimization can cause problems where it is selected due to a low cardinality estimate, where several nonclustered indexes need to be maintained, the necessary pages are not in memory, and the I/O system is slow at random reads.
The ordered and unordered prefetch options cause problems much more rarely. For a system with all data in memory, there is a small but possibly measurable impact due to the prefetch overhead (finding pages to consider read-ahead for, checking to see if they are already in the buffer pool, and so on). Even if no asynchronous I/O is ever issued by the worker, it still spends time on the task that it could spend doing real work.
The usual answer to deal with poor execution plan choices due to a system's configuration or performance characteristics not matching the optimizer's model is to try different T-SQL syntax, and/or to try query hints. There are times when it is possible to rewrite the query to get a plan that performs better, and other times where rethinking the problem a bit can pay dividends. Various creative uses of partitioning, minimal logging, and bulk loading are possible in some cases, for example.
There are very few hints that can help with the update side of a plan that does not respond to the usual tricks, however. The two I use most often affect the optimizer's cardinality estimation - OPTION (FAST n) and a trick involving TOP and the OPTIMIZE FOR query hint. OPTION (FAST n) affects cardinality estimates in a plan by setting a final row goal, but its effects can be difficult to predict, and may not have much of an effect if the plan contains blocking operators. Anyway, the general idea is to vary the value of 'n' in the hint until the optimizer chooses the desired plan shape or optimization options as described in this post. Best of luck.
The idea with TOP is similar, but tends to work better in my experience. The trick is to declare a bigint variable with the number of rows the query should return (or a very large value such as the maximum value of a bigint if all rows are required), use that as the parameter to a TOP, and then use the OPTIMIZE FOR hint to set a value for 'n' that the optimizer should use when considering alternative plans. This option is particularly useful for encouraging a narrow plan.
Most of the examples in this post used the TOP trick in the following general form:
DECLARE @n bigint = 9223372036854775807;
DELETE TOP (@n)
FROM Production.TransactionHistory
OPTION (OPTIMIZE FOR (@n = 50));
Sure there are trace flags that affect the optimizations in this post. They are undocumented and unsupported of course, and may only work on some versions, but they can be handy to validate a performance analysis, or to generate a plan guide for a particularly crucial query. They can also be fun to play with on a personal system to explore their effects. The main ones that affect the optimizations described here are:
2332 : Force DML Request Sort (CUpdUtil::FDemandRowsSortedForPerformance)
8633: Enable prefetch (CUpdUtil::FPrefetchAllowedForDML and CPhyOp_StreamUpdate::FDoNotPrefetch)
8744 : Disable prefetch (CUpdUtil::FPrefetchAllowedForDML)
8758 : Disable rewrite to a single operator plan (CPhyOp_StreamUpdate::PqteConvert)
8790 : Force a wide update plan (CUpdUtil::PexprBuildWideUpdatePlan)
8795 : Disable DML Request Sort (CUpdUtil::FDemandRowsSortedForPerformance)
9115 : Disable prefetch (CUpdUtil::FPrefetchAllowedForDML)
These trace flags can all be manipulated using the usual DBCC commands or enabled temporarily for a particular query using the OPTION (QUERYTRACEON xxxx) hint.
The optimizer has a wide range of choices when building the writing side of an update plan. It may choose to update one or more indexes separately, or as part of the base table update. It may choose to explicitly sort rows as part of a per-index update strategy, and may elect to perform unordered or ordered prefetching as well. As usual, these decisions are made based on costs computed using the optimizer's model. This model may not always produce plans that are optimal for your hardware (and as usual the optimizer's choices are only as good as the information you give it).
If a particular update query is performance critical for you, make sure cardinality estimates are reasonably accurate. Test with alternate syntax and/or trace flags to see if an alternative plan would perform significantly better in practice. It is usually possible to use documented techniques like TOP clauses and OPTIMIZE FOR hints to produce an execution plan that performs well. Where that is not possible, more advanced tricks and techniques like plan guides may be called for.
Thanks for reading today, I hope this post was interesting and provided some new insights into update query optimization.
© 2013 Paul White – All rights reserved
email: firstname.lastname@example.com
twitter: @SQL_Kiwi
If you would like to receive an email when updates are made to this post, please register here
Subscribe to this post's comments using
"it does not have a sort specially optimized for index updates which could make a best effort to sort within the memory allocated, but never spill to disk. Perhaps I should suggest this on Connect :)"
You should. I already had that thought before you mentioned it. It looks comparably easy to implement although it probably gets closed. Hopefully it lives on in their internal bug trackers.
Thanks to you for sharing this with us. It was a pleasure reading, as always.
Thanks for an interesting read, Paul!
I do have to point out a correction, though. You present the three basic forms of update plan, but you don't mention that there are also mixed plans - plans where some indexes are updates on a per-row basis and others on a per-index basis.
This also invalidates your comment that "if the update target has an indexed view defined on it, a wide update plan is the only choice". A mixed plan is also possible. There will always be seperate operators for updating the index' clustered index (and possible nonclustered indexes built on top of that), but other indexes on the base table may be updated either per row or per index.
The more I think about it, the more I think of little complexities that might make a non-spilling sort a non-starter. I'm still thinking about it, I'll update the post if I do submit the suggestion.
3,582 words in this post and you think it needs more detail? ;c)
Yes ok, I'll add that distinction somewhere at some point.
As an aside, I see you are from the 'per row' or 'per index' school of nomenclature. Out of curiosity, how would you describe the per-index and per-row update plan? I think I have now decided to use 'wide' versus 'narrow' only, reserving 'per-index' to describe only plans with a sort or eager spool where the difference is important.
Paul: I use the terms "per-index" and "per-row" because they enable me to remember which is which. For "wide" and "narrow", I always have to think or look it up.
That also solves the issue of having a mixed plan, because I can now point to specific operators or specific indexes and say that they are updated per row or per index. The terms "narrow" and "wide", to me, only make sense in the context of an entire plan.
That's an interesting point, Hugo. I'll give it some more thought :)
Great post as always! And it just so happens to open a door for a Q that has bothered me for some time... :-)
Does SQL/SQLOS have any IO-reordering logic? For example, Unordered Prefetch would seem to result in a rapid-fire series of Async IOs that are only microseconds apart, and reordering IOs in page-order would be a "best effort" way of turning random into sequential. (Though of course, we are ultimately at the mercy of actual block order and the disk controller's ability to IO reorder).
This would also seem to benefit prefetches on NL Joins, logical-order index scans, and maybe an access method or two that I'm not thinking of?
Hi Aaron,
There's no generalized reordering for unordered prefetch, but unordered prefetch on a Nested Loops join may have the 'optimized' property set in which case a best-effort batch sort of keys is performed. As far as I know, this does not happen in any other case.
I vote with Hugo. Per-row and per-index are better terms, simply because they don't require an additional mental look-up. We need to optimize even the queries that run in our own heads. :-)
Thanks Mark, I've updated the main text to a form I'm comfortable with and at least partly based on the feedback.


text:
RoyalDude wrote:ODB wrote:Or you could "man up" and admit what all this Italian hate speech has really been about. You're flaming RoyalDude on every board on this site. Why not come out and go after RD straight on instead of attacking Italians as a whole? If you did you would likely (not a guarantee though) not look like suck a total moron because as ukcanuck said, you don't know shit about Italy in particular and Italians in genera!RoyalDude wrote: Hey dude, seriously the Christians can dish it out with the best of them, ie Doc Strangelove the king of racial joking but for some reason, when you say something about the Christians they get their panties in a bunch. Man up, UK, all religions get dished, the jews, the catholics, muslims etc., it's about fucking time the hillbilly Anglo Saxon inbreeding Christians suck it up and take it as well, if not, then stop fucking dishing it about other religions and races. Or in other words, 'Practice what ya Preach for christ sakes'
So just get to it already...
Or better yet, get OVER it already!
Reale amico, si dovrebbe guardare quello che dici figlio di puttana. non si sa mai quando si parla di un vero italiano


text:
LAW & ORDER: CRIMINAL INTENT, produced by Wolf Films and Universal Cable Productions, created and executive produced by Emmy Award-winning producer Dick Wolf, was developed by René Balcer. Shot entirely in and around New York City, the third installment of the "Law & Order" franchise takes viewers deep into the minds of its criminals while following the intense psychological approaches the Major Case Squad uses to solve its crimes. The plot revolves around Detectives Robert Goren (Vincent D'Onofrio, "Men In Black") and Alexandra Eames (Kathryn Erbe, "Oz").
LAW & ORDER: CI is a Wolf Films production in association with Universal Cable Productions.


text:
A RETIRED policeman from Alvechurch is back on dog patrol after just being fitted with a new hip.
But 67-year-old James McManus has not rejoined the force, where he worked for 30 years, but has resumed his role as a volunteer with The Dogs Trust helping to prepare dogs for a new home.
Mr McManus began working with the trust in 2012 but had to hang up his lead when the pain in his hip put a stop to him walking long distances or controlling larger dogs.
Now, following a hip replacement carried out by orthopaedic surgeon Andrew Pearson at Birmingham's BMI Priory Hospital, Mr McManus is back in his stride and preparing to help rehabilitate more dogs now in care at the trust's Evesham centre.
He said: "Previously I looked after problem dogs, trying to cure their bad habits, but you need to be at full strength to do that.
"I was struggling to walk any distance at all and, with some of the bigger dogs, you have to be sure you can control them on the leash when you are out with them.
"It's great to be able to get involved again and I am just about to take on a Doberman that is in need of some special care and attention. It is always a challenge but it is very rewarding."
Mr McManus, who was a detective sergeant by the time he retired, first felt pain in his hip while swimming on holiday. From then on the pain gradually got worse until it became difficult to exercise at all and he was losing sleep.
"I was unable to drive for any length of time and I even developed a limp," he said. I was covered by the Police Healthcare Scheme so I finally decided to get something done about it."
Surgeon Mr Pearson said: "James, like so many people of his age, just struggled on at first but in the end his quality of life became badly affected and only an operation was going to give him his mobility back.
"Keeping fit and on the move is an essential part of maintaining good all-round health so it is important that anyone suffering from any joint pains should see their doctor as soon as possible."
Mr McManue added: "The operation went really well and it's great to be out and about again. I'm now pain free and on the road to full fitness. I'm going to be doing a lot of work with The Dogs Trust in the years to come."


text:
It's the last day of Sarah's Best of 2011 blogfest. Today's topic is the five books we're most looking forward to in 2012. This is hard. I didn't expect it to be this hard. There are a ton of books I'm looking forward to next year. I have several friends with books (debuts or otherwise) coming out next year, and I'm excited about all of them. Plus there are millions of other books coming out that sound awesome, too. And sequels to books I enjoyed. So it was hard, and I changed my mind a lot when writing this list, but these are my top five choices at the moment I wrote this post. And since some of them don't have revealed covers yet, I'm going to not post pictures with this post.
Wanderlove by Kirsten Hubbard. I've already read this. And seen the illustrations. But I am so excited to get an actual, physical copy of this book with the drawings in it. It is going to be beyond awesome.
Insurgent by Veronica Roth. So much happened at the end of Divergent. How could I not be anxiously awaiting the sequel?
Daughter of Smoke and Bone sequel by Laini Taylor. Well DoS&B was on all my lists that it could possibly be on this week, so yeah. I'm just about dying for the next book.
Crewel by Gennifer Albin. I have wanted to read this since I first saw it on PM. It sounds so. awesome.
Wrong Side of Dead by Kelly Meding. I had to pick one that wasn't YA, didn't I? It's hard for me to find adult urban fantasy series that I want to stick with book after book, but I'm really enjoying this series.


text:
2013 Lake Michigan One Design Championships
Please pass this on to other Flying Scot sailors. We hope to see the Flying Scots at the regatta this year. This race is becoming the Midwest's largest annual one-design regatta.
Notice of Race is attached below.
07/20/13 - 07/21/13
Milwaukee Community Sailing Center
1450 N. Lincoln Memorial DriveMilwaukee, WI 53202
United States
See map: Google Maps


text:
Great bursts of idealism ripple through "Motor City Rising," the cable series that runs on the first three Fridays in June. You'll find even more optimism talking to some of the people involved. I met some of them in Detroit (logically enough) and others in Los Angeles; here's the story I sent to papers:
By MIKE HUGHES
Nina Friday's first notion of Detroit
was searing. "I thought it was almost post-apocalyptic," she


text:
NEW YORK -- If you want to find beauty and meaning in life, it's probably a good idea to stop looking for it in your mirror.
Bertolt Brecht's first full-length play "Baal," written in 1918 when Brecht was a 20-year-old university student, was a nightmarish expressionist drama about a dissolute poet-musician seeking inspiration through sex and drugs.
The New Group's modern-day production, "Clive," set in the 1990s and directed by and starring Ethan Hawke, opened Thursday off-Broadway at Theatre Row. Visually interesting and well-acted, the dark play tells a tragic story with brittle, noirish humor and mockery.
A series of often-mysogynistic scenes crash past in fragments, featuring Hawke as antihero rock musician Clive. "Any story that can be understood is just a badly told story," says one character blithely, which helps explain the disjointed misadventures of Clive inventively staged by Hawke.
Playwright Jonathan Marc Sherman, who also performs a few roles and plays the piano, claims in a production note that he used the 1922 German version of Brecht's work via a Google translation. A funny idea but, one hopes, not completely true.
For a portrait of debauched self-indulgence, Hawke has well-cast himself, featuring a wild-haired, punk-rock appearance and manic grin. Clive is allegedly undertaking a search for beauty and meaning in life, but he's conducting it via complete self-gratification and abandon, primarily by seducing a series of pretty young women and then discarding them like so much trash.
Hawke succeeds at conveying his character's combination of childlike selfishness combined with adult cruelty, as Clive's boozing and drugging and lust and treachery send him into a downward spiral of deterioration. While Clive does many despicable things, Hawke also makes him magnetic and at times almost sympathetic. Increasingly despairing, Clive observes, "I always believed in myself but I fear I'm becoming an atheist."
Brooks Ashmanskas brings a special zest to his roles, which include a cuckold, a showy landlord, a priest (so Clive can mock God) and others. Vincent D'Onofrio gives a solid, appealing performance as Clive's friend Doc. True to form, Clive eventually screws Doc over, too, as he degenerates into homicide.
If you think the many female characters all look alike, that's because three women play nearly all of them. Zoe Kazan is especially fragile, yet tenacious and sensual, in her portrayals of two virginal young girls who are stolen by Clive from his friends, then treated like dirt. Stephanie Janssen, Mahira Kakkar, Aaron Krohn and Dana Lyn ably round out the cast; Lyn also provides lovely violin and piano music.
Catherine Zuber's sexy, punk-inspired costumes and the lighting, sound and music designs, which include instruments mounted on doors, add to an atmosphere of dreaminess and dissonance that envelops this tale of Clive's self-destruction.
Derek McLane's spare set design includes a hanging, silvery curtain made of hundreds of twisted beer can pieces, which call to mind Clive's irretrievably broken soul and all the lives he shattered on his reckless road to ruin.
Read more here: http://www.miamiherald.com/2013/02/07/3222751/review-ethan-hawke-mines-noir.html#storylink=cpy
By JENNIFER FARRAR, Associated Press 2.8.13
Subscribe to .: Reelblog :. by Email


text:
30 cocktail sized sausages*
1 1/2 cups flour
1/2 cup milk
6 tablespoons butter, cut into pieces
2 1/2 teaspoons baking powder
1/2 teaspoon sugar
1 egg
1 egg, beaten
sesame seeds
Preheat oven to 350. Line two baking sheets with parchment paper. Place the flour, baking powder, salt and sugar in a food processor. Pulse until well mixed. Add the butter and pulse until it is incorporated but the mixture not totally smooth. Add the milk and egg and pulse until the dough comes together into a somewhat sticky mass. Remove to a floured surface. Knead slightly and sprinkle with additional flour if the dough seems overly sticky. Roll out into a rectangle about 1/4 inch thick, about 12x14 inches. Slice the dough into approximately 12-15 squares. Cut each square in half diagonally.
Place the triangle of dough so that when it is facing you, it looks like a pyramid. Place the sausage in the middle and fold each narrower point over the sausage in a criss cross fashion.
Place on a baking sheet. Repeat for remaining sausages, placing them about 1/4 inch apart on the baking sheet. Brush with the beaten egg and sprinkle with sesame seeds if desired. Bake 12-15 minutes or until the dough has puffed and the bottoms are golden brown. Serve hot.
Yield: 25-30
*I used a 14 oz pack of beef Hillshire Farms Lit'l Smokies (is that an embarrassing product name or what?) and had some leftover. Honestly, any small sausage would do.


text:
Formula Drift 2013 Details:
In its 10th year, Formula Drift, the world's premiere drift series, concluded its 2013 season in a hail of firsts and controversy amongst a sold out crowd at Irwindale Speedway, CA. Michael Essa in the GSR Autosport / Yokohama BMW E46 M3 became 2013 Formula Drift champion after completing the inaugural season using this chassis – 2012 champion Daigo Saito took event victory in Round 7: Final Fight. The championship crown did not come as Essa would've preferred though.
After qualifying first for the final seventh round of the series, Essa charged into a Top 32 battle against opponent Luke Pakula and his AE86 Corolla. During this fight Essa's E46 unfortunately blew its motor. Luck was on his side though as the AE86 also suffered a transmission issue and was unable to continue, which allowed Essa to gain the points and on paper move into the Top 16.
"We started off the weekend 15 points ahead but that was not enough of a lead to lock anything down so I knew I had to lay it down in qualifying. I went out there and was able to do it, qualifying first and gaining another 12 points. That put us far enough ahead that even though we had a motor blow up in Top 32 and couldn't move past Top 16 we were able to sit on the sidelines to watch it unfold," said Michael Essa. He continued, offering more insight into the engine failure,
"I don't think it was the bottom end – the bottom end is solid with CP pistons and Carrillo rods. We're a privateer team with a small budget so our top end was all stock and I think we just lost a valve and a valve ate a piston and that was it."
With E46 inoperable, the points leader and his team could do nothing but sit back and watch the war path of second place Chris Forsberg in his NOS Energy Drink Nissan 370Z. The former 2009 champion would need to make podium in order to overtake Essa in points.
Tensions mounted as Forsberg lined up against reigning-champ Daigo Saito and his Achilles Tire Lexus SC430 during the Great 8 matchups. Prior to the Great 8, Forsberg's team had filed two protests citing rule infractions after the GSR Autosport /Yokohama team was allowed to advance. Series officials revoked those protests.
Following a fantastic battle between Forsberg and Saito, the judges enacted a One-More-Time tiebreaker. The two fought it out once more while cameras encircled Essa who stared powerless at the board for the results of the Forsberg/Saito battle. Saito advanced and Essa's team went wild. Saito went on to win the event after defeating Tyler McQuarrie in the Mobil 1 / GoPro Chevrolet Camaro who finished a strong second after a tough season.
"Coming into this event I wanted to prove that this season wasn't a fluke and sitting on the sideline wasn't how I wanted the event to go down, but unfortunately that is what happened tonight," said Michael Essa. "The Formula Drift championship has always been my goal and I am extremely excited. There are so many amazing drivers and teams in the Series and being able to just compete with them is an honor. We are hoping to carry this momentum into the next season and earn more wins."
We then caught up with second place Chris Forsberg for his reaction, "I'm super proud of my team for giving me the best car I've ever had and the best shot we had to win the championship this year. However, it's a real disappointment to see the championship decided over a technicality as per a disregard of clearly stated rules in the Formula Drift rulebook – rules that state if you are unable to fix your car in 5 minutes then you forfeit."
The 10th year of Formula Drift ended with a bang. Over 20,000 estimated spectators converged at Irwindale over the two-day event and with a European car taking home the top spot there is no doubt future seasons will see even more Euros on the grid.
"I think it really opens it up," said Essa on his BMW winning the 2013 championship. "The series for a long time has just been domestics and Japanese imports so showing a European car can get on the podium and even with a brand new chassis, come out here and win the series - I would be surprised if I didn't see more European cars running next year."
John Pangilinan, Account Direct of ID Agency, had this to say about the 2013 Final Fight, "This was probably the largest drifting crowd for any drift event we've ever thrown. Next year we're thinking about possibly increasing to an additional event and possibly a couple new venues, so we'll see – we'll release all the new information at Sema this year. After having a BMW win the championship with a private team I do think some European car manufacturers will take notice and hopefully they will come and support the drivers and the series."
Jim Liaw, president and co-founder of Formula Drift continued, "What a way to complete the tenth season with the biggest crowd and probably the biggest motorsport event ever in Irwindale Speedway history. We are extremely grateful for the fans, sponsors and drivers that have helped grow the series over the ten years and we look forward to many more seasons to come."
Formula 2013 Final Standings
1. Essa, Michael - GSR Autosport / Yokohama BMW M3 - 555.50 Points
2. Forsberg, Chris - NOS Energy Drink / Hankook Nissan 370Z - 538 Points
3. Saito, Daigo - Achilles Tire / Bridges Racing Lexus SC430 - 510.50 Points
4. Aasbo, Fredric - Hankook Tire Scion Racing tC - 487.50 Points
5. Gittin Jr., Vaughn - Monster Energy / Nitto Tire Ford Mustang RTR - 481.00 Points
Round 7: Final Fight Event Results
1. Saito, Daigo - Achilles Tire / Bridges Racing Lexus SC430 - First Place
2. McQuarrie, Tyler - Mobil 1 / GoPro Chevrolet Camaro - Second Place
3. Wang, Forrest - Get Nuts Lab / Achilles Nissan 240SX - Third Place
Manufacturers Championship Final Standings
1. Lexus - 975.50 Points
2. Nissan - 912.50 Points
3. Ford - 906.00 Points
4. Scion - 866.50 Points
5. BMW - 846.00 Points
Tire Final Championship Standings
1. Hankook - 1053.50 Points
2. Falken - 1008 Points
3. Achilles - 973.25 Points
4. Nitto - 834.50 Points
5. Yokohama - 788 Points


text:
Explosive 1.4B Labels
All our Hazard Warning Diamonds are laminated and produced on a Polypropylene material. The base material we use conforms with B.S 5609:1986 which is perfect for transport by Road, Rail, Air and Sea. Our Hazard Warning diamonds fully comply with the UN ADR, RID IMDG/IMO, ADN & ICAO/IATA requirements.
They have the following main properties:
Excellent Weather Resistance
Excellent Chemical Resistance
Excellent Abrasion Resistance
Marine Grade Adhesive


text: The last iPhone review is up from Kevin of CrackBerry.com. It's a well-written review of the iPhone and he sides with me against Dieter that the iPhone is a smartphone, big ups there. It has some catching up to do, to be sure, but that's to be expected for a device that hasn't even been out 6 months yet. It sounds to me like he's been thinking about purchasing one. Kevin names the iPhone the champ of entertainment, and wonders why they didn't call it the iGadget -- the phone is treated as just another application of the phone. It's an interesting point, one I'll be addressing later with my triumphant "return to the iPhone" article.


text:
I returned a book to the library because it smelled bad. Whoever borrowed the book before me had, it seemed, smoked twelve packs of cigarettes while reading it, then rubbed the book into his or her armpits, and maybe some other areas. I didn't want to think about it. (Liar! I wanted to know exactly what happened to this book. Not only did I sniff at it for far too long, I also invited others to smell it. Strangely, no one really wanted to.) The book, incidentally, was "Bel Canto," by Ann Patchett. Not "Smell this!: Inventing New and Puzzling Odors Using Your Very Own Body." It isn't the sort of novel I would imagine might attract a reader who's vehemently anti-shower. But nonetheless.
So I returned the book. I couldn't very well drop it into the drop-off box, because 1) it would infect all the other books with its funk, and 2) the library would think I am responsible. The library is judging, always judging. The librarians get together at the end of the day and mock my book-borrowing choices. Yeah, that's right, just mine. I know how these things go.
I handed the book to the librarian and explained the deal with the book. "This book has an odor," I said, "and if you'll smell me you'll know that the odor did not originate from me. I smell of lavender, with notes of vanilla, while this reeks of unwholesomeness and the grave."
Let me try that again. "Hi, this book smells," I told the librarian. She held the book between two fingers and nodded, tossing it into a bin. The smelly-book bin? "It happens all the time," she said. "I've seen much worse."
"Like what?" I asked her, but she only shook her head. So I'm pretty sure that what she meant is that people poop in books. I'm guessing, here, but I also know I'm right, and that it happens all the time.
In conclusion, smell your books before borrowing them. Maybe shake them out a bit. You'll thank me later.


text:
Shiva is a dedicated smoke shop with decades of combined knowledge to make sure that you get the best possible bongs currently on the market. From Dabbing to Silicone bongs we have something for each and every smoker and prices to match starting from as little as ã9.99.
112 products


text:
Note: This simple and healthy snack is designed especially for kids to make on their own.
Prep time: about 1 to 2 hours
Serves: 3 to 4
Serving size: 1 pop
Nutritional analysis (per serving):
127 calories
5 g protein
2 g fat
21 g carbohydrate
0 g fiber
7 mg cholesterol
73 mg sodium
262 mg calcium
0 mg iron
Nutritional analysis may vary depending on ingredient brands used.
If you like, you can make this recipe using plastic ice-pop molds instead of the paper cups and popsicle sticks.
For a cool-looking snack, fill your cups only halfway with one flavor of yogurt in Step 1. Follow Steps 2, 3, and 4. Remove your pops from the freezer, take off the plastic wrap, and spoon in another flavor of yogurt that's a different color. Put the plastic wrap back on and freeze once more. When your pops are frozen, you'll have two-colored treats!
Reviewed by: Allison Brinkley, RD, LD/N, CNSC
Date Reviewed: 04-11-2015


text:
THAT is hauling ASS!!!BudhaNl wrote:Vestas just came in at 59.23 knot average (not confirmed yet), so the kiters have their work cut out!
Amazing !ronnie wrote:The new Top Dawg's
59.23 knots run
Yeah. It would seem there is still huge unrealized potential in this design - just a matter of balancing the aerodynamics so the thing stays on the water.Even more fantastic than top speed, is the record for the best average sailing speed to average wind speed ratio, where I believe the Vestas are way ahead of everyone else
Users browsing this forum: Bing [Bot], Google [Bot] and 8 guests


text:
A new year means new resolutions, new possibilities, and, of course, a new BlackBerry Fan of the Month (FOTM)! To go along with our recent trend of featuring fans from all over the globe, this month we're putting the spotlight on a dedicated member of Team BlackBerry who hails from Kuala Lumpur.
Our January FOTM is what you might call a "true renaissance man." He's a gadget-loving IT specialist with a passion for traveling, hiking, mountain climbing, fishing AND martial arts (phew!) who loves spending time with his wife, kids and his three cats, who he affectionately refers to as his "furry kids". When he's not out conquering the world, this family man is known to lend a helping hand to BlackBerry users all around the world in person, over BBM, on Twitter and on the BlackBerry Malaysia Facebook Page. He also has his own Facebook page dedicated to sharing BlackBerry news, providing solutions and debating different topics with other fans!
With that, I'm pleased to introduce you all to our January FOTM, Arisham (@arisham2003). Read on to learn more about his journey on Team BlackBerry.
1. How many years have you been on Team BlackBerry?
I've been on #TeamBlackBerry since 2008. Since then I've been actively helping to answer BlackBerry questions from all around the globe.
2. How many BlackBerry devices have you had in total? Could you list them all out for us?
9! BlackBerry Bold 9000, BlackBerry Bold 9700, BlackBerry Bold 9790, BlackBerry Curve 8310, BlackBerry Curve 8520, BlackBerry Curve 9300, BlackBerry Storm 9520, BlackBerry PlayBook tablet (2). My next one (No. 10) should be a BlackBerry 10 device! 🙂
3. How many BBM contacts do you have?
More than 500 contacts from around the globe.
4. What is your favorite BBM emoticon?
*Running* – It's my trademark.
5. Tell us about the best BBM you've ever received. What did it say and who was it from?
It was a BBM from a Brazilian user that reached me at 3:00am (Malaysia time). He needed help on reinstalling his OS. I guided him through until 5:00am. He then realized that it was late in the morning Malaysia time! We became good friends after that.
6. If you could BBM your BlackBerry, what would you say? How do you think your BlackBerry would respond?
I'd say, "Hi love, thank you for being loyal and for serving me sincerely." She'd probably say "I'm yours, darling!"
7. Do you have an all-time favorite BlackBerry memory? If so, we'd love to hear about it.
I found a BlackBerry in public restroom. After a few calls, I managed to find the owner of the BlackBerry Bold 9700. I then returned the BlackBerry and said, "Only a BlackBerry lover would return a BlackBerry to the owner…'cause we know how it feels to lose it!"
8. When did you start actively answering BlackBerry questions from other users on Twitter and Facebook?
I've been answering questions from many forums and Facebook Pages since 2008 and have been the resident fan that answers questions on the BlackBerry Malaysia Facebook page since the day the page launched. Twitter users can follow me at @arisham2003. I've been tweeting since February 15, 2010.
9. What made you decide to create a Facebook page dedicated to BlackBerry?
I love BlackBerry and I want all people to know news about it. With Facebook I can share my thoughts and carefully answer fans or debate certain topics. You can reach me on Facebook at www.facebook.com/powerfanarisham.
10. What was the most challenging BlackBerry-related support question you've ever resolved?
There was one user, she wasn't a technie and she had hardly used any IT devices. The BlackBerry was given to her by her good friend and her BlackBerry OS corrupted. I carefully guided her step-by-step and did my best to keep her calm. We finally made it! She treated me for a nice coffee a few days after that. 🙂
11. What is the #1 BlackBerry tip you'd like to share with fellow BlackBerry users?
You own THE BEST smartphone. In time of need, BBM! We listen.
12. We love that you're excited for the launch of BlackBerry 10. Which features are you MOST excited to try?
I love Blackberry HUB and the awesome new design paradigmI. Not to forget, the fluid virtual keyboard! Every time I go to sleep, I wish tomorrow is January 30, 2013!
13. Your Twitter bio says that you are an IT Specialist and a Martial Arts practitioner. Are those hobbies or do you do them professionally?
I'm an IT Specialist. I specialized in Document Management System prior to that. I have been a programmer for the last 15 years. I hold a Black Belt in Silat (Malay martial art). I've practiced it since I was 7 years old.
14. We also know that you're a cat lover. Could you tell us more about when you were a CFA (Cat Fanciers' Association) Ambassador?
I love to speak to people and teach them about cat care and cat shows. I also help spread the benefits of cat neutering to people. I also advise people on how to differentiate between pedigrees and long/semi-long hair cats and why people shouldn't buy cats from backyard breeders.
I've owned Maine Coons, Norwegians and Siberians. I was the first in Asia to own a complete 'Forest Cat'.
15. And finally, we just have to ask: Are you prepared to handle the fame that comes with being our Fan of the Month?
🙂 My martial art guru used to say, "Fame and Knowledge came with responsibility. Knowledge is powerful, Spread it!"
I would like to thank every man and woman who dedicated make a BlackBerry to what it is nowadays. To you guys in Inside BlackBerry for the wonderful conversation, love you! And not to forget, to all BlackBerry believers around the world…#BeBold!
Be sure to check out the other awesome members of the BlackBerry Fan of the Month club:
January – Brian (@newshutr)
February – Ivan (@IvanSHarris)
March – Jane (@photosfromabb)
April – Josh (@BBbrodyBB)
May – Mark (@AllAboutMyBB)
June – JT (@AgentBlackBerry)
July – Kimberly (@kmcooley)
August – Mike (@flash0p)
September – Jon (@nerdologist_jon)
October – Guido (@FuriousGuido)
November – Ange (@Afl2277)
Keep sharing your FOTM suggestions with us, either by leaving a comment below, tweeting to us @BlackBerry on Twitter, or posting on our Facebook page. Stay tuned – our February 2013 FOTM could be YOU!


text:
Definition of incage
v. t. - To confine in, or as in, a cage; to coop up. 2
The word "incage" uses 6 letters: A C E G I N.
No direct anagrams for incage found in this word list.
Words formed by adding one letter before or after incage (in bold), or to acegin in any order:
d - incaged l - angelic anglice galenic o - coinage p - peacing r - anergic s - ceasing incages y - gynecia
Shorter words found within incage:
ace acing acne ae ag age agin ai ain an ane ani cage cain can cane cig cine en eng gae gaen gain gan gane gen genic gie gien gin ice in na nae nag ne nice
List shorter words within incage, sorted by length
Words formed from any letters in incage, plus an optional blank or existing letter
List all words starting with incage, words containing incage or words ending with incage
All words formed from incage by changing one letter
Other words with the same letter pairs: in nc ca ag ge
Browse words starting with incage by next letter
Previous word in list: inbye
Next word in list: incaged
Some random words: bap sun einkorn ka unilateral eel weigela
This is not a dictionary, it's a word game wordfinder.
- Help and FAQ - Examples - Home
Privacy and Cookies Policy - Share - © Copyright 2004-2019 Morewords.com - 20.790mS