text:
Agent for preventing drop formulation - concentrate.
Liquid, alkaline, foaming cleaning agent, which also speeds up drying. Excellent performance when removing all kinds of dirt from alkali-resistant surfaces such as autos. Specifically formulated for use in self-service car washes and high-pressure spray-cleaners.
Effective against: Dirt ; Grease ; Oil ; Insects ; "Road-Film"
Field of use:
• Vehicle cleaning applications: where an powerful but gentle cleaning agent is required. And
Sapphire is especially useful where tap water is used, because it is formulated with wetting
agents which help prevent the formation of drops which cause spots on clean vehicles.
• Fleet cleaning operations: where it is useful to have one detergent for all types of vehicles
(e.g. autos, lorries, buses, trains)
• Self-Service car wash operations: where good results are required but the operators aren't
trained in auto cleaning.
Product benefits:
• Economical to use because it is specifically formulated for cleaning the soiling on vehicles, and
for use in pressure washing equipment.
• Highly effective with minimal concentrations because of the foaming action, which keeps
Sapphire in contact with the soil longer.
• Friendly to users and the environment due to a high degree of biodegradability.
• Optimum end results when tap water is used because the wetting agents in Sapphire help
prevent the formation of spots on the vehicle surface.
• Automotive paint compatibility tested by Institute for Paint Testing (Giesen, Germany)


text:
Dennis grew up in Germany before making the big move to Aotearoa in 2010. With Christchurch as his base of operations for quick access to the mountains he picked up his first Fujifilm X camera in 2011.
As keen tramper he enjoys exploring the New Zealand backcountry. His outdoor photography made him a regular contributor to Wilderness Magazine. In 2014 he was awarded 'New Zealand Geographic
Landscape Photographer of the Year'. Dennis still lives in Christchurch where he is following his passion and building his freelance photography business Lightforge.

subset: commoncrawl


text:
LOS ANGELES --Construction crews are on schedule and traffic tie-ups are minimal in Los Angeles, making for a successful start to Carmageddon II, the sequel to last year's shutdown of one of the nation's busiest freeways.
Transportation officials say demolition of the center span of the Mulholland Drive bridge along Interstate 405 is nearly complete Saturday afternoon. The bridge and its pillars will eventually be replaced so that the freeway can be widened.
Traffic backed up on west side surface streets and in northbound lanes of the 405 leading up to the 10-mile stretch through the Sepulveda Pass that is closed until Monday morning.
But officials say the delays aren't dramatic and most drivers have heeded warnings to stay away.
During a similar closure last year commuters avoided the freeway in droves and the shutdown was considered a success.


text:
We make handmade folding travel bikes, commuter bikes, Tandem Bikes and Cargo Bikes to fit You. all of which can be built as an E-Bike. Your size, Your choice, Your lifestyle and
The highest-quality American-Made bike available.
With 10 frame models and dozens of options, your Bike Friday is uniquely you. Our bike experts will make sure it's exactly the right bike for your adventures around the world or around the block.
You can start with a free consultation with a friendly Bike Friday expert by clicking the button below (or calling us). A Bike Friday consultant will promptly reply to serve your individual needs.
You can also explore the options online by choosing a riding style above.
You've heard of folding bicycles, but you're not quite sure what they are, or why you'd need one.
A folding bike is a bicycle designed to fold into a compact form, for easy transportation and storage. Folding bikes are very popular around the world, and especially in cities. The advantages that a folding bike has in a city over a standard bike is three-fold:
- Portability. Most trains and buses allow a folded bike to come aboard, even during peak hours. Folding bikes also fit easily into the trunk of your car or a taxi.
- Theft Prevention. You don't have to lock your bike outside, just fold it up and bring it in with you to the office, or while you're running errands.
- Small Footprint. Because these bikes fold down into a small package they can be easily tucked away in any apartment, no matter the size of your living space.
Although folding bicycles may be the best bikes for living in a city, their unique design characteristics make them great for many types of riding. Folding bikes are ideal for world travel, bike touring, and group rides.
But you may be wondering, are folding bikes slow? Do I have to pedal more on a folding bike? Are folding bikes for kids? The answer to all three questions is no. These are some common misconceptions about folding bikes, all of which are rooted in the small wheel size. Most people people assume that smaller wheels are inferior, but there are many reasons why small wheels are just as good as, if not better than, larger wheels.
Better Gearing
Small wheels don't equate to slower speeds or having to pedal more. What gives you speed when you pedal is the distance that the wheel travels for every full revolution of the pedals, this is called gear inches. It's understandable to assume that a smaller wheel would have fewer gear inches than a conventional bike because with the exact same gearing it does. But folding bikes compensate for this by using higher gear ratios. Take for instance a folding road bike like the Pocket Rocket, which uses a 53 tooth chainwheel and 9 tooth cassette cog to achieve 116 gear inches. That's nearly 10 feet of travel for every full rotation of the pedals, which is just as good, if not better, than any standard full-sized road bike.
More Efficient
Small wheels require fewer spokes to achieve the same stability as larger wheels, which actually makes them faster. Here's why: fewer spokes generate less drag than a greater number of spokes (they also weigh less) which lead to higher speeds. In fact, a small wheel is more efficient than a large wheel in speeds up to 16 mph, equally efficient in speeds from 16 to 33 mph, and is only less efficient in speeds faster than 33 mph. So, unless you're riding with Lance Armstrong, you should be able lead the pack in any group ride.
Faster Acceleration & Better Maneuverability
If you're riding in city traffic, fast acceleration and nimble steering are critical to safety. Smaller wheels accelerate faster than larger ones because they weigh less, which creates a lower moment of inertia from a full stop. So, navigating congested intersections and avoiding collisions is much easier with smaller wheels. Additionally, the smaller the wheel the more responsive it is to steering, making quick decisions easier to execute. Smaller wheels also place a higher pressure per square inch on the ground, increasing tire compliance with the road surface- this is especially helpful on wet surfaces and in tight turns.
So while small wheels can go just as fast, if not faster, than larger wheels they are also stronger. Beyond the quality of the build, what determines the strength of a wheel is the length of the spokes. The longer the spoke is the more leverage can be exerted against it. If you think about it in terms of bending a piece of rod with your bare hands, which would be easier to bend- a one inch length of rod, or a three foot length? From your own experience, you know that the longer rod is easier to bend. Well, the same is true of bicycle spokes- the longer the spoke the more flexible it is, and the more likely it is to bend or break. Not only is a stronger wheel less likely to break in an accident, it can also carry more weight. The ability to take a heavier load makes small wheeled bicycles ideal for fully loaded touring, or for carrying cargo.
Low Step Through & Low Center of Gravity
Another feature that makes small wheeled bicycles great for touring or transporting kids is the low center of gravity, which is the balance point of the bicycle. With small wheels, the balance point is naturally lower to the ground, and the lower it is to the ground the more stable it is. If you want to load your panniers full with groceries, pack all of your camping gear, or carry a couple of squirming kids, you'll really appreciate having a low center of gravity.
Equally helpful in keeping the bike balanced is the low step through that small wheels provide. Step through refers to your ability to, literally, step through the middle of the frame of the bicycle. Conventional bike frames don't allow for step through. Traditionally, they have a top tube that comes right up to the base of your seat, forcing you to tip the bike to one side and kick your leg up and over the rear of the bike. If you are doing this with a bike that's loaded with heavy bags it's very easy to get knocked over and risk injury to yourself and your bike. The low step through of a folding bike allows easy, balanced, and safe mounting and dismounting. Another advantage of the low step through is that its easier for anyone who is aging, or has mobility issues to get on and off of the bike.
Folding bikes available specifically designed for travel, leisure, commuter, or sport. We hand-build your bike in our factory in Eugene, Oregon with your lifestyle and measurements in mind.
Submit your review
I have had my PR Pro since September 2010. It is my only bike. I have put about 15,000 miles on it, almost all recreational riding with New York Cycle Club in and around New York City. The bike is and has been superb. I re-did the gearing about a year ago. I now run 50-34 chain rings x a standard 10 speed 11-28 cassette. That gives me a range of 24.2 to 90.5. gear inches on 451-23 tires and very smooth shifting. I am 76 years old and need the low gear to climb hills. A 90.5 inch high end gives me pedaling power up to about 26-27 mph which is fine for recreational riding. If I am going any faster it is because I am coasting downhill.My PR Pro is far and away the best bike I have ever ridden. I live in a high rise apartment building in Manhattan and one quality I didn't appreciate until after I had the bike is that the small wheels make it easier to move the bike around apartment building elevators and hallways and up and down subway or railroad station steps. I only fold it occasionally and travel with it about twice a year.The only change I would make would be to opt for the seat mast instead of a folding seat post, just to save a little weight. As it is, the bike weighs in at just about 20 pounds with eggbeater pedals and a Brooks saddle.My PR Pro is the ideal bike for an apartment dweller and probably for anyone.I do get a little tired explaining to people that I don't have to pedal faster to make up for the small wheels. One big advantage over 700c bikes is I can use a short cage rear derailleur, which makes for faster and smoother shifting and I don't need a triple chain ring to get a low enough climbing gear.
I've had my NWT since May 2015. It has gone on over 60+ trips to various parts of the USA and Canada with me for my work travels. Love being able to go riding every day after working exploring the areas I am in. The ability to travel with the bike as checked luggage - with no additional fees from the airlines has made my travel job rewarding. I've ridden the bike in all parts of the country from Bangor, ME to Santa Monica, CA to Edmonton, Canada to South Beach Miami, FL - it has not let me down or disappointed me. Thanks for such a great product that keeps me active when I am on the road!
Acquired the Pakit this summer and it has been a match made in heaven ever since. Of the bikes I already own, the Pakit feels great and rides smooth. I enjoy cruising the streets of New York City, and exploring all the things it has to offer. Recently I put the Pakit to the test on European Bike Tour down the Danube covering Vienna, Bratislava and Budapest over 8 days. The bike performed well in city riding, open country road, motorways, bike paths, and even crashed gravel and rocky road. Climbing was comfortable. This bike gets a lot of looks and becomes a conversation piece. The Pakit with 11 speed alfine and carbon belt drive is a winner


text:
Not sure whether to post here or chit chat.
EVERY fine issued by speed cameras could be invalid, after the Roads and Traffic Authority admitted yesterday it could not prove the authenticity of the pictures they take.The lawyer argues that the known flaws in MD5 resulted in the prosecution being unable to guarantee that the picture had not been tampered with.The case revolved around the integrity of a mathematical MD5 algorithm published on each picture and used as a security measure to prove pictures have not been doctored after they have been taken.
Now I hate speed cameras because I think their placement on motorways etcetera is simply for revenue generating (I've never had a speeding fine btw). I think they should be used in towns where a reduction in speed would have a definite effect on road safety. My joy at the prospect of these cameras being taken down was tempered as the guy being let off was speeding outside a school. The place I think speed cameras should absolutely be placed.


text:
Area News Digest
Taken from the news columns of area newspapers.
School recognized for parent involvement
COZAD—The Cozad Public Schools were awarded $1,000 for parent involvement in school programs. Attention was focused upon the recognition through Governor Dave Heineman's Education Initiative Awards Program. Cozad was honored among school districts in Nebraska with 500-999 students. Cozad was saluted for focus group programs during the lunch hour periods covering topics from academic achievements to after school programs where parents are involved.—taken from the Tri-City Trib.
Gathering of the Greens celebrates 10 years
BROKEN BOW—This marks the 10th year of a project that has become a holiday tradition for some area women. The Gathering of the Greens takes place each year at the 4-H Camp at the Halsey National Forest. The event was started by Sue Pearman with the help of then local florist, Denise Anderson, now organized with Pearman and Bethany Johnson, extension educator. The U.S. Forest Service gives the women permission to gather items in the forest for use in making wreaths and centerpieces with the only stipulation as items made cannot be sold.—taken from the Custer County Chief.
Ogallala burglary nets thief $60,000 in jewelry
OGALLALA—An estimated $60,000 in jewelry was stolen during an early morning burglary Sunday, Dec. 6, at Reichert's Jewelry at Ogallala. According to Ogallala Police Department officials, an automatic alarm signaled a burglary in progress at 3:47 a.m. in the jewelry store located on Spruce Street. The thief or thieves entered by breaking the glass of the store's front door. After officers arrived on the scene and covered both the front and back entrances, they found the burglar to already be gone. Several glass display cases were smashed where the jewelry was taken. The investigation is ongoing and police officials have no current suspects but are retrieving security cameras from the area.—taken from the Keith County News.
NCTA adjusting to state budget cuts
CURTIS—The Nebraska College of Technical Agriculture (NCTA) of Curtis is going through a few changes. Rick Mestas has been hired as the new associate dean, filling the position vacated by Kevin Mills earlier this year. Also, the anticipated $334 million shortfall in state revenue during the 2009-2011 biennium where Gov. Heineman called for a special legislative session to adjust the existing budget, will impact NCTA as well as the surrounding areas.—taken from the Frontier County Enterprise.
Hypnotist featured at Arnold's New Year's Eve
ARNOLD—Professional Hypnotist Tim Heuertz is slated to ring in the new year in Arnold with a memorable and interactive stage show sure to entertain and amaze. The Dec. 31 celebration will begin at 6 p.m. at the Arnold Community Center with a cocktail hour followed by a catered dinner and hypnosis show. A dance will follow to complete the evening. Heuertz is a certified hypnotherapist with the National Guild of Hypnotists. Advanced tickets are required to attend the entire event and are available at local businesses in Arnold.—taken from the Arnold Sentinel.
A joyful noise heard at 119-year-old church
CALLAWAY—As part of Callaway's Q-125 celebration, the 119-year-old Callaway Episcopal Church was recently opened for Christmas carolers to step back in time. Around 25 Christmas carolers gathered at the church to sing under the direction of Suzanne Wendorff. The building is slowly being restored as funds become available. Hopes are to soon return its bell to the place at the top. The bell is a cousin of the Liberty Bell, according to church history. It was cast by John Taylor and Company of Laughborogh, England, who cast the bell when the little congregation paid the money to ship it.—taken from the Callaway Courier.
Latest Headlines
- Gothenburg native releases first novel
- We all need help from a friend
- Monsanto hosts 6th annual Safety Day program
- Brady places champ and runner-up at State FCCLA
- Swedes continue conference domination
- Dancing With The Stars changes venues
- Middle-of-the-Pack Finishes For Swede Boys and Girls
- Girls Show Support for Teacher's Cancer Fight


text:
Glendale police investigate homicide
Two people in custody
Glendale police investigate homicide
Two people in custody
GLENDALE, Wis. —
Glendale police have left the scene of a death investigation at a home in the 6300 block of North Port Washington Road.
They said they have two people in custody and are not looking for anyone else.
Neighbors told WISN 12 News reporter Max Seigle that a 60-year-old man lived in the home and had been reported missing over the weekend, but that has not yet been confirmed by police.
VIDEO: Glendale police investigate person's death
The Milwaukee County Examiner's Office told WISN 12 News the death is being investigated as a homicide.
An autopsy will be performed Thursday, and police said new details are expected to be released Thursday morning.


text:
|MLB Career Stats
|February 16, 2016
|C Lou Marson assigned to Salt Lake Bees.
|February 8, 2016
|Los Angeles Angels signed free agent C Lou Marson to a minor league contract.
|June 22, 2015
|Pensacola Blue Wahoos released C Lou Marson.
|June 1, 2015
|C Lou Marson assigned to Pensacola Blue Wahoos from Billings Mustangs.
|February 5, 2015
|C Lou Marson assigned to Billings Mustangs.
|January 30, 2015
|Cincinnati Reds signed free agent C Lou Marson to a minor league contract.
|September 17, 2014
|Pensacola Blue Wahoos activated C Lou Marson from the 7-day disabled list.
|July 21, 2014
|Pensacola Blue Wahoos placed C Lou Marson on the 7-day disabled list. strained right shoulder
|July 2, 2014
|C Lou Marson assigned to Pensacola Blue Wahoos.
|May 8, 2014
|Cincinnati Reds signed free agent C Lou Marson to a minor league contract.
|March 14, 2014
|Philadelphia Phillies released C Lou Marson.
|December 18, 2013
|Philadelphia Phillies signed free agent C Lou Marson to a minor league contract and invited him to spring training.
|December 2, 2013
|C Lou Marson elected free agency.
|November 4, 2013
|Cleveland Indians activated C Lou Marson from the 60-day disabled list.
|August 4, 2013
|Cleveland Indians sent C Lou Marson on a rehab assignment to Columbus Clippers.
|July 7, 2013
|Cleveland Indians transferred C Lou Marson from the 15-day disabled list to the 60-day disabled list. right shoulder inflammation
|May 30, 2013
|Cleveland Indians sent C Lou Marson on a rehab assignment to Columbus Clippers.
|May 29, 2013
|Cleveland Indians sent C Lou Marson on a rehab assignment to Akron Aeros.
|April 28, 2013
|Cleveland Indians placed C Lou Marson on the 15-day disabled list retroactive to April 25, 2013. right shoulder inflammation
|April 24, 2013
|Cleveland Indians activated C Lou Marson from the 15-day disabled list.
|April 16, 2013
|Cleveland Indians sent C Lou Marson on a rehab assignment to Columbus Clippers.
|April 9, 2013
|Cleveland Indians placed C Lou Marson on the 15-day disabled list. Cervical neck strain.
|August 3, 2010
|Cleveland Indians recalled C Lou Marson from Columbus Clippers.
|June 11, 2010
|Cleveland Indians optioned Lou Marson to Columbus Clippers.
|September 7, 2009
|Cleveland Indians recalled Lou Marson from Columbus Clippers.
|July 30, 2009
|Lehigh Valley IronPigs traded C Lou Marson to Columbus Clippers.
|July 30, 2009
|C Lou Marson assigned to Cleveland Indians.
|May 2, 2009
|Philadelphia Phillies optioned Lou Marson to Lehigh Valley IronPigs.
|April 11, 2009
|Philadelphia Phillies recalled C Lou Marson from Lehigh Valley IronPigs.
|April 10, 2009
|Lehigh Valley IronPigs placed C Lou Marson on the reserve list.
|November 19, 2007
|C Lou Marson roster status changed by Clearwater Threshers.
Louis Glenn Marson IV… 2004 graduate of Coronado High School (AZ)… Played Little League and Babe Ruth ball…Signed by: Therron Brockish.2013
Spent almost the entire season on the DL; was limited to just 3 games at catcher...Got injured in his 1st game of the season, 4/6 at TB, after a collision at home plate with Desmond Jennings; was removed an inning later with a cervical neck strain...Was on the 15-day DL, 4/9-23; included a rehab assignment to Columbus (AAA), 4/18-21...Started at catcher on 4/24 and was placed back on the DL the very next day with shoulder soreness...Missed the remainder of the season after failed rehab assignments in May, June and August; had continued soreness in his throwing shoulder and right elbow...Was shut down for the season in mid-August.2012 Spent second consecutive full season with Cleveland, backing up Carlos Santana while improving offensively as the season went along...Made 64 starts at catcher (69 games) and made just 2 errors on the season...Season got off to a 2-for-27 (.074) start before hitting in a then career-high 8 straight games from May 24-June 7 and went on to hit in a career-high 9 straight games from June 27-July 14...From May 24 thru the end of the season he hit .250 (42-168) with 23RS and 12RBI in 58 games (hit safely in 31 of them). Enjoyed a career day on June 30 at Baltimore, going 4-for-5 with 3RS, a double, triple and RBI...Set a new career-high for hits in a game and tied his single-game career high for runs scored...Left game on 5/27 at CWS w/ mouth contusion/ laceration after getting hit by a Gavin Floyd pitch and later received stitches...Finished 10-for-77 (13%) throwing out basestealers in 2012 after throwing out 33.3% (24 of 72) last year...Lou walked 36 times and compiled an on-base pct. of .348...From July 17 thru the end of the season he hit .156 (15-96) in 35 games (21 walks). Hit .231 (27-117) with two strikes, the 20th best mark in the American League...Hit .383 (18-47) in 14 June games with 10 runs scored (1.005OPS)...Did not hit above .207 in any other month of the season...Hit .297 in the first half (.805OPS) and .163 (17-104) in the second half (.487)...Has not homered since July 18, 2011 at Minnesota (Diamond), a span of 374 plate appearances and 109 games...Hit .340 (16-47) in 16 games in the 8-spot in the lineup. 2011 Spent first full season at the Major League level and was the club's primary catcher over the second half of the season and got better as the season went along offensively....Made 74 starts at catcher (78 games) for the Indians, appearing in 38 games in the first half and 41 games in the second half... Appeared in 34 combined games in August/September...Threw out 33.3% of the baserunners attempting to steal off him (24 of 72)...Indians were 36-38 in his starts...Season-high 3 hits on May 5 at Oakland (3-5, first career 3B, RBI)...Equaled his single-game career high for hits in a game (4th time)...Hit first/only home run of the season on July 18 at Minnesota (Night)...From August 21 thru the end of the season he hit .261 (24-92) with 2 2B, 10RBI in 28 games...Hit .261 (18-69) in September with 2 2B & 7RBI in 20 games...Had a .793 OPS vs. LHP vs. a .474 OPS vs. RHP...Hit .200 (20-100) with runners on base. 2010 Spent most of the year in Cleveland and had a 37 game stint in Columbus...Led all American League catchers in throwing out runners, tossing out 33.8% (26-77) of would-be basestealers, the best ratio in the American League...Overall with Cleveland he made 81 starts at catcher (87G) and compiled a .993 (552TC, 4E) fielding %, 9th best among AL catchers...Indians were 38-43 (.469) in his starts at catcher...Was 2nd among AL catchers with 8 steals...Began the year in Cleveland and hit .191 (27-141) with 15 runs scored, 7 doubles, a HR and 12RBI in 45 games thus far in Cleveland be being optioned to AAA Columbus on June 11th...Was the Tribe's opening day catcher...Hit .240 (18-75) in May, his highest monthly average. ...At AAA Columbus he has hit .202 (25-124) with 19 runs scored, 7 doubles, a triple, 4HR and 14RBI in 37 games. Marson hit safely in 11 of his last 13 games for the Clippers, batting .295 (13-44) with 6 runs scored, 3 doubles, 2HR and 10RBI...Recalled for a second and final time on August 3 when Carlos Santana went down with a season-ending knee injury... Hit .198 (24-121) after his second recall in 42 games...Reached base via hit or walk in 18 straight games from August 27-Sept. 27...Hit .210 (13-62) in Sept/Oct. w/a HR & 8RBI in 21 games....Collected his first RBI in game No. 29 on May 9 vs. DET...Hit first career home run on June 6 at Chicago-AL, a 3-run shot off Mark Buehrle...Hit first career grand slam and collected a career-high 4RBI on Sept. 7 at the LA Angels off Francisco Rodriguez in a 6-1 win...Collected a career-high 3 doubles and equaled career-high with 3 hits on May 29 at NYY...Stole 8 bases in 9 attempts...Was 6th among AL rookies in steals (8), 6th in doubles (15) and 8th in walks (26) and was one of 5 AL rookies to hit a grand slam in 2010...Hit .286 (20-70) off LHP. 2009 Mid-season acquisition spent majority of the season at Triple A level but did appear in 21 games at the big league level between Cleveland and Philadelphia...Began the season at AAA Lehigh Valley in the International League where he hit .294 (62-211) with 32 runs scored, 13 doubles, 1 HR and 24RBI in 63 games...He appeared in 7 games with the Philadelphia Phillies early in the season (April 11-May 1) where he batted .235 (4-17) with 3 runs scored and a double...Made his Major League debut on April 16 at Washington (2-for-3, 2B) and collected his first hit off Shairon Martis...Prior to the trade he hit safely in 19 of his last 23 games at Lehigh Valley, batting .373 (28-75)..On the year at LV he threw out 22.2 % (56SB/16CS) runners attempting to steal...Assigned to the AAA Columbus roster after the July 29th trade and hit .243 (25-103) w/ 10RS, 5 2B, 3B, HR & 9RBI in 28G w/ Columbus...Combined between AAA Lehigh Valley & AAA Columbus this year he hit .277 (87-314) w/ 42RS, 18 2B, 2HR & 33RBI in 91G... Hit .338 (32-68) in July, .284 (19-67) off LHP, .276 (67-243) off RHP and .308 (45-146) with men on base at Triple A...Recalled from Columbus on Sept. 7 and made Tribe debut on Sept. 8 vs. Texas (GM1), catching former Phillies farmhand teammate Carlos Carrasco... Made 14 starts at catcher during his month long stint with Cleveland (tossed out 6 of 15 runners, 40%)...Collected a career-high 3 hits on Sept. 17 at Oakland (3-for-4, 2B, RS). Prior to the 2009 season, Marson was ranked as the 3rd best prospect in the Philadelphia organization and the 66th overall prospect in baseball by Baseball America. 2008 Winner of the Paul Owens Award as the best player in the Phillies minor league system...Spent the entire minor league season on Reading's (AA) roster...Named to the Eastern League midseason and postseason All-Star teams...Was the starting catcher for Team USA at the All-Star Futures Game, 7/13 at Yankee Stadium...Played for Team USA in the Summer Olympics and won the bronze medal (.308, 4-13, 3 BB, 3 R)...Was voted to have best strike zone judgment by Eastern League managers in a survey conducted by Baseball America...Led the EL in OBP (.433) and finished with the 2ndbest average (.314)...Had a season-high 14-game hitting streak, 5/17-31 (.442, 23-52)...Reached base safely in a season-best 26 consecutive games, 4/9-5/14, and in 40 of 41 games, 4/9-5/31...Named Phillies Minor League Player of the Month for May and Player of the Week, 4/28-5/4...Hit .313 (26-83) vs LHP and .314 (75-239) vs RHP...Hit a grand slam and had a season-high 6 RBI, 5/18 vs Akron...Threw out 36.1% of base stealers (30-83)...Had his contract purchased on 9/1...Made his 1st career start and collected his 1st ML hit (Odalis Perez), HR (Marco Estrada) and RBI, 9/28 vs WSH. 2007 Was a non-roster invitee to Phillies spring training...Played for Clearwater (A) and led the team in batting average (.288)...Set professional highs in average, runs (68), hits (113), doubles (24), HR (7), RBI (63) and walks (52)...Batted .300 (98-327) from May 4 through the remainder of the season after hitting .227 (15-66) through his first 19 games...Hit .336 (40-119) with RISP and .429 (6-14) with the bases loaded...Had 33 multi-hit games...Made only 3 errors in his final 37 games. 2006 Spent the entire season with Lakewood (A)... Led the team in triples (5)...Had a season-high 4 hits, 4/26 vs Hagerstown...Reached base safely in all but one game in July...Had a career-high 4 RBI, 8/20 vs Delmarva, and was a HR short of the cycle...Had 21 multi-hit games...Batted .354 (17-48) in his final 13 games. 2005 Spent the season with Batavia (A)...Hit .351 vs LHP... Had a season-high 3 RBI, 6/27 at Mahoning Valley. 2004 Made his pro debut with the Gulf Coast Phillies (R)...Had 9 walks in 10 games, 7/2-22...Hit .317 (20-63, 7 RBI, 13 R) in his final 20 games of the season, after starting off hitting .180 (9-50, RBI, 5 R) through his first 18 games...Hit in 7 consecutive games to finish the season, 8/19-28 (.435, 10-23, 3 RBI, 7 R)...Played in Florida Instructional League.


text:
OXM - Call of Duty is in an interesting place right now. With Black Ops 2, many expected Treyarch to take over flagship development studio duties from series creator Infinity Ward. But the new Black Ops wasn't quite the breakthrough act we hoped for, despite making dramatic changes to both single and multiplayer.
I get the impression the writer wants COD to be less COD. I mean I agree with better engine which then better AI and other stuff can come out of it but COD is like an action film. The overall story may be ridiculous but it is well told and made the campaign interesting and fun. COD is about giving you a very movie esque feeling which is why you do not get actual stealth missions. Bigger maps can be okay but COD is a twitchy shooter that is about high intensity combat which works best in small, tight corridor maps.
They should make it with an engine created from this decade, not something from 2005 or whenever it was created for CoD 3. Billion dollar game and yet they use an old crappy engine and they also don't even have dedicated servers. I never understood why Battlefield games have dedicated servers but CoD games don't.
Look at MW3, throw everything you thought was a good idea into the trash can. Look at Black Ops 2, take the strengths and fixes the broken aspects, done.
Too bad Sledgehammer is making it so that won't happen. look for another MW2 wannabe clone.
Just don't make it like a carbon copy of COD4, MW2 and MW3. People seem to love IW, but IW really just makes the same game over and over with a few additions and no changes. Sometimes, they don't even change the menus or emblems, etc.


text:
RALEIGH, N.C. (AP) — Defense lawyers for an Army general facing sexual assault charges say they plan to press his primary accuser on inconsistencies in her story.
Attorneys for Brig. Gen. Jeffrey A. Sinclair will get their chance Monday to cross-examine the female captain at the center of the closely-watched case.
The woman testified Friday that toward the end of their three year affair Sinclair twice ended arguments by unbuttoning his pants and forcing her head into his lap as she cried.
The defense says they'll show the woman is lying by presenting a trove of emails and text messages she exchanged with the general, many of them sexually explicit.
Sinclair is believed to be the highest-ranking U.S. military officer ever tried for sexual assault. He faces life in prison if found guilty.
Sorry we are not currently accepting comments on this article.


text:
|Active Listings:
|Average Price:
|Lowest Price Real Estate:
Search homes for sale directory with real estate reviews, luxury homes, condos. Find new real estate statistics, public schools or explore local community information and daily news. The real estate market is changing you need experienced real estate agents who know current market trends in the area. Compare real estate reviews, weather, golf courses, real estate & community maps. Wonderful restaurants, shops, off leash dog parks and of course people! Home buyers find appealing because of its location and great value when it comes to area real estate.
When buying real estate listing be sure to find a local agent with the market knowledge and availability to statistics, market overview, community news. Even if you think you know sometimes it can be hard to find the perfect home and whether you're looking for a quiet place to settle down, or you want to be close to downtown we've got real estate listings.


text:
Landau, Germany
About Landau
Landau, a city of over 40,000, is the main financial and cultural center in the southern Palatinate region in Germany. With its Mediterranean climate, the region is ideally suited for growing grapes and is the second-largest wine producing region in the country. Landau lies just east of the Deutsche Weinstrasse (German Wine Route) and its proximity to the French border is evident in the local cuisine and culture. The city and surrounding region offer a wealth of cultural events and activities, with the larger cities of Karlsruhe, Mannheim, Heidelberg, and Frankfurt/Main easily accessible by a short train ride.
The Program
Hobart and William Smith Colleges maintain an exchange program with the University of Koblenz- Landau in southwestern Germany. The university is comprised of 12,000 students, distributed between the two campuses located in the cities of Koblenz and Landau. This program provides HWS students the opportunity to develop German language skills while taking a variety of other courses in English alongside German students as well as other international students.
In addition to German language and culture courses (offered at all levels, from beginning to advanced), students will be able to select from a variety of English-language courses in Environmental Studies and English/American Studies. French language and culture courses are also available and Landau's location near France provides a unique opportunity for students interested in developing both German and French language skills. For a complete list of courses please visit the CGE.
Academic Focus
This program can accommodate a variety of students and is designed for those who are interested in learning more about Germany and in developing German language skills. Students in Environmental Studies, American Studies, European Studies and German Area Studies will find the program of particular interest.
This program is open to all juniors and seniors (sophomores may be considered in exceptional cases) in good academic and social standing with a minimum GPA of 3.0. In addition, students must have completed at least one semester of college-level German prior to the program and must take a German language course in Landau. Exchange opportunities depend on the availability of slots at the host institution. Due to the challenging nature of study abroad, student academic and disciplinary records will be carefully screened. Note: due to the timing of the academic calendar at the University of Koblenz- Landau, seniors participating in the spring semester will not be able to return in time for commencement on the HWS campus. The spring program runs from mid-March—July.
Students will reside in a residence hall administered by Studierendenwerk Vorderpfalz where they will live alongside German and international students. There are communal kitchen/cooking facilities so that students may prepare their own meals if they choose.
Going Abroad With the CGE
Students will be charged standard HWS tuition and fees and a $600 administrative fee. This will cover credit for a four-course semester and program orientation. Note that no room or board charge is included. Students will pay housing fees directly to the host university and either purchase or prepare their own meals. Students should bring the HWS room and board fees with them to cover these expenses (full-year students will need to plan accordingly to cover two semesters). Room costs will vary depending upon the option chosen but should range from $2100—$2500. While food expenses will vary according to individual tastes, we estimate that about $2100—$2300 should be sufficient for students who prepare their own meals. Additional expenses not covered include airfare, books, residence permit and personal expenses (laundry, entertainment, ground transportation and independent travel). We estimate airfare for this program at $1000—$1200 from the East Coast, books at $250 and residence permit at $150. It is difficult to give an accurate estimate of student expenses because student spending habits differ considerably. We would suggest a minimum of $1,500 above and beyond room and board. However, students on a tight budget should be able to manage with less. If you are concerned about finances, we strongly encourage you to talk to the CGE staff who can offer information and advice based on your specific situation. Students applying to study in Germany through CGE-sponsored programs are encouraged to apply to the Julius G. Blocker '53 Endowed Fund. Those selected as "Blocker Fellows" receive support to cover a variety of expenses related to their study abroad programs. For further information please visit the Julius G. Blocker '53 Endowed Fund website. The deadline for applications for the Blocker Fellowship is the same as the deadline for CGE program applications.
- This program is offered every semester. Note that spring applicants will be abroad for one semester while fall applicants will be abroad for the full academic year.
- Applications are available at the Center for Global Education.
- Applications are due at the CGE office on a selected date in October (for Fall programs) and March (for Spring programs). For specific date contact the CGE.
NOTE: This information is subject to change. Please see the CGE for more information.


text:
By Kay Henderson
DES MOINES (Reuters) - A group of scientists in the top U.S. grain-growing state of Iowa said on Monday that this year's harsh drought was a sign of things to come and should spur more action to prepare for the challenges of a warming climate.
"Weather varies too much and has too many drivers to attribute any particular event to a single cause like climate change, but there is a clear pattern of crop loss and property damage from increasingly frequent events such as flooding, drought and dangerous storms," said Dave Courard-Hauri, chairman of Drake University's Environmental Science and Policy Program, at a press briefing.
"We don't face a choice between our economy and the planet. The choice is between addressing the causes and effects of climate change or spending ever more money cleaning up from events like we've seen in the past several years," he said.
The top grower of U.S. corn and soybeans, the two biggest cash grain crops, Iowa is also a big hog and cattle producer. Iowa and Illinois together produce about one-third of the nation's corn and soybeans for food, feed and fuels.
The 2012 drought, the most intense in more than a half century, cut Iowa's corn output by 19 percent and soybeans by 14 percent from last year, according to government crop estimates.
Livestock and dairy producers, with less insurance protection, are being hit hardest as feed and forage prices soar, causing farmers to cull herds or go out of business.
Christopher Anderson, the assistant director of Iowa State University's climate science program, says there is "clear, statistical evidence" that extreme high temperatures are happening more often than extreme low temperatures in Iowa.
"Since 1981, the likelihood of severely wet springs has more than doubled. What was once a one-in-10-year wet spring is now occurring two to three times in every 10 years," he said. "Yet 2012 reminds us that dry summers can still happen. The 2012 July and August statewide rainfall was the lowest since 1976."
Jerald Schnoor, co-director of the University of Iowa's Center for Global and Regional Environmental Research, said state policymakers should use 2012 climate data to make new decisions, like doubling wind energy production and using methane from livestock manure and city sewage treatment plants.
"We have confidence in recent findings that climate change is real and having an impact on the Iowa economy and on our natural resources," Schnoor said.
The group issued an "Iowa Climate Statement" signed by 138 scientists at 27 Iowa colleges and universities.
"The climate likely will continue to warm due to increasing global emissions and accumulation of greenhouse gases," the statement said. "Iowa should lead innovation in reducing greenhouse gas emissions, improve resilience in agriculture and communities, and move towards greater energy efficiency and increased use of renewable energy."
(Editing By Peter Bohan and Gunna Dickson)


text:
Mechanic Street Bridge #31May 23. 2013 3:07PM
Mechanic Street
Lancaster, NH
This bridge is also known as the Israels River Bridge. At a meeting on July 19, 1862, shortly after the construction of the bridge, the citizens of Lancaster voted to instruct the selectmen to put a sign board at each end of the bridge that prohibited driving across the bridge at a pace faster than a walk.
Year of Construction: - 1862
Original Cost: - Unknown
East of U.S. Route 2 and 3 on Mechanic Street in Lancaster, spanning the Israels River.
Paddleford truss. The bridge has a length of 94'3" with a clear span of 79'4". It has an overall width of 22'10", a roadway width of 19'3", and a maximum vertical clearance of 11'8". It is posted for six tons.


text:
MSNBC Docs will shine its spotlight on human trafficking in Chicago in a new special, "Sex Slaves: Windy City."
The special airs at 9 p.m. April 7 CT as part of the investigative series, hosted by the "Today" show's Natalie Morales, that explores the tolls of human trafficking. Next to drugs, MSNBC says in a release, human trafficking is now the second largest criminal activity both in America and internationally.
From the release:
In "Sex Slaves: Windy City," producers document Cook County's Human Trafficking Task Force as they pursue the criminals that solicit young women and girls selling themselves on the streets of Chicago. Leading these efforts is State's Attorney Anita Alvarez, the Cook County Sheriff's Department and Chicago Police Department, who collaborate to identify and convict the criminals who exploit the vulnerable, including the homeless.
In one particularly heartbreaking moment, producers meet 46-year-old Carlissa, a grandmother of two whose drug addiction has led her to spend a lifetime selling herself on the streets of Chicago. Having outlived her usefulness to a pimp, she now sells herself for $20 to support her heroin addiction. Watch the clip below.
The documentary also re-acquaints viewers with a woman prostitute who was featured in a previous episode. Before she was seemingly at peace with "the life." But this time, her anger boils over as she is clearly now worn down by prostitution and worn out.
The Illinois Supreme Court also granted MSNBC unprecedented access by allowing cameras into the courtroom of a Cook County special court led by Judge Rosemary Grant Higgins where women who have been exploited are given the opportunity to rehabilitate their lives, instead of serving time.
A second clip below shows Cook County Sheriff's Department undercover investigator Chip Anderson booking a date with a young woman named "Jessica." When officers arrive, they find no money in her hotel room, and suspect Jessica isn't working--or traveling--alone.
Sex Slaves: Windy City" was produced with Santoki Productions, producer Grace Kahng. For MSNBC: Michael Rubin is Vice President, Long Form Programming, Scott Hooker is Senior Executive Producer, Tim Smith is Senior Producer, Carrie Wysocki is director of production and Elizabeth Freedman is Associate Producer.
Want more? Discuss this article and others on Show Patrol's Facebook page.


text:
Angels on Loan From Heaven
By Betsy Yung
October 31, 2012
This article was originally written on April 6, 2012.
I have been not-so-skillfully surfing the rough seas of depression these past weeks. The loss of my very best friend (for some reason that remains unexplained) has really put me off my game and cut into my heart. My moods swing between anger/hatred for how he is hurting me and acceptance/grief for the loss I feel. If you have someone ... be sure to remember how lucky you are to have them.
I guess it's not easy to be the friend of someone with HIV/AIDS. Some days I can hardly blame my best friend for abandoning me. He is healthy. He has many friends and dealing with them is fun, not painful. He has a new lady-friend who is not comfortable with me or my illness so I guess it was inevitable that he would move on. I cannot describe how much I miss him. Having someone to call when you are lonely or someone to hang out with, to laugh with, to cry with ... is so important.
There is one speck of light in my life ... his name is Charlie ... he is my own personal angel.
I have had many dogs over the years. My step-dad is a successful veterinarian so I have enjoyed the benefits of caring for animals my whole life, but Charlie is special because he was just a wee puppy when I was diagnosed and he was the only pet I was able to keep when I came home from the hospital. For four months he was the sole reason I had to get up and move around. Today he is my sunshine and usually the only one who even tries to bring a smile to my face.
Charlie has Alopecia X, a mysterious loss of hair fairly common among pure bred Pomeranians. Currently there is no known cause or cure (hence the "X"). When he was an adolescent he lost the hair on his chest and belly ... exposing his cute black nipples ... since boy-dogs don't need them, they're perfectly flush and look like they've been drawn on with a Sharpie. I started him on medication for a thyroid imbalance and the hair on his chest finally returned but this year he has lost much of the hair around his neck and back and all of the hair from his fanny so from the rear he resembles a baboon wearing furry boots. He doesn't seem to mind the cosmetic imperfection and I think he's perfect anyway.
In my travels around the Web and various blogs very much like mine -- created for the sole purpose of flushing negative thoughts in the hope of helping others as well as ourselves -- I find that pets seem to be foremost in the maintenance of our sanity and a common thread we all share, the desire to care for someone. Having that unconditional love is magical beyond description. I thank the universe every day for lending me the angel I named Charlie. I can't imagine a life without him. He is truly my very best friend now.
Hopefully I'll find a way to force myself out and eventually make a new friend, maybe. I have a tendency to isolate myself. I haven't been able to figure out why and my motivation toward changing it is just not there yet.
Trusting someone again may not come easily.
I will try to post more photos, since they add more visual effect.
Great weather today and this weekend, I'm going to try to get outdoors, that always seems to improve my mood.
Get email notifications every time this blog is updated.
Add Your Comment:
(Please note: Your name and comment will be public, and may even show up in
Internet search results. Be careful when providing personal information! Before
adding your comment, please read TheBody.com's Comment Policy.)
My Evil Hitchhiker
Betsy Yung
Just your average, hard-working, middle-aged lady living with AIDS and making the best of it.
Subscribe to Betsy's Blog:
Recent Posts:
March 11, 2013 - Awakened From a Nightmare: A Blog Entry by Betsy Yung
October 31, 2012 - Angels on Loan From Heaven: A Blog Entry by Betsy Yung
October 10, 2012 - The Root of Discontent or Maybe it's Just the Season Change: A Blog Entry by Betsy Yung
June 9, 2012 - My Treasures, Continued: A Blog Entry by Betsy Yung
June 8, 2012 - Tiptoe Through My Treasures: A Blog Entry by Betsy Yung
A Brief Disclaimer:
The opinions expressed by TheBody.com's bloggers are entirely their own, and do not necessarily reflect the views of TheBody.com itself.


text:
Diets aren't the way to go when it comes to losing weight. That's because they create temporary eating patterns — and, therefore, temporary results. Most dieters gain back any lost weight when they go back to their old eating habits.
So what's the best way to drop excess weight? Create a new normal!
Weight loss is most likely to be successful when people change their habits, replacing old, unhealthy ones with new, healthy behaviors. Here are 5 ways to make that happen:
Note: All information is for educational purposes only. For specific medical advice, diagnoses, and treatment, consult your doctor.
© 1995-
Images provided by The Nemours Foundation, iStock, Getty Images, Veer, Shutterstock, and Clipart.com.


text:
Design submitted by Peter from the UK.
The idea for this watch design was inspired by the rings of a tree which tell how old the tree was when it was cut down. This watch uses rings to count the time in a similar way.
To tell the time you push the button on the side which illuminates the rings, count the rings from the middle to tell the time. Solid rings indicate full hours, partial rings for partial hours in an intuitive manner.
The design and the interface are very simple and clutter free and would appeal to sophisticated types and tree huggers of course!


text:
CCRMA has transitioned to a login based network access system called [Chillispot], which will simplify access by allowing CCRMA users to login to the wired and wireless Guestnet network with their login name and password (subject to a usage timeout), no matter what personal computer you are using. Your wired or wireless devices will each require a lease if you intend to use both. Do not allow password caching when logging in.
Logging In
Enable your wired or wireless network device. Start your favorite web browser. If you do not already have an active lease for that device, you will be presented with a login screen like this:
Enter your CCRMA Username and Password. You will be assigned access to the CCRMA Guestnet network for that device, and you will presented with a browser window like this:
Closing this window has no effect on your lease or access. It's just for informational purposes. There is no reason to 'logout.' If your lease expires, just login again.
Your Guests
You can grant access to the network for your own non-CCRMA visitors by entering your username and password on thier machine. Be advised that you are responsible for thier appropriate use of our network resources. Do not allow password caching when logging in.


text:
Mental Health America of Illinois (MHAI) (formerly the Mental
Health Association in Illinois) is proud to partner with the Daily Herald
for the 15th year to celebrate Mental Health Month May with the
"Partnership for Mental Health Progress," a special newspaper section
designed to educate and inform the public about mental and emotional
disorders and their treatment. For the past 15 years, the Daily Heralds
"Partnership for Mental Health Progress" has set the standard for excellence
in reporting and writing about timely mental health issues. The
edition has helped inform the public, empower consumers and remind
readers about the importance of taking care of your mental health.
Mental health is an essential part of each persons overall health and
wellness. At times, we all face challenges that test us and put our mental
health at risk. When it comes to managing the day-to-day pressures of
life, building strong connections with others is a proven way to protect
your mental health and well-being.
Did you know that people with little social support experience more
severe illnesses and slower recovery than those with strong support? Or
that people who feel valued and cared for are at a reduced risk for disease?
Our message to you is to Get Connected to friends & family, to your
community and to professional help when necessary.
In this year's section, you will find information about important and
current issues impacting your mental health and well-being. You will hear
about the launch of an exciting new public awareness campaign supported
by the Illinois Department of Human Services, Division of Mental
Health & the Illinois Children's Mental Health Partnership Say It
Out Loud. The Say It Out Loud campaign promotes mental health as a
vital component of the well-being of every child and adult, and encourages
everyone in Illinois to take steps to promote good mental health in
themselves and others.
You will get an update on the progress of the social and emotional
learning (SEL) standards being implemented by the Illinois State Board of
Education and local school districts, and gain insight about the SEL goals
of helping children and adults acquire the skills to recognize and manage
emotions, develop caring and positive relationships, make responsible decisions
and deal with challenging situations appropriately and effectively.
You also will hear ideas on how to create mentally healthy work
environments, and the actions we can all take to keep our minds and
bodies young as we age. In addition, you will hear the brave stories of
those continuing to cope with the emotional trauma of the Northern
Illinois University tragedy this past February, as well as learn of the many
organizations and professionals who are connected to your community
who are devoted to promoting good mental health and working for better
care and treatment.
MHAI, the only statewide, mental health advocacy organization
concerned with the entire spectrum of mental and emotional disorders,
works hard each year to carry out our mission to promote mental health,
prevent mental illnesses, and improve care and treatment for persons
suffering from mental and emotional disorders. Since 1909, MHAI has
advocated for you, your families and your neighbors through our important
I encourage you and your families to Get
Connected this May and stay in tune with
your mental health and well-being throughout
the year. I ask you to become MHAI's partner
in helping to raise awareness about the importance
of mental health in your communities.
Most Sincerely,
Carol Wozniewski
MHAI Executive Director


text:
Tonight I had an opportunity to ask Barack Obama a question that is on the minds of many Americans, yet rarely rises to the surface in the great ruckus of the 2008 presidential race -- and that is whether an Obama administration would seek to prosecute officials of a former Bush administration on the revelations that they greenlighted torture, or for other potential crimes that took place in the White House.
Obama said that as president he would indeed ask his new Attorney General and his deputies to "immediately review the information that's already there" and determine if an inquiry is warranted -- but he also tread carefully on the issue, in line with his reputation for seeking to bridge the partisan divide. He worried that such a probe could be spun as "a partisan witch hunt." However, he said that equation changes if there was willful criminality, because "nobody is above the law."
The question was inspired by a recent report by ABC News, confirmed by the Associated Press, that high-level officials including Vice President Dick Cheney and former Cabinet secretaries Colin Powell, John Ashcroft and Donald Rumsfeld, among others, met in the White House and discussed the use of waterboarding and other torture techniques on terrorism suspects.
I mentioned the report in my question, and said "I know you've talked about reconciliation and moving on, but there's also the issue of justice, and a lot of people -- certainly around the world and certainly within this country -- feel that crimes were possibly committed" regarding torture, rendition, and illegal wiretapping. I wanted to know how whether his Justice Department "would aggressively go after and investigate whether crimes have been committed."
Here's his answer, in its entirety:
What I would want to do is to have my Justice Department and my Attorney General immediately review the information that's already there and to find out are there inquiries that need to be pursued. I can't prejudge that because we don't have access to all the material right now. I think that you are right, if crimes have been committed, they should be investigated. You're also right that I would not want my first term consumed by what was perceived on the part of Republicans as a partisan witch hunt because I think we've got too many problems we've got to solve.
So this is an area where I would want to exercise judgment -- I would want to find out directly from my Attorney General -- having pursued, having looked at what's out there right now -- are there possibilities of genuine crimes as opposed to really bad policies. And I think it's important-- one of the things we've got to figure out in our political culture generally is distinguishing betyween really dumb policies and policies that rise to the level of criminal activity. You know, I often get questions about impeachment at town hall meetings and I've said that is not something I think would be fruitful to pursue because I think that impeachment is something that should be reserved for exceptional circumstances. Now, if I found out that there were high officials who knowingly, consciously broke existing laws, engaged in coverups of those crimes with knowledge forefront, then I think a basic principle of our Constitution is nobody above the law -- and I think that's roughly how I would look at it.
The bottom line is that: Obama sent a clear signal that -- unlike impeachment, which he's ruled out and which now seems a practical impossibility -- he is at the least open to the possibility of investigating potential high crimes in the Bush White House. To many, the information that waterboarding -- which the United States has considered torture and a violation of law in the past -- was openly planned out in the seat of American government is evidence enough to at least start asking some tough questions in January 2009.


text: Rental Information:The picnic shelters at Tyler, Tart Park & Codrington Park are availabe for rent along with the Dunn Community Center. For more information regarding rental call the Dunn Parks and Recreation Office at (910) 892-2976.The multi-purpose room in the Dr. P.K. Vyas Recreation Center is available for rent during regular center operation hours. For more information regarding rental call the Recreation Center Office at (910) 897-5538.View the page of each individual facility to see more information on that particular facility.


text: Patented is a wearing article comprising first and second waist regions each with a body-facing surface and a garment-facing surface. The first and second waist regions cooperate together to define a waist-opening and a crotch region extends between and cooperates with the first and second waist regions to define a pair of leg-openings. A fastening system releasably connects to the first and second waist regions. The fastening system comprises engaging fasteners respectively located on transversely opposite side edges of the first waist region and landing fasteners located on the garment-facing surface of transversely opposite side zones of the second waist region. Each of the engaging fasteners has an insert and an engaging portion while each of the landing fasteners has a pocket adapted to receive the insert and a landing portion formed on an outer surface of the pocket so that the engaging portion releasably engages the landing portion. At least one of the first and second waist regions has elastic members serving to elastically adjust a circumferential waist dimension defined by the first and second waist regions. The engaging portion releasably engages the landing portion and the insert is received in the pocket without positively and directly engaging an inner surface of the pocket. The insert, if pressed into contact with the engaging portion by a pressing force, is elastically detached from the engaging portion when the insert is relieved of the pressing force. Each of the engaging portions comprises a hook member with a plurality of hooks projecting from a backing of the hook member toward the insert.


text:
Avey Tare - Down There
edited August 2011 in Side Projects
A complete surprise announcement today, I don't think I've even taken this in... (copy pasted via pitchfork) [img]http://cdn.pitchfork.com/media/avey452.jpg[/img] The yelping member of Animal Collective, Avey Tare aka Dave Portner, is coming out with a solo album called Down There on October 26 via AnCo's own Paw Tracks imprint. The nine-song record is his first totally solo affair and was recorded by AnCo member Josh Dibb aka Deakin. According to a press release, Avey's "favorite animals are the otter and crocodile [and] the latter has played a big role in his newest record. " I guess that explains the swampy promo pic above and the album's cover, which you can view along with the album's tracklist after the jump: [img]http://cdn.pitchfork.com/media/aveyart.jpg[/img] Down There: 01 Laughing Hieroglyphic 02 3 Umbrellas 03 Oliver Twist 04 Glass Bottom Boat 05 Ghost of Books 06 Cemeteries 07 Heads Hammock 08 Heather in the Hospital 09 Lucky Smilies are necessary -  Deakin in the studio this year, Panda release in the fall and this, what a 'break'!
thanks so mcuh for sharing this with me! I had no idea! Cannot wait to hear iT!
Woo!! WOW!!! That makes me Soooooooooooooooo happy and I love that they refer to him as the 'yelping member'.
He does enjoy yelping! haha I have so many questions... acoustic? Electronic? samples?? I can't even decide which kind of album I WANT it to be. I really don't care I just want to hear it. But in a way I hope he doesn't release any singles so I'm not tempted.
The pictures are really cool. And how its been kept such a secret for so long is exciting. Theres so much Animal Collective goodness being released.
I'd like to hear a more rock oriented AnCo. Like Automine almost sounded like Pavement. Hearing something like that but more experimental and crazy would be amazing to me. But I'm sure Dave has got something solid cooked up regardless
AWESOMESQUITO!! I'll begin prepping my ears! Does anyone know what that gizmo is that he's holding? Move your arm, Dave! _<;" title="stressed" />
WHAT THE GOSH DARN HECK I did not see this coming but man am I excited. Panda, Avey, Deacon.... where's geologists solo album? And I agree with you guys I really hope he doesn't release any singles I want to have absolutely no Idea what the album is going to sound like before I hear it. I dont know what kind of music its going to be and I dont even think i want to.
I DON'T EVEN KNOW WHAT TO SAY.
[url]http://www.paw-tracks.com/aveytarepresspage.html[/url] "[i]Dave Portner AKA Avey Tare was born in Baltimore County, Maryland on April 24th in the year of 1979. He moved to New York City in 1997 where he resides to this day (in south Brooklyn). Though he spends most of his time writing songs and producing sounds (usually in the group Animal Collective) he also is an intense record collector, film fanatic, book head, friend, and traveler. It's from these things primarily that Mr. Portner gets his inspiration, still striving to blend sounds and discover musical territory that seems unfamiliar. His favorite animals are the otter and crocodile. The later has played a big role in his newest record. Down There is a world of nine new songs from Animal Collective's Avey Tare. His first official solo full length carries you through [b]a murky world of sound, an alien death world of soul grooves[/b] that is both honest and otherworldly. Wait for sundown and turn it up loud. Take a ride on this haunted boat and let yourself be guided through [b]deep sloshy rhythms, waterlogged bass[/b], and moonlit breaks in the canopy that reveal [b]a crisp crystalline pop buzz.[/b] Down There was recorded in the month of June by old friend Josh Dibb (Deakin) at the Good House, an old church in upstate New York, surrounded by The Great Swamp and visited regularly by monks, white widows, and groan toads.[/i]"
[quote="Cloudface"] I dont know what kind of music its going to be and I dont even think i want to.[/quote] well said. I feel the same way. I know far too clearly what Tomboy is going to sound like (or at least, I think I do) so a completely surprise (like that this release was even brewing) would be incredible.
I am SO EXCITED for all these AC solo projects coming out.
I really hope that this album is really weird. Weirder than any of the most recent AC stuff because i need to know that there is still a god. a weird god who blesses the universe with his crazy weird things we tigers I solute you for quoting me. im going to surprise myself with his music if I have to murder everyone who tries to show it to me.
Even with that description, Paige, I still can't imagine what it'd sound like
[quote="Cloudface"]im going to surprise myself with his music if I have to murder everyone who tries to show it to me.[/quote] Good idea. Last year when Mew's new album came out I was really excited and totally anticipating it for maybe a year + . I put the album on my iPod and listened to it in my room with the lights off, just totally focusing on all the sounds and the songs and the album as a whole, and it sounded so amazing. Really worth the wait.
That's awesome I love mew with all of my heart. I downloaded an album of theirs to see what it would be like and I was happily surprised. To be honest though I only downloaded it because Mew is one of my top 5 favorite pokemon of all time. I figured a band with the same name couldn't be to bad and I right.
http://pitchfork.com/news/39603-animal- ... olo-album/ Read it and weep. From joy. Should coincide well with Tomboy. How cool. I hope there are no hard feelings between Panda and Avey.
What a cool album. Love the whole "bayou" thing. Surreal. Like something out of a nightmare where you have been turned into a crocodile.
Crocodiles of the deep [img]http://sphotos.ak.fbcdn.net/hphotos-ak-ash1/hs506.ash1/29934_400866679897_836534897_4061749_8333056_n.jpg[/img]
[quote="Shinsy"]Even with that description, Paige, I still can't imagine what it'd sound like [/quote] Haha, me neither but it helps.
Maybe they planned the release around the same times do you think?
Cloudface, could you imagine that as wallpaper? On all walls of the room. Trippy. You made it yeah? (:
^^^^^^^^^^^^^^^^^^^^^^^^^^^^ what's that picture????
lol my freind makes weird pictures in his spare time and sends them to me and gave me permission to put them on the internet. ill get more soon you guys all seem to like them. CHECK EM OUT ON THE PICTURES THREAD
We need a tomboy release date.
[quote="deadfly"]what's that picture????[/quote] Back one page.
[img]http://hphotos-snc3.fbcdn.net/hs483.snc3/26463_378493294897_836534897_3561331_5670178_n.jpg[/img] [img]http://sphotos.ak.fbcdn.net/hphotos-ak-snc3/hs503.snc3/26463_378493414897_836534897_3561334_535846_n.jpg[/img] [img]http://sphotos.ak.fbcdn.net/hphotos-ak-ash1/hs483.ash1/26463_378493709897_836534897_3561337_3934107_n.jpg[/img] [img]http://sphotos.ak.fbcdn.net/hphotos-ak-snc3/hs483.snc3/26463_378493724897_836534897_3561339_7662826_n.jpg[/img]
theres a thread about his new album already bro, not that i dont love 2 but its a little easier with just 1. and tomboy doesnt have a release date?
[quote="Maps"]We need a tomboy release date.[/quote] I read on Collected Animals from this one guy that talked to Panda that he said it might be out in March.
[quote="Paige"]I read on Collected Animals from this one guy that talked to Panda that he said it might be out in March. [/quote] @#$%
[quote="156curses"][quote="deadfly"]what's that picture????[/quote] Back one page.[/quote] Oops I didn't mean where is it I meant what is it a picture of haha
Every time I see the title of this thread, I go "tee hee" in the back of my mind.
lol I didn't even notice that until you said it but it does sort of tickle my middle school humor. Im excited for avey and pandas new albums and the album arts. for some reason album art is a big deal to me. im not sure why either. Also im leaving for Yosemite for a week so ill talk to you all in a week. bye bye
Take awesome pictures!
When I heard AC was taking a sort of break a bit I was very bummed, but now I'm very happy. We get the ODDSAC dvd, a new Panda Bear album, AND an Avey Tare album. Awesomeness all around.
and a new Deakin album too. Their breaks make me laugh!
Deakin's touring with Deerhunter!
that's amazing~~~~~~~~~~~~~
What's this about a Deakin album?
Well he's been playing live shows with Prince Rama and now opening for Deerhunter on a couple dates. He's talked about a record for a while now. Should be cool. Deakin's AWESOME
Yes, we all love Deakin. But I do not see him listed as playing in Atlanta on October 1st: although he just might. This is a stupid thing to be discussing here, I apologize to everyone, it should be on the Deakin on Tour thread. I just want a link to proof that Deakin is playing at the Variety Playhouse on October 1st before I buy tickets, y'know? And what I see is him going from LA to New Orleans. How about I ASK HIM when I SEE HIM which will be soon???
Bucket hats forever though.
The first word that came to my mind when I saw that picture was INTENSE. Do you guys think Avey will do a solo tour?
that would be amazing, if he did. But you have to decide if avey going on tour would be worth the months that the tour pushes back anco getting back into the studio. but actually, panda will probably tour. so he's already pushing it back plenty. hmmm
http://pitchfork.com/news/39774-avey-ta ... rocodiles/ a very long interview with Avey about the album. I have yet to read it all, but its all wicked cool.
According to the article, Geo has a kid. What?! Wow. Next to go is Avey, I guess. I wonder if Deaks will be a bachelor forever?
I have been sitting on the Geo progeny information for months and perhaps have now proven myself to the Powers That Be that I am trustworthy. I kept my mouth shut, guys! Not that anyone from the band reads this. I'm saving reading the interview for my 10:30 coffee break. But what a wonderful birthday relief to finally be able to shed the load of Geo's baby.
haha! What a secret to keep! Congrats to Geo. Becoming a parent is a beautiful thing and it makes me happy whenever anyone becomes a parent (and can likely live up to that role). I really love that interview with Avey.
i totally called this way back in Dec 08! http://animalcollectin.6.forumer.com/vi ... 811#138811 [code]see you on the easter! THE ISLAND! and congrats to Geo on becoming a daddy![/code] !!!


text:
We offer what you need to achieve success. Come explore and find out why so many students have decided to call one of the colleges in the Alamo Colleges District the pathway to their future.
Not sure where to start? Our Career Assessment Tool can help.
Find books, videos,and articles
Library Guides
Library Instruction
Library Services
Children's Library
Academic Calendar
Aquatic Center
Campus Map
Course Catalog
Distance Learning
Student Parking
Student Resources
Transfer Advising provides the educational road map for successful transfer from Palo Alto College to the four-year university.
Transfer Advising on campus includes:
Some of the university Transfer Plans include:
Some universities use the term 'transfer guide' and some use '2+2,' but in general both terms refer to a degree plan that lists the courses you take at PAC before transferring to a four year school. You will want to use the transfer guides to determine what courses to take at PAC as these plans list the requirements within each degree. You can access the transfer guides and university transfer information here. In addition, the Alamo Colleges lists all current Articulation Agreements with our transfer universities on their webpage here.
Palo Alto College and the University of Incarnate Word have created a joint admissions agreement or JAA. A joint admissions agreement requires a form that you sign, listing your major, when you intend to transfer, and your contact information. By signing the form, you are locked into the degree plan that you are following in case that plan changes over time. If you decide you want to follow another major, then you can simply sign a new joint admissions agreement. Please visit with your certified academic advisor to sign an agreement!
We have a great assortment of college catalogs from both in-state and out-of-state institutions for students to view. If you would like your own catalog you can contact the university for one or locate one online. You can also search university websites for admissions information, applications, majors, degree plans, and scholarships. The majority of public Texas universities use the Apply Texas application at www.applytexas.org.
Not sure where to transfer or what schools offer your interested major? Visit http://nces.ed.gov/collegenavigator/. This site allows you to search by major, institution type, location and many other factors to determine which transfer institution meets YOUR needs.
Not sure if your classes will transfer to the university you want to transfer to? You can find out course equivalencies for Texas universities statewide by using the Texas Common Course Numbering System which provides course equivalencies between Palo Alto College and numerous Texas universities. If you need assistance using the website please make an appointment with your certified academic advisor.
University recruiters and advisors come to our campus throughout the year to answer questions regarding admissions requirements, course transfer guidelines, programs available and other university requirements.
Click to view the Recruiter Visitation Schedule or stop by the Palomino Center Annex (SEED Advising Center desk) for a hard copy.
Click here to learn how to apply for graduation using your ACES account
Location:SEED Advising Center (PC Annex)
BOLD Advising Center (PC Annex)
STEM Advising Center (PC 114)
Advising Team Leader:Arianna Lay
1400 W. Villaret Blvd, San Antonio, Texas 78224 (210) 486-3000


text:
DETROIT (AP) — The Detroit Symphony Orchestra is launching its first Beethoven festival in 36 years this month.
The orchestra will perform all nine Beethoven symphonies at Orchestra Hall in February. It will feature Beethoven Symphonies No. 3 and 8 on Friday at 10:45 a.m. and 8 p.m. The orchestra will continue on Saturday with Beethoven's Symphony No. 4 and 5 at Sunday at 3 p.m.
Free pre-concert performances and lectures will be hosted one hour before each performance. Those who can't attend can watch a webcast of some of the performances online.
The festival will conclude Feb. 21-24 with Beethoven's Ninth Symphony.
The orchestra received a $75,000 grant from the National Endowment for the Arts to support this year's festival


text:
This morning's 1.1% advance in retail sales was more than forecast and followed a revised 0.2% gain in January, Commerce Department figures showed today in Washington. With that, the U.S. equity markets seem to be in "breather" mode after having a blistering start to 2013. Today, the JUN13 E-mini S&P 500 is trading at unchanged levels from yesterday at 1547. As other countries of the world commence or continue their interest rate lowering cycles (U.K., Mexico), those policies could serve to potentially continue to boost the U.S. stock market even higher.
If the S&P 500 reverses course from these levels, at this point we do not believe it will be a deep correction, as the S&P 500 is valued at 15.3 times reported earnings, a 22-month high, according to data compiled by Bloomberg. They key is that the current valuation is still 7.3% below an average of 16.6 over the last decade. However, there is always a counterpoint, and the counterpoint to the rally continuing is that the Euro region economies are still very questionable and not producing as good of numbers as the U.S.
Speaking of the Eurozone, the euro currency took a tumble today, trading down 88 ticks to 129.51 (JUN13). We believe this currency has more room to fall and could see 127.50 soon. The Aussie dollar has rallied around 200 ticks just this month and has hit a key level of 1.03 recently. We believe this is an overbought level, and we would not be surprised to see this currency come back down to the middle of its March range. The USD index has hit the highest levels today since last August, touching the 83 level. We are still of the view that the US dollar will continue to see strength and potentially move to a very key 84 level, which is the approximate high of last summer. Typically the U.S. stock market moves opposite to the U.S. dollar so it will be interesting to see what happens to both of these going forward.
Grain futures, specifically corn and soybeans, are down today as investors and traders prepare for potential bumper crops aided by favorable weather conditions, which is of course a marked difference from the last spring and summer drought rally. Wheat futures are bumping against potential resistance at $7.00.
We focus more on the Mexican Peso/USD today. Even with the Banxico rate cut several days ago, the currency has actually rallied a lot since then. We believe the currency is now at overbought levels on the short term and we expect a pullback. The currency could even pullback to the .079 level before potentially heading higher.
Click to enlarge.


text:
ST9160 : Narrow boat on canal east of Seend Park Farm
taken 1 year ago, near to Bowerhill, Wiltshire, Great Britain
The National Cycle Network
The National Cycle Network is a network of cycle routes. It was created by the charity Sustrans Link (Sustainable Transport), aided by a National Lottery grant.
Many routes aim to minimise contact with motor traffic, though 70% of them are on roads.[2] In some cases the NCN uses pedestrian routes, disused railways, minor roads, canal towpaths, or traffic-calmed routes in towns and cities.
Kennet & Avon Canal
The Kennet and Avon is made up of two river navigations and a linking stretch of canal. It runs from Hanham Lock near Bristol to the River Thames at Reading, over 100 miles long with more than 100 locks, some magnificent engineering and crossing some of the most beautiful scenery in southern England. It was only reopened in 1990 after decades of dereliction.
TIP: Click the map for Large scale mapping
Change to interactive Map >
Change to interactive Map >
- Grid Square
- ST9160, 37 images (more nearby )
- Photographer
- David Smith (find more nearby)
- Date Taken
- Thursday, 8 June, 2017 (more nearby)
- Submitted
- Wednesday, 12 July, 2017
- Geographical Context
- Primary Subject of Photo
- Subject Location
OSGB36: ST 9180 6097 [10m precision]
- Camera Location
- View Direction
- East-northeast (about 67 degrees)
Looking for a postcode? Try this page
This page has been viewed about 2 times.
View this location: KML (Google Earth) · Google Maps · Bing Maps · OS Map Checksheet · Geograph Map · More Links for this image


text:
THE SQL Server Blog Spot on the Web
If you look up Table Hints in Books Online, you'll find the following statement:
If a clustered index exists, INDEX(0) forces a clustered index scan and INDEX(1) forces a clustered index scan or seek. If no clustered index exists, INDEX(0) forces a table scan and INDEX(1) is interpreted as an error.
If a clustered index exists, INDEX(0) forces a clustered index scan and INDEX(1) forces a clustered index scan or seek. If no clustered index exists, INDEX(0) forces a table scan and INDEX(1) is interpreted as an error.
The interesting thing there is that both hints can result in a scan. If that is the case, you might wonder if there is any effective difference between the two. This blog entry explores that question, and highlights an optimizer quirk that can result in a much less efficient query plan when using INDEX(0). I'll also cover some stuff about ordering guarantees.
As usual, we need to create a test table:
USE tempdb;SET NOCOUNT ON;GOIF OBJECT_ID(N'Test.Orders', N'U') IS NOT NULL DROP TABLE Test.Orders;GOIF SCHEMA_ID(N'Test') IS NOT NULL DROP SCHEMA Test;GOCREATE SCHEMA Test CREATE TABLE Orders ( order_id INTEGER NOT NULL, product_id INTEGER NOT NULL, quantity INTEGER NOT NULL, padding CHAR(980) NOT NULL DEFAULT (SPACE(0)), CONSTRAINT [PK Test.Orders order_id] PRIMARY KEY CLUSTERED (order_id ASC) );GOCREATE NONCLUSTERED INDEX [IX Test.Orders quantity]ON Test.Orders (quantity ASC) INCLUDE (padding);GODECLARE @Counter INTEGER = 1, @RowCount INTEGER = 64 * 8; WHILE @Counter <= @RowCountBEGIN INSERT Test.Orders (order_id, product_id, quantity) VALUES ( @RowCount - @Counter, @RowCount - @Counter, @RowCount - @Counter ); SET @Counter += 1;END;GO
The test table has 512 rows, padded so that eight rows fit on each 8KB data page. The table is clustered on the order_id column, and there is a nonclustered index on the quantity column, with the padding column INCLUDEd to again ensure that eight rows fit on each nonclustered index page.
The script also deliberately generates a very high level of logical fragmentation, which we can see with the following query:
SELECT SI.name, IPS.index_type_desc, IPS.avg_fragmentation_in_percent, IPS.fragment_count, IPS.page_countFROM sys.dm_db_index_physical_stats ( DB_ID(), OBJECT_ID(N'Test.Orders', N'U'), DEFAULT, DEFAULT, DEFAULT ) IPSJOIN sys.indexes SI ON SI.[object_id] = IPS.[object_id] AND SI.index_id = IPS.index_idORDER BY IPS.index_id;GO
The reason for the fragmentation will become apparent later on. These are the results I saw on my machine:
A scan of a table or index processes every row, whereas a seek returns one or more rows from one or more ranges of the index.
When the SQL Server optimizer produces a plan containing a scan of an index or clustered table, the Storage Engine may be able to choose from two different strategies: scanning the pages in logical order, or the order in which they were allocated. In the first case, it follows the doubly-linked list at the leaf level of the index. In the second case, it can use the Index Allocation Map (IAM) pages to drive the scan.
A scan of a heap always uses the IAM pages of course (there is no clustered index to provide a logical page order), but this post is concerned mainly with indexes and clustered tables, so I won't talk much more about heaps.
The advantage of an IAM-driven scan is that pages will tend to be read in physical order on the disk, which generally results in sequential I/O, and promotes effective read-ahead. How efficient scanning the pages in logical order is depends on the level of logical fragmentation: if fragmentation is high, the scan will tend to result in a high proportion of random I/Os, and read-ahead may be much less effective.
The downside to the IAM-driven scan is that it is not guaranteed to return results in logical key order (in fact it usually won't), and there is an extra start-up cost in accessing the IAM pages, and planning the scan.
The Storage Engine may choose an IAM-driven scan if:
Hopefully the first point makes sense on it's own. The second point refers to a flag that the optimizer can set on a scanning iterator in a query plan. This flag shows up as an "Ordered:True" or "Ordered:False" property of the iterator. When set to true, it indicates that the Storage Engine must perform a scan in logical key order for the plan to produce correct results. When set to false, it means that the order does not matter. In the latter case, the Storage Engine has the choice of performing either type of scan. The query plan does not show which type of scan was chosen.
The third point comes in two parts, but both relate to the fact that an IAM-driven scan does not take the locks necessary to prevent other concurrent operations from changing the data in the table, or moving the pages around (perhaps as the result of a page split).
The simplest way to satisfy the first part (to ensure that the data cannot be changed or moved) is to take a shared table lock. The second part (acceptable incorrect results) refers to transaction isolation level. If the scan runs at an effective isolation level of READ UNCOMMITTED (either explicitly or through the use of a NOLOCK hint) we are effectively saying that we don't care about reading consistent data. More than that, we imply that we are happy to read the same data twice, or not at all.
Our test table has been created with a high level of fragmentation. This allows us to see whether the Storage Engine used an IAM-driven scan or not. If the results come back in logical key order, we can be sure (in these specific examples) that the scan was performed by following the doubly-linked list at the leaf level of the index. If the results come back in allocation order, they will look very different, and we can infer that an IAM-driven scan was performed.
Important: Please don't take any of that to mean that you can rely on query results to come back in a particular order in more general cases. The very simple tests shown here are carefully crafted to encourage the ordering behaviour I have just described, but there are no guarantees. Never rely on plan details to provide ordering – always use an ORDER BY clause if you require ordered results.
Let's look first at two simple queries that return all columns and all rows from our test table:
-- Query 1SELECT T.*FROM Test.Orders T; -- Query 2SELECT T.*FROM Test.Orders T ORDER BY T.order_id ASC;
Both queries produce very similar execution plans, but the first specifies "Ordered:False" while the second specifies "Ordered:True". The second example avoids an expensive explicit Sort iterator by requiring the Storage Engine to return rows from the scan in logical key order (the clustered index is on order_id, remember).
Both queries return records ordered by the clustering key; Query 1 because the Storage Engine cannot perform an IAM-driven scan (we haven't met all the conditions); and Query 2 because an ordered scan was requested by the optimizer.
Query 1 is not guaranteed to return records in that order, but Query 2 (almost) is. In case you are wondering what might cause Query 1 to return records in a different order, consider the effect of a parallel plan, or Enterprise Edition's Advanced Scan feature. For anyone that follows that second link, I should mention that Advanced Scan is only possible when the Ordered flag is set to False.
Query 1 above meets two of the conditions for an IAM-driven scan: the index contains at least 64 pages, and the optimizer did not specify Ordered:True. We can meet the third condition by adding a WITH (TABLOCK) hint:
SELECT T.*FROM Test.Orders T WITH (TABLOCK);
We receive the following result set:
Each group of eight records (each 8KB page) comes back ordered by the clustering key, but the overall order of pages is in the order the pages were written. This is the result of an IAM-driven scan: pages in allocation order, records within the pages in clustered key order. As you may have guessed, neither of these two observed orderings can be relied on either – I mention them for pure geek interest value.
Adding the TABLOCK hint to Query 2 does not result in an IAM-driven scan, because the optimizer continues to specify Ordered:True on the scan (to avoid the sort that would be necessary to honour the ORDER BY clause).
For Query 2, the optimizer does still consider a plan with an unordered scan followed by a sort, but rejects it as being more expensive than an ordered scan. For very large tables, the optimizer may calculate that an IAM-driven scan might save more time than would be consumed by the extra sort, and a plan featuring the unordered scan + sort would be chosen. This is a heuristic optimization: the optimizer knows nothing about the actual fragmentation level of an index (though it does know how many pages it occupies).
Let's now run the Query 1 test again, this time specifying INDEX(0) or INDEX(1) hints, as well as choosing to specify TABLOCK or not:
SELECT T.* FROM Test.Orders T WITH (INDEX(0));SELECT T.* FROM Test.Orders T WITH (INDEX(1));SELECT T.* FROM Test.Orders T WITH (INDEX(0), TABLOCK);SELECT T.* FROM Test.Orders T WITH (INDEX(1), TABLOCK);
In all cases, the results are the same: if we specify TABLOCK, we meet the conditions for an IAM-driven scan, and the records comes back in physical order. If we omit TABLOCK, we happen to get results in clustered-key order – but we know that is just coincidental. All four query plans look exactly the same as the simple clustered index scans shown earlier, and all feature "Ordered:False".
Let's try the same thing with the ORDER BY clause (Query 2):
SELECT T.* FROM Test.Orders T WITH (INDEX(0)) ORDER BY T.order_id;SELECT T.* FROM Test.Orders T WITH (INDEX(0), TABLOCK) ORDER BY T.order_id;SELECT T.* FROM Test.Orders T WITH (INDEX(1)) ORDER BY T.order_id;SELECT T.* FROM Test.Orders T WITH (INDEX(1), TABLOCK) ORDER BY T.order_id;
All four queries produce the same results, in the same order, and are guaranteed to do so thanks to the ORDER BY clause. The execution plans are rather different, however:
Both INDEX(1) plans produce the plan shown on the left, with the scan showing "Ordered:True", and a cost of 0.05.
Both INDEX(0) plans produce the plan shown on the right, with the scan showing "Ordered:False", and a cost of 0.07.
It seems that INDEX(0) forces "Ordered:False" on the scan. As a consequence, we get an explicit Sort iterator when the ORDER BY clause is present. Why should INDEX(0) force an unordered scan?
One can imagine a line of reasoning that says we would normally specify INDEX(0) only on a heap table, where an ordered scan is not possible. The flaw in this argument is that INDEX(1) does not enable us to force a scan of a clustered table – it will result in a seek if at all possible.
Nevertheless, it is possible to produce "Ordered:True" when INDEX(0) is specified, in an INSERT, UPDATE or DELETE query. Let's look at three alternative formulations of a trivial UPDATE query on our test table:
All three plans feature the "Ordered:True" flag, but the one with INDEX(0) includes a sort on order_id. That sort is probably redundant, since the Clustered Index Scan (with "Ordered:True") ought to be guaranteed to produce rows in that same order. Not only will that sort slow down your query, it will require a memory grant, and might even spill to tempdb.
When performing our UPDATE query, the optimizer takes into account the effect of ordering. If rows arrive at the update iterator in clustered index order, the pattern of updates will likely result in sequential I/O. If rows are in a different order, the updates will likely cause random I/O as the index is updated row by row.
Often, the optimizer may choose to pre-sort the records on the clustered index key to optimize for sequential I/O. On other occasions, it may decide that the cost of the sort would exceed the savings made – this is seen when the number of rows to be updated is very small, and the rows can be located most efficiently from a nonclustered index.
When the rows are sourced from the clustered index, the optimizer always adds the "Ordered:True" flag to maximize the chances for sequential I/O, regardless of the estimated number of rows. This explains how the Clustered Index Scan above manages to acquire the "Ordered:True" flag when INDEX(0) was specified. It seems that the optimizer misses the fact that by adding the ordering flag, the sort is now redundant.
Although I have concentrated very much on clustered indexes in this entry, I want to stress that the two scanning strategies apply to both clustered and non-clustered indexes. I created a nonclustered index on the test table so you can verify for yourself that IAM-driven scans are possible with nonclustered indexes, and the rules are exactly the same.
It is also not necessary to specify TABLOCK explicitly to get an IAM-driven scan: if the index in question happens to have row and page locks disabled (using ALTER INDEX (…) SET ALLOW_ROW_LOCKS = OFF, ALLOW_PAGE_LOCKS = OFF) the Storage Engine will recognise that a table lock has to be taken. Other circumstances like the database being read-only will also meet the underlying requirement that the data cannot change during the scan.
Beware of using NOLOCK when the other conditions for an IAM-driven scan are met. Not only might you read data that has not been committed yet, you can also read committed data twice, or not at all. Your query might also fail completely with the dreaded error: "Could not continue scan with NOLOCK due to data movement".
Finally, watch out for unnecessary sorts in plans that use the INDEX(0) table hint – consider using INDEX(1) instead, or rewriting the query to avoid the hint altogether.
Paul White
Email: email@example.com
Twitter: @SQL_Kiwi
Clustered Index Scans – Itzik Ben-Gan
Advanced Scanning – Books Online
When IAM Scans Can Be Used – SQL Server Storage Engine Team
IAM Pages – Books Online
Beware the NOLOCK hint – Itzik Ben-Gan
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
Wow! Every new post is like another new treasure.
Thanks for another great post. I'm always learning something... I never realized that an IAM scan was even available... yet another reason that it's a big mistake to make any kind of assumption on the order of a result set (when you don't specify an ORDER BY).
I marvel at the complexity and depth of the optimizer... and I marvel at your continued excellent output.
Thanks, Paul!
Thank you, Brad!
After last T-SQL Tuesday I thought I was indexed out. But this is a great post. It must have taken a lot of investigation.
Good job
Hey Michael,
This was going to be my first contribution to T-SQL Tuesday, but circumstances conspired against me. I'll try to be better organised for the next one.
Thanks for the kind words.
GOOD JOB! ...from COLOMBIA
Great Article :)
index(0) is heap, index(1) cluster index


text:
NEWCOSPLAY Barefoot Shoes Quick-Dry Yoga Socks Slip-On for Women Men KidsSmall|Stripeblue Stripeblue Small
92%Polyester +8%spandex Upper
Rubber sole
PERFECT MATERIAL: Ultra Light Weight Stretchy Material allows user to easily put on and take off, to provide you with a comfortable feeling.
ULTRA LIGHTWEIGHT & ANTI SLIP SOLE:Unique Sole with non-slip effective to maximally protects your feet.
COMFORTABLE & FIT: Breathable upper material, non-slip soles and smooth neck design, to prevent wearing chafing, make you more comfortable and flexible.
IDEAL FOR ANY ACTIVITY: Perfect for beach, swimming, surf, pool, sailing, boating, kayaking, windsurfing, yoga and other any activity.
VARIOUS SIZE AVAILABLE -- fit different feet,little kids, big kids,men,women are available.
Water Shoes


text:
Chris Cagle and Will Hoge Kick Off the 2013 Missouri State Fair Concerts [PICTURES]
The Chicks Dig It at the 111th Missouri State Fair, but I think it's safe to say EVERYONE was digging the show that Chris Cagle and Will Hoge put on at the Pepsi Grandstand Thursday night. Cagle laughed, cried and really made sure everyone had a great time. Check out all the pictures in our gallery!


text:
Get Directions
Delivery not available to your postal code
We deliver to you
Buy online, pick-up here.
Pick up not available at this store.
Edit in cart
Why do we ask for your postal code?
By providing your delivery postal code, you'll allow us to:
The Brick respects your privacy and will not share this information with anyone.
www.thebrick.com is accepting online orders delivered to your postal code.
Enter your postal code to check your local price.


text:
Välkommen till ITV Studios Sweden
- ett av Sveriges ledande produktionsbolag
ITV America is the largest independent non-scripted producer in the US. It includes ITV Entertainment, the flagship production arm of ITV Studios in the US, and the acquired top production companies of Gurney Productions, High Noon Entertainment, Thinkfactory Media, DIGA and Leftfield Entertainment.ITV America
ITV Entertainment is a leading producer of non-scripted content in the US. It is behind some of the biggest and most successful brands on American television. ITV Entertainment is a major force in acquiring, developing and producing non-scripted programming for US networks across a wide range of genres.ITV Entertainment
ITV Studios America is the U.S.-based independent scripted TV studio operation of ITV America. The studio develops and produces scripted TV programming for global distribution.ITV Studios America


text:
Flashback to The Gayest Show on Earth June 27th
Truly a hilarious, wild celebration of everything queer, The Gayest Show on Earth gave our laugh muscles a real Pride workout last Wednesday. Hosted by Vancouver gay comedy legend Darcy Michael, the show included the best of Toronto's stand up, sketch, improv, music and drag performances. Comedians Dawn Whitwell, Linda Ellis, Elizabeth Hotson and the Queer Comedy Collective. Drag Queens Fay Slift & Miss Fluffy Souffle. With music by Carl Johann and Dominick Abrams!
Fay Slift & her back up strings section.
If you haven't already watched the video above, please do yourself a favour and call me maybe.