text:
Egypt's Muslim Brotherhood, slow to join pro-democracy protests and wary of a government that has banned it for 56 years, says it will enter direct talks with President Hosni Mubarak's government. The move is a sharp reversal of course for Egypt's best-organized opposition group, which two days ago insisted it wouldn't negotiate with the government until Mr. Mubarak steps down.
The decision also bolsters the likelihood of a compromise end to the political impasse. But any deal that leaves major elements of the current government in place will severely disappoint both secular and Islamist protesters who have flooded Cairo's central Tahrir Square in recent days to call for Mubarak's immediate departure.
Many Egyptian activists also say they worry that the Brotherhood's elderly leadership, who have become increasingly inward-looking in the face of government repression, are no match for the old-guard members of Mubarak's regime, who will use them to split the forces pushing for democratic change and avoid meaningful reform.
"This is a bad idea," says Ibrahim al-Houdaiby, a former Brotherhood youth leader who left the group two years ago. "The compromises are going to be too great."
Compromise talks begin
Al Arabiya reported in the early afternoon in Cairo that talks had begun between Vice President Omar Suleiman, Brotherhood representatives, Coptic Christian billionaire Naguib Sawiris, and a representative of Mohamed ElBaradei, the Egyptian Nobel Prizewinner who has been pushing for democratic reform in Egypt in the past two years. They are presenting themselves as a broad front representing multiple streams in Egyptian society, but ground-level democracy demonstrators are suspicious that a group of elites without true grass-roots support is about to cut a back-room deal.
"The protesters know that if we withdraw before our demands are met, the government will hunt us down and try to crush us," says Khaled Abol Naga, an Egyptian film star who has joined the protests. "There is no trust of anyone from the regime, not just Mubarak."
Vice President Suleiman's key role
Over the weekend, US Secretary of State Hillary Clinton strongly supported Vice President Suleiman -- a former general and longtime intelligence chief until Mubarak named him vice president in late January -- as the focal point for efforts to open up Egyptian politics. Mubarak appears to have handed off all responsibility for dealing with the protesters to Suleiman and other members of the military establishment.
Suleiman is a devout Muslim himself and is also deeply suspicious of the Brotherhood, a longtime enemy of the Mubarak government. Though the movement eschewed violence decades ago and has hewed to a gradualist course, men like Suleiman -- not to mention much of the foreign policy establishment in the US and Europe -- view them as a threat to stability.
Suleiman's place in Egyptian politics was secured in 1995, when he insisted that Mubarak use an armored car on a trip to the Sudan. While both men drove through the streets of Khartoum, they were ambushed by members of the Gamaa Islamiyah, a group of violent Islamists that split from the Brotherhood in disgust over the group's refusal to use violence in the 1970s. Mubarak credited Suleiman's advice, and the two men spent the next decade working in concert to wipe out the group.
RELATED: Think you know the Middle East? Take our geography quiz.
Now he's at the forefront of the old military elite, which appears likely to shed Mubarak in elections scheduled for September but do what it can to maintain its position (the 82-year-old Mubarak promised last week that he won't run).
Muslim Brotherhood makes its move
Blake Hounshell, the managing editor of Foreign Policy magazine who's in Cairo following the uprising, says it appears the Brothers are turning their back on the protesters at Tahrir and attending to their own interests.
"They see they're losing leverage, and they want to get the best deal possible they can, now," he says. "The longer this thing draws out, the more it goes against the protesters, and the Brotherhood knows that."
At Tahrir Square, which has been turned into an encampment for democracy protesters over the past 12 days, many today were suspicious of the Brotherhood.The group is clearly popular in Egypt, but without free elections or decent polling, their true support is impossible to gauge. Many Egyptians argue that the group wouldn't be able to take clear power in fair elections, and may see a deal now that allows it to legally participate in politics and give it a voice in some political reforms as its best chance at short-term influence.
"The Muslim Brotherhood wants to steal the success of this revolution. They are welcome to play a part, but they're not the leaders," says Samie el-Shafie, a woman who holds a senior position at the Ministry of Health and has just joined the protests at Tahrir Square. "They don't represent us."
-- Ann Hermes contributed to this report.
RELATED: Think you know the Middle East? Take our geography quiz.


text:
Revolution is descended in spirit from Hypercard (HC). When Apple's support for HC withered, Scott Raney developed Metacard (MC), a near clone. Metacard was then bought by Revolution (RR), based in Scotland. Metacard was two quite distinct things: an engine, and an IDE. When Metacard was sold, the MC IDE became public domain. It still exists, is volunteer maintained, and it can be used with the latest RR engine. Some on the RR user mailing list prefer the much simpler MC IDE to the RR IDE, at least for initial project development. Other IDEs are possible, and there is a third party (non-free) IDE called Galaxy.
Link: osnews.com

subset: commoncrawl


text:
At 6-foot-11, Larry Sanders may already seem larger than life, but just imagine him on a two-story movie screen.
If Sanders has his way, you'll eventually see more of him in the giant, silver screen variety. The former VCU Basketball fan favorite and current Milwaukee Bucks forward will make his big screen debut in January with the release of "Movie 43", an ensemble comedy that features Emma Stone, Halle Berry, Gerard Butler, Hugh Jackman and a number of other stars. Sanders appears as, wait for it, a basketball player. He also wears a Jheri curl in the scene as a member of a team from the 1970s.
"It was a wig," Sanders assures. "It was either that or they were going to do something with my mohawk at the time."
Sanders actually shot the scenes for the movie over three days in Los Angeles prior to his rookie season two years ago. He says he really enjoyed the experience, including meeting Terrence Howard, who plays the coach of Sanders' team.
"Terrence Howard was just amazingly funny. He was telling stories and stuff. I had never really seen how funny he was before," Sanders said.
But acting is no laughing matter to Sanders, who says he'd love to become more involved with the movie industry in the future. He says he's currently writing a script for a "mockumentary" he wants to shoot with NBA players next summer.
"I feel like it's another way to express myself," he said. "Acting and movies have always been of interest to me. I like all aspects. That's what I grew up with, movies and music."
"Movie 43" is definitely for an adult audience. It's directed by Peter Farrelly of "Something About Mary" and "Dumb & Dumber" fame and is described on RottenTomatoes.com as "…one of the most shocking, original, and dangerous comedies ever made." So, there's that. But Sanders, father of a two-year-old son, says he'd prefer to work on movies geared towards children in the future.
If you don't think there's a market for a tall guy in Hollywood, just know that Sanders wouldn't be the first human skyscraper to work in front of the camera. Wilt Chamberlain was in "Conan the Destroyer" and former Nuggets' standout Alex English starred in "Amazing Grace and Chuck" (okay, he was a basketball player). Longtime actor Richard Kiel ("The Spy Who Loved Me", "Happy Gilmore") is 7-foot-2, Ted Cassidy (Lurch from "The Addams Family") was 6-foot-9 and Fred Gwynne of " The Munsters" and "Car 54, Where Are You?" fame was 6-foot-8. That's just a few. I haven't even mentioned "Space Jam" yet.
"Movie 43" opens in theaters on Jan. 25, 2013.
Sanders is entering his third season with the Bucks. In two previous years, Sanders averaged 4.0 points and 3.0 rebounds, mostly off the bench, for Milwaukee. Although those numbers don't explode off the page, Sanders believes he can play a more central role for the Bucks this year.
He saw his playing time increase toward the end of the 2011-12 season and performed well, despite missing two games to a league suspension for fighting and one to illness. Sanders averaged 5.5 points, 4.2 rebounds and 2.4 blocks per game in 11 April contests, including 14 points and seven rebounds against Portland, as well as 12 points and five blocks against Philadelphia.
Sanders also expects he'll benefit from a more productive offseason. Last summer, the NBA lockout prevented players from having any contact with their teams, and Sanders says he didn't maximize his time away.
"This summer and last summer are like day and night," he said. "No one knew if the league was going to start back. I didn't know if I was going to be in Europe. Nothing was stable. It was really shaky for me. I didn't handle it as well as I could've."
Sanders says it took months for him to feel caught up.
"I think that summer was kind of a waste," he admits. "I wasn't in the shape I should've been and in tune as I should've been until the end of the season. It took me those 40-50 games to get there. This year I don't have to play myself into shape."
Instead, Sanders spend more time working out in Milwaukee in the offseason, as well as a stint in the Las Vegas Summer League.
The extra repetitions are helping Sanders learn to play within himself. Sanders' production per 36 minutes last season was 11.3 points, 8.2 rebounds and 3.4 blocked shots, which is pretty respectable. But he's had trouble staying on the floor because of foul trouble. Last year, he fouled at an entirely-too-high rate of 5.8 per 36 minutes. Sanders believes he can play more consistently all around, which will help him commit fewer fouls.
"I was just playing 100 miles per hour all the time, and then I would play 40 miles an hour. You can't do that. I've got to find that even pace, and I think I'm on the right track now."
In three preseason contests this year, Sanders has averaged 7.0 points and 6.7 rebounds while playing about 18 minutes a game. With the regular season just a couple of weeks away, Sanders is feeling confident about his approach to the game.
"I wouldn't say it's a sense of urgency," Sanders said. "But when you work hard and keep a good mindset, things tend to fall into place, and my mindset is to create those habits. I think if you keep that same attitude and mindset, good things will happen."
The Bucks, who finished 31-35 and missed the playoffs last year, open the 2012-13 season Nov. 2 at the Boston Celtics.


text:
Select a topic or year
The acquisition advances IBM's efforts to help clients derive value from big data, respond more efficiently to litigation and regulations, and dispose of information in an automated way that has outlived its purpose.
IBM estimates that 2.5 quintillion bytes of data are created every day -- so much that 90 percent of the data in the world today has been created in the last two years alone. As a result, chief information officers (CIOs) and general counsels (GCs) are overwhelmed by volumes of information that exceed their tax IT budgets and their capacity to meet legal requirements. Storing old, unnecessary data adds storage and infrastructure costs and compromises companies'ability to effectively comply with legal obligations.
Adding StoredIQ to IBM's big data offerings gives organizations tools for more effective governance of the vast majority of information, including its timely disposal to eliminate unnecessary data that consumes infrastructure and elevates risk. The addition of StoredIQ builds on IBM's prior acquisitions of PSS Systems and Vivisimo as well as organic solutions that improve information economics including value-based archiving, records and retention management, ediscovery management, and disposal and data governance.
StoredIQ software provides scalable in-place analysis and management of disparate and distributed email, file shares, desktops and collaboration sites. It can rapidly analyze high volumes of unstructured data and can be configured to automatically collect it for ediscovery purposes as well as dispose of files and emails in compliance with regulatory requirements. As a result, legal teams can mitigate risks by meeting compliance obligations more effectively, and IT can dispose of unnecessary data and align information cost to value to take out excess costs.
"Most CIOs and GCs know they're saving too much data, which drives up IT costs and increases legal risk," said Deidre Paknad, Vice President of Industry Solutions, who is leading the integration of StoredIQ at IBM. "With IBM and StoredIQ, organizations can maximize the value of big data and more effectively meet growing legal and privacy duties while disposing of data debris to control both cost and risk."
CIOs and general counsels can avoid big data hoarding -- and all the expense and risk that goes along with it – by efficiently automating information governance and disposal.
Named a 2012 Cool Vendor by Gartner, StoredIQ has more than 120 customers worldwide, including global leaders in financial services, healthcare, government, manufacturing and other sectors.
For more information on IBM's big data platform, visit ibm.com/bigdata.
|XML feeds
Financial news, company earnings, philanthropy, community service, human resources, sponsorship
|IBM Analytics
News about IBM solutions that turn information into actionable insights.
Information Management, Lotus, Tivoli, Rational, WebSphere, Open standards, open source


text:
"Tobacco Board is committed to accomplishing its role - the expressed will of parliament - for the smooth functioning of a vibrant farming system, fair and remunerative prices to tobacco growers and export promotion."read more..
Tobacco is an important commercial crop grown in India. It occupies the third position in the world with an annual production of about 800 Million Kgs. Of the different types grown, flue-cured tobacco, country tobacco, burley, bidi, rustica and chewing tobacco are considered important. India stands 3rd in production of tobacco and in exports, Brazil and USA are ahead of India.
Tobacco and tobacco products earn approx Rs.20,000 Cr. to the national exchequer by way of excise duty, and approx.Rs.5000 Cr. by way of foreign exchange every year.
Home | About Us | FCV Tobacco | Tobacco Varieties | Exporters | Circulars | Recruitment | Employee Corner | Forms | Contact Us
| Copyrights Policy | Terms & Conditions | Privacy Policy | Help | Sitemap |Hyperlink Policy | Feedback | Broken Links
Page Updated on : 02/05/2020


text:
Are brands missing the mark with Pinterest on mobile?
Pinterest is quickly becoming a social media star for brands and retailers to showcase and share their products with a reported tenfold increase in traffic over the past six months. And although there are mobile opportunities for brands and retailers with regards to Pinterest, it seems as though many are not leveraging them.
Pinterest?s primary focus is on desktop, but the company also has mobile applications and a mobile Web site available, showing how smart retailers and brands can combine their social media efforts with mobile marketing. Additionally, given the site?s value on sharing content and creating one-on-one relationships is an example of how a retailer can tie an in-store experience to Pinterest.
?Brands will need to set the example for users to engage with them while they are experiencing the brand,? said Kerri Smith, senior innovation lead of mobile at iProspect, Boston.
?They will need to establish what is unique about their bricks-and-mortar presence, what other experiential efforts are they leveraging and how are they connecting with the community,? she said.
?By pinning these live experiences, they will encourage users to do so as well, creating a more personally relevant and interactive platform for all users.?
Pin me in
Pinterest is a social media site that lets users find and share pictures that inspire them from across the Web and pin them to digital boards that users can customize by category.
The site is skewed to women with an emphasis on fashion, food and home décor content.
Similar to other social media networks, Pinterest has apps available for iPhone and Android devices as well as an HTML5-based mobile site.
Once a user pins something, he or she can tap on it to view more information about it via the Web, making a mobile-optimized Web site crucial to keep mobile Pinterest users engaged with content.
Therefore brands that use Pinterest need to have two main mobile focuses ? mobile Web and search.
Making sure that a brand?s mobile search is in tip-top shape will make it more likely for users to find content to share.
Brands that have already hopped on to Pinterest include West Elm, Etsy and Nordstrom. Additionally, publishers including Time Inc. and Condé Nast are also using the site to drive users to Web content from magazines such as Real Simple and Teen Vogue.
Retailers and brands need to keep in mind that as consumers are discovering items to share across their social stream, the content needs to be optimized for the mobile Web so consumers do not need to pinch and zoom to view content.
For example, Etsy uses its Pinterest account to share items that consumers can buy via the online retailer. When users view an item on a handset, Pinterest realizes that the user is accessing the site via mobile and redirects her to Etsy?s mobile site where she can buy the product.
Because Etsy has both a Web site and a mobile site, the online retailer is able to drive sales effectively via Pinterest.
West Elm uses its Pinterest account to share both its products and images of home décor to inspire consumers to decorate their own homes. When users tap on a pin of a West Elm product to learn more, they are taken to the retailer?s mobile Web site where they can buy the item.
?Brands have a fantastic opportunity with Pinterest Mobile to monitor not only what a user is interested in gaining from them, but also how they are interacting with the brand in their daily lives,? Ms. Smith said.
In-store opportunity
Pinterest users can also upload their own pictures via their mobile devices by taking pictures of things they like, showing the opportunity for retailers to leverage an in-store experience with the social networking platform.
For example, a retailer could use a mobile call-to-action in its bricks-and-mortar stores to encourage users to share products they like on their Pinterest boards. Users can then tag the photo with metadata information to share the content.
?For mobile marketers, I see Pinterest as a connection between combining a product in its sales environment and being able to share it with a community,? said Peter DiBart, regional vice president for Metia, New York.
By using a Pinterest call-to-action in-store, retailers could give users instant access to more information about a product, similar to a mobile bar code.
Additionally, retailers could take advantage of location to serve up relevant, tailored content to users while on the go. For example, retailers could use a consumer?s location to show consumers select products available in-stores while they are shopping.
Pins can also include prices, which means that for online retailers such as Etsy, consumers could make price comparisons while shopping, showing an opportunity to drive online sales.
Pinterest is based around the idea of adding value to what consumers see across the Web by letting them share it with friends and family.
?Pinterest is not about putting all of a brand?s products online ? it is about building a relationship around the products,? Mr. DiBart said.
?You have to apply the shared values of a product to a brand on Pinterest,? he said.
Pinterest?s revenue model is still somewhat unclear, but the site could begin using sponsored posts and advertising in the future to bring in money, similar to the ad models behind Facebook and Twitter according to Mr. DiBart.
?I think it can become a really powerful tool for brands to engage with their audiences," said Aapo Markkanen, London-based senior analyst for consumer mobility at ABI Research.
?Sharing in Pinterest is very visual and frictionless and built around common interests, so there is an obvious fit for brands to connect with people,? he said.
?Advertising is a natural revenue source. It could also make money from charging firms for operating in Pinterest.?
Final Take
Lauren Johnson is editorial assistant on Mobile Marketer, New York


text:
(R.A.D. Stainforth and lemons and so on...)
Those lemons I bought at Christmas
|Joseph Lorusso
|Joseph Lorusso
2 works of art.ReplyDelete
Thank you, Phil...Delete
priorities. Lemons will keep and kisses are sweeterReplyDelete
...ah, that's rather an intimate way of squeezing lemons... and i just love the reference to bloody marys... hmmn... i think R.A.D. missed this one... delicious words Tess... as always... tnx for the treat... smiles...ReplyDelete
R.A.D. is coming...just running a little late this week...Delete
Dear Tess ... I giggled out loud as I read your poem! Wonderful way to begin my day.ReplyDelete
This is an example of good taste(s) in poetry.ReplyDelete
Great fun, and not too far removed from mine.ReplyDelete
Sweet... love the final couplet.ReplyDelete
That picture is DevineReplyDelete
Wow ... this is delicious !!!ReplyDelete
yummy and sexy!ReplyDelete
Like William Carlos Williams.... You shouldn't have - but you did. :)ReplyDelete
If the picture is indicative of the reason why those lemons are still in the fridge, then slathering curd on holiday toast, delicious as it sounds, would happily wait.
Anyway, the lemons will freeze and make even better curd (I've tried this!), the fun won't wait!
i like my pucker forgot preoccupied with pressing
Initiated Kiss
This had me slathering and slurping.ReplyDelete
Lovely unexpected write- I feel for those poor sad lost and forgotten lemons!ReplyDelete
Well, I want to hear this one read aloud.ReplyDelete
brilliant, and funny tooReplyDelete
I was happy at the Bloody Marys...but you really got me with the lodberries..ready to try that!ReplyDelete
Tess, this is so cool, at first it hadn't occurred to me, but after having read all the comments so far- it's really heated up my thoughts for Valentine's Day! What an awesome thing to do!ReplyDelete
where is rodrigo this fine afternoon??ReplyDelete
He's here now...just running a bit late...hope you come back for a listen/watch...Delete
I had the hardest time getting past the yellow. Your poem with delightfully with it.ReplyDelete
Ha! Poor forgotten lemons.ReplyDelete
Sometimes the best intentions can get forgotten with other interests!ReplyDelete
making lemonade!
Playing spoon and sugar. Now without sounding creepy, THAT'S a line I'd love to use sometime!ReplyDelete
As long as you give me credit, Rick Baker ;)Delete
What a delightful zesty kiss!ReplyDelete
Let the lemon stay on in the fridge. There are more pressing things at hand! Nicely Tess!
Fun and sexy!
Graceful, witty and rather neat...ReplyDelete
Sweet and sour and sexy!ReplyDelete
I like how preoccupied with pressing sounds like puckering up-ReplyDelete
Different enough to be interesting, beautiful enough to be different.ReplyDelete
Alan, this is exactly what I strive for in a poem...thank you so very much...Delete
I like playing spoon and sugar! thanks-ReplyDelete
ahhh ... the mistress of the double entendre has struck again! Lovely, Tess. Smiling as I read this one!ReplyDelete
You capture the sheer deliciousness of kissing...ReplyDelete
Always a smile at your sly selections. Not surprisingly, I never gave valentine's day a thought looking at this prompt...but of course! I like your light delicious treat.ReplyDelete
Sheer delight.
Yummy! I love "but my pucker forgot..."ReplyDelete
lemons and lips puckering up....nice one TessReplyDelete
lodberries... googled image & looked up the word. What is it, exactly?
Your word play is alway interesting and makes one think. Playing spoon and sugar is adorable for the month of love. Now I have to go have a listen.
Hey, has R.D.S. given up smoking? And in full color! Quite the change.Delete
Lodberries are not actually berries...they're 17th/18th century waterfront houses and warehouses in Lerwick, Shetland...Delete
Yeah...I love R.A.D. in color...trying to convince him to make it a regular thing...I think the lemon replaced the cigarette just this once...Delete
Am confused at lodberries, as I also looked it up and saw lovely pictures of fishing houses by the water. Can't imagine flaying a house, nor using one's lips to do so. Was hoping to get a clue as to what that phrase meant in these comments, but so far no dice. I was going along just fine with all the lemon and kissing lingo, mentally adding "limoncello" to one of the many lemon-related tasks I've also put off but wanted to try, and then I got hit with flaying lodberries. Just can't get my head around that.
Care to help a floundering sole? 8-)
Marcheline, the beauty of poetry is that everything doesn't have to be literal...much like a painting or music...let your mind float...Delete
It's all right that the lemons wait for as long as it takes. Longer, even.ReplyDelete
Lovely, lovely, lovely!
Anna :o]
Food and sex are such a delightful couple !ReplyDelete
Mr. Stainforth is positively Shakespearean. Alas poor Yorick. And I just wonder if a word like lodberries is part of your normal vocabulary or do you hunt for these words. Do you use a dictionary as you write? If so, which one.ReplyDelete
Suki, I didn't even make the connection...and Hamlet is my favorite! I always keep a notebook handy and jot down words and phrases that pop up in my daily conversations and so on...I don't normally use a dictionary...Delete
Love the true message in this Tess.......lovely!! :-)ReplyDelete
Wow.... I just found you here (new to your work,) but if this is an indicator of what you do, I gotta read everything! bravo!ReplyDelete
Thank you very much AJ...nice to meet you...Delete
Beautiful poem, Tess.ReplyDelete
This is just to say
love is the best intention
I have eaten
the plums...
so sweet
and so cold
Thank you dearest peeps...your kind and generous comments mean so very much to me...and thank you R.A.D. for another beautiful read...ReplyDelete
I want to go drink some sweet lemonade now.ReplyDelete


text:
When the Union Junior College was founded back in 1933, only 243 students were enrolled in classes held at the Abraham Clark High School in Roselle. Now, nearly 80 years later, Union County College encompasses 4 campuses, more than 35,000 students and it is still growing.
The one million plus alumni who have passed through the College's halls include many accomplished and prestigious individuals, some of who went straight into the workforce and others who continued on to earn a four-year degree at colleges and universities across the country. We are proud of our alumni!
Membership in the Union County College Alumni Association not only allows you to demonstrate your pride in Union County College, but there are exclusive benefits just for members. Additionally, your dues help support student scholarships, alumni programming and Union County College. Any graduate or student with 30 credits or more is eligible to join.
Union County College Alumni are also generous donors to the Shaping Our Future annual campaign, and support the Foundation's special events. You can make a gift now. Alumni have established endowed scholarships, giving back to the college that gave them their start in higher education. Three alumni representatives serve on the College's Board of Governors.
The newsletter Union Reunion is mailed three times a year to all alumni whose addresses are in the alumni computer. Current issues of the newsletter are available online. Use the bound in envelope inside the newsletter to send in personal or career news, or an address change.
Union Junior College
Union County Junior College
Union County Technical Institute
Union College


text:
No more nail trimming! Sandy Perch bird perch is a safe, gentle way to keep your bird`s foot pads healthy and it's nails rounded and trimmed. Sandy Perch bird perches are made from natural hardwood branches featuring irregular shapes. This bird perch constantly exercises your bird`s feet.
Sandy Perch Bird Perches are available in 6 sizes:
The natural tree limb shapes are great for your bird's feet. Sandy Perches have manzanita cores with brightly colored sand permanently bonded to it.
Sandy Perches won't crack, chip, or shatter if dropped so you don't have to worry about your pet's environment. They are tough enough to survive our world but work great as a natural addition to our bird's world!
Clean up is so easy with Sandy Perch products! Unlike regular concrete and mortar-type perches, the unique Sandy Perch coating is non-porous so guano and other stains cannot penetrate and cause discolorations. All you need is a quick scrubbing using a regular soft scrub brush, your favorite cleanser or soap, and some hot water. Sandy Perch products clean up quickly and are ready to be returned to the cage.
The non-toxic Sandy coating is comfortable for birds to stand on and will not dry out feet or cause sores like concrete perches tend to do, the rough texture will wear down your bird`s nails just as tree bark does in the wild.
Sandy Perch Bird Perches last for years without cracking, chipping, or shattering if dropped. Sandy Perches are dishwasher safe. If you want the very best for your pet bird, get it a Sandy Perch or two. Your bird will appreciate you so much!
Color choice is not guaranteed.
Copyright © 2020 Feather FantasyPowered by osCommerce


text:
hi Lubin
my group have used an example that is in the forum to connect between dsPIC and DAC with some modification as shown:
using mplab we downloaded the program and run it but no signal is reaching the DAC, when halting the program we found out that it is stucked at loop containing SPI1IF bit:
the connections between PIC32 and MCP4922:
pin 23 (SS bar) with pin 3 (CS bar)
pin 55 (SCK1) with pin 5 (SCK)
pin 53 (SDO1) with pin 4 (SDI)
we checked the MCP4922 with pic18 and it is fine, so we think the problem is the pic32.
we changed the constant with a counter, changed the blocks configurations, grouneded the chip select on both sides, send a 3.3V to SS bar but nothing worked.
what should we do now?? we hope you answer soon since the end of the semester is near.
PIC32MX360F512L and MCP4922
Create new topics, add your comment, remark, bugs...
Post Reply
2 posts • Page 1 of 1
PIC32MX360F512L and MCP4922
- Attachments
- spitest2.mdl
- (30.26 KiB) Downloaded 263 times
Re: PIC32MX360F512L and MCP4922
I think the problem is with the configuration of the SPI of the PIC32 in the blockset itself. though You can configure SPI1 and compile it without error, when fired in the microcontroller it does not produce any result in fact it stops in the place mentioned in the comment. Worse still if you try to configure SPI2 the compilation produces an error. But if you use exactly the same configuration with DSPIC it not only compile but works perfectly as well. So probably I ask kindly Lubbin if he could look at this problem probably he might find a solution.
Post Reply
2 posts • Page 1 of 1
Who is online
Users browsing this forum: No registered users and 1 guest


text:
Model Air Chrome
Part #: VAL-71064Acrylicos Vallejo
Model Air Chrome. The pigments used for airbrush colors are ground to the finest possible consistency. Colors can be mixed with one another or diluted with water. Model Air is presented in a 17 ml. bottle with eyedropper; This packaging prevents the paint from evaporating and drying in the container.


text:
Nashville, Tenn. - The 2010-11 academic year was one of the most memorable for Tennessee State University Tigerbelle Daniecce Ward.
She finished out the track and field season recording personal records in five events during outdoor competition and received the team's academic award during the Department of Athletics annual banquet.
To add to a successful year, within one week from representing the University with the Tennessee Consortium of International Studies' study abroad program in China, Ward became the fourth recipient of the annual Wilma Rudolph Skeeter Scholar scholarship.
The Clarksville Alumnae Chapter of Delta Sigma Theta Sorority Inc presented the award during their annual gala. The night and scholarship honors the memory of legendary TSU Tigerbelle Wilma Rudolph, just one day after what would have been her 71st birthday.
Rudolph became the first American woman to win three Olympic gold medals. She won the 100-meter dash, the 200-meter dash and anchored the 400-meter relay team.
The scholarship is given to help support a student-athlete from either Tennessee State University, her alma mater or Austin Peay State University, located in Clarksville, Rudolph's hometown. It rotates between the two schools, with this year's scholarship going to Ward, a senior nursing student at TSU.
Ward becomes the second Tigerbelle to receive the scholarship following teammate Daniell Exum. Exum was the second recipient accepting the award in 2009.
"This scholarship means so much to me because I'm a Tigerbelle, and over the years, I have learned so much about Wilma Rudolph," Ward told the The Leaf Chronicle. "To be honored with this scholarship named in her honor is more than words can express. I'm very honored to receive this award."
Ward was nominated and notified of her achievement by current TSU Assistant Athletic Director for Academic Services, Dr. Johnnie Smith. Smith is also a member of the Clarksville Alumnae Chapter of Delta Sigma Theta Sorority Inc. with the chapter presenting a $3,000 donation to the Tabernacle Christian School.
"I am so very proud of Daniecce's hardwork in the classroom, and she truly deserves this prestigious honor," said Dr. Smith. "Both Coach Cheeseborough and I are confident that she will continue to excel and reach her career goal of becoming a pediatrician."
Ward is coming off a career season in track and field after finishing third in the triple jump with a personal best, 37' 5.75" (11.42m) at the 2011 Ohio Valley Conference Championship in May.
"I think she (Daniecce) is blossoming into a tremendous student-athlete. She has improved on the field but her efforts in the classroom overshadows her feats on the field," said TSU Director of Track and Field, Chandra Cheeseborough-Guice. "We expect great things from her going into her senior season next year and we are extremely proud of her."
Ward accepted the ward within a week of her return after studying abroad in China visiting the cities of Beijing and Shanghai during her three-week stay.
Ward transferred from Lane College at the beginning of her sophomore year. She is a nursing major and native of Milwaukee, Wis., and is currently carrying a 3.5 grade point average.


text:
October 4, 2012 Great American Music Hall, San Francisco, CA
Onward Celebration poster by John Seabury
According to Moonalice legend, there once was a beautiful blue moon named Blue Moonalice. She was one of a kind, and so much more. She reflected light and joy wherever she went. On this night, she gathered her bands, her family, and the Moonalice tribe to celebrate a new adventure. Onward she will go into the world of musical theater. This show includes music by Ann Atomic (the band Ann took on the Lilith Fair tour in 2011), the Flying Other Brothers, Moonalice and the cast of "Love Bytes," the first of Ann's two musical theater projects.
Available with ONWARD poster set
Watch this show now at Moonalice.com.


text:
Events Calendar
Art Lab
February 1, 2018 4:30 pm - 6:00 pm
Thursdays: 4:30pm – 6:00pm
January 11 – May 3 Please register in advance for each semester.
Ages: 7 – 12 grades
Fees: $140 (member) and $225 (non-member) per student per semester.
Class Description: The focus is on different media and techniques guided by professional artists. For students looking to explore a new medium or advance existing techniques. Students will meet fellow artists and be given the necessary tools to prepare a portfolio for college applications. All skill levels are welcome.
Scholarships are available for members and non-members through a grant from Natrona County Prevention Coalition. Send inquiries to email@example.com.


text:
Health & Safety
Healthy. Safe. Supported. Take a meditation workshop. Learn about nutrition. Use the Wellness Center. Improve your fitness. Find out about Campus Safety. Learn about alcohol or attend an Alcoholics-Anonymous (AA) meeting. Practice good self-care.
Advocating for Your Wellness
Sponsoring Department: Wellness Center
The Wellness Advocates are a team of volunteer, peer health educators dedicated to helping you achieve optimal health and well-being. The Wellness Advocates currently address issues of alcohol, tobacco, sexual health, stress management, emotional wellness, and nutrition.
Bias Reporting
If you feel as if you have been a victim of an incident of bias, you are encouraged to report the incident to the Bias Reporting (BR) Team. It is unacceptable and a violation of university policy to harass, discriminate against or abuse any person because of his or her race, color, national origin, gender, sexual orientation, disability, religion, age or any other characteristic protected by applicable law.
Campus Safety
Sponsoring Department in another Division: Campus Safety
Loyola University Department of Campus Safety is to promote and maintain a safe and secure environment in which the University's educational mission can be successful. This department contributes to the University's mission through non-intrusive safety procedures that promote the intellectual, social, spiritual, physical and recreational aspects of students' lives. The Department's crime prevention and security programs nurture the personal growth of the students outside the classroom.
Choice. Control. Character. (Alcohol)
Sponsoring Department: Wellness Center
Your experiences at Loyola—personal interactions, opportunities and the overall environment—create new and exciting choices. Alcohol is a significant issue for many students, and they regularly face choices about it, sometimes difficult ones. Loyola's "Choice. Control. Character." initiative is intended to support you in making safe and healthy decisions about alcohol that will help you maintain control and build character.
Emergency Response Program (ERP)
The Emergency Response Plan is designed to be a basic guide for providing a response system to any emergency situation on University owned property that could cause death, serious injury, disrupt operations, or cause physical or environmental damage.
Fitness (Halas Sports Center)
Sponsoring Department: Campus Recreation
The Fitness/Wellness program at Halas Sports Center strives to provide a diverse selection of quality recreational activities for individuals to pursue fitness, wellness, and leisure opportunities which enhance their personal development and establish habits for a healthy lifestyle.
Mental Health
Sponsoring Department: Wellness Center
According to the National Institute for Health (NIH), 20% of adult U.S. Americans will need mental health treatment during their lifetime - many more will have ongoing mental health issues that prevent them from enjoying their lives. Don't suffer in silence. Loyola provides a number of resources for your optimum mental wellness.
Wellness Center
Sponsoring Department: Wellness Center
The college years are a time of transition and change. It can be challenging to seek health care on your own for the first time and not from your "regular" health care provider. Our Wellness Center staff members are experts in the health-related goals, needs, and problems of college students. We can provide you with the knowledge and skills to get healthy, stay healthy and to learn about making positive choices that will last you a lifetime.


text:
Quick Links
Academic Instruction
Working with CPS
To get the best possible experience using our site we recommend that you use Google Chrome. To visit the Chrome download page, click the Get Chrome button below. Not using IE7? Refresh your browser and this message will go away!
Get Chrome
Learn more about what Chicago Public Schools
Early Childhood Education Programs have to offer and
access Chicago Early Learning's online preschool application.
For Application information please call the
Chicago Early Learning Hotline at 312-229-1690
Find Programs
The pre-K experience is critical, as it helps 3 and 4-year-old children develop the academic and life skills that will carry them into adulthood. Pre-K provides children with essential opportunities to learn and practice the social-emotional, problem-solving, and academic skills that they will use throughout their lives.
Our high-quality Early Childhood Programs…
Through common goals and high expectations, Chicago Public Schools is dedicated to building a strong foundation and igniting a lifelong passion for learning for children and their families.
Community Partnership Program
The Office of Early Childhood Education (OECE) collaborates with the Department of
Family and Support Services (DFSS) to provide services birth to 5 years old in child care
in communities across the city to provide high quality environments where certified
early childhood educators support children's health and development.
Department of Family and Support Services
1615 W. Chicago Ave, 5th Floor
Chicago, IL 60622
312-743-0300 | Main
312-743-0400 | Fax
Chicago Public Schools funds early childhood education programs through both schools and community-based organizations. The key to choosing the right program is determining what works for your family.
Things to consider when choosing a program:
School Based Programs
Please note: Transportation will be provided for children whose Individualized Education Plan (IEP) states the provision of transportation.
Community Partnership Program
The Office of Early Childhood Education (OECE) collaborates with the Department of
Family and Support Services (DFSS) to provide services birth to 5 years old in child care
in communities across the city to provide high quality environments where certified
early childhood educators support children's health and development.
For more information, contact the Department of Family and Support Services at
Please visit chicagoearlylearning.org . You can also call the Chicago Early Learning
Hotline at (312) 229-1690 t o find out more information about programs that best meet
your family's needs.
School Year (2016 – 2017)
Please Note: The application process for School Year 2016-2017 has changed.
For more information on how and where to apply for the upcoming school year, please visit chicagoearlylearning.org .
Applications for School Year 2016-2017 can now be submitted online or at one of the City's Family Resource Centers .
School Year (2015 – 2016)
Please note: Students in temporary living situations will be enrolled without the documents listed below
Printed application forms ( English | Spanish) are available at all sites
Additional opportunities to submit applications are available throughout the year. For more information on this, please check the CPS calendar or call 312-229-1690.
As a reminder:
The application process for Tuition Based Preschool Program, Selective Enrollment and Montessori and Community Partnership Programs are handled by those individual programs. Please follow the links above or call us at 773.553.2010 for more information.
Once you have accepted a placement at a school, a visit to complete the registration packet should be scheduled between you and the school. This provides you an opportunity to not only complete additional required forms but also familiarize yourself with the classroom environment and school culture.
Prekindergarten is a major milestone in the life of a child! Help your child prepare by talking about what school might be like. Ask your child what they are thinking and feeling about going to school. Remember, what seems normal to adults may seem very overwhelming or frightening to a child at first. Feeling nervous, scared, excited, or unsure are all normal feelings. Be positive and supportive - prekindergarten will start your student on the path to becoming a lifelong learner!
Consider checking out a few of these books from the library:
For more ideas, read this great article on starting preschool from National Association for the Education of Young Children.
Preparing to Meet with Your Child's Teacher
Meeting with your child's teacher will be a two way conversation—you and the teacher will talk and listen. As the parent, you have valuable information about your child that can allow the teacher to better help your child. Your child's education is a partnership between home and school. Follow these tips for a successful meeting with your child's teacher:
For more tips, read this article from the Minnesota Parent Center or this tip sheet from the Harvard Family Research Project.
Supporting My Child's Learning and Development at Home
Your child's education is a partnership between home and school. Here are some important things you can do to support your child's learning at home:
For more tips, check out this article from Parents magazine: 20 Tips for Parents from Preschool Teachers.
Other Resources for Parents of Preschoolers
National Association for the Education of Young Children (NAEYC)'s Family Resources
Attendance Works
How to Get Your Library Card from Chicago Public Libraries
Head Start Resources on Parenting
A. You may apply to a Chicago: Ready to Learn! program in person, at an authorized application site or at an authorized application event. For a list of these events, please call the CRTL Hotline (312) 229-1690. Paper applications will be available at the application sites or can be downloaded. Please note that income, address, and proof of birth documents are required for all application submissions except for students in temporary living situations.
Tuition-Based Preschool Programs
For more information on Tuition Based Programs and how to apply, please visit the Tuition Based Preschool Programs website.
Selective Enrollment & Montessori
For more information on how to apply, please visit the Office of Access and Enrollment website.
Community Based Partnership Program
For more information, please visit the Community Based Partnership Programs website.
To search for Community Based Partnerships programs visit chicagoearlylearning.org.
To enroll in a community-based preschool program, please contact the agency directly.
The Office of Early Childhood Education's mission is to provide all children and their families access to high-quality, equitable early learning experiences leading to success in elementary school and beyond.
Office of Early Childhood Education
42 West Madison Chicago, IL 60602
(773) 553-2010
Find resources for teachers at cps.edu/kc-ece
Search school locations
Page Last Modified on Wednesday, September 18, 2019
Please enter your name.
Please enter a valid email address.
Please make a selection from the dropdown.
Chicago Public Schools is the third largest school district in the United States with more than 600 schools and serves 361,000 children. Our vision is that every student in every neighborhood will be engaged in a rigorous, well-rounded instructional program and will graduate prepared for success in college, career and life.
© 2019 Chicago Public Schools | Non-Discrimination Statement


text:
A transrectal ultrasound (TRUS) is a procedure in which a device is
placed into the rectum to help a doctor locate abnormal tissue around the
prostate gland or to collect a sample of tissue to examine (biopsy).
An ultrasound uses sound waves that bounce off solid structures.
This type of ultrasound creates a picture of the prostate gland.
Last Revised:
June 8, 2011
Healthwise Staff
Medical Review:
Adam Husney, MD - Family Medicine & Howard Schaff, MD - Diagnostic Radiology
This information does not replace the advice of a doctor. Healthwise, Incorporated disclaims any warranty or liability for your use of this information. Your use of this information means that you agree to the Terms of Use. How this information was developed to help you make better health decisions.
To learn more visit Healthwise.org
© 1995-2012 Healthwise, Incorporated. Healthwise, Healthwise for every health decision, and the Healthwise logo are trademarks of Healthwise, Incorporated.


text:
James Inflames has made a great video for my latest song. I'm really pleased with the way it captures the atmosphere.
https://www.youtube.com/watch?v=igpmrc1 ... e=youtu.be
Dig Beneath the Dust
A place for your creative output - music, photos, videos, poetry, whatever
Moderators: marowak, Blonde, skhmmxi
Post Reply
1 post • Page 1 of 1
- NickSouthampton
- Posts: 153
- Joined: Wed Apr 23, 2014 2:53 pm
Dig Beneath the Dust
Nick in "Sunny" Southampton.
Post Reply
1 post • Page 1 of 1
Who is online
Users browsing this forum: No registered users and 1 guest


text:
Various sources report success with this approach with a couple important caveats:
- How much bus traffic will there be?
Harvard emphasizes increased shuttle bus service in its transportation plan for its new campus. The Urban Ring's proposal for Rapid Bus Transit includes high-frequency buses in a system designed to maximize the speed of the buses.
- How much space does a bus/bike lane need?
According to bicyclinginfo.org, Madison, WI uses 16 foot lanes to allow a clear three feet of separation between the bicyclist and a passing bus. Putting one of these in each direction on a two-way road would require 32 feet of width.
Considering that Western Ave and North Harvard Street are approximately 45 feet wide, there obviously is no space for a travel lane in each direction (~10' each), on-street parking lanes (~8' each), and these bus-bike lanes. Even without on-street parking, a two-way road would need 52 feet for travel lanes and bus/bike lanes. Maybe our roads should be wider, maybe some of them should be one-way, but neither of those solutions seem obvious or simple.
The Harvard shuttle bus / bicycle accident that occurred on Sunday morning is an important reminder that the safe design of our roads deserves significantly more attention.


text: Times New Viking is a lo-fi indie rock band from Columbus, Ohio. The lineup consists of guitarist Jared Phillips, drummer Adam Elliott, and Beth Murphy on keyboards. Murphy and Elliott share vocal duties. They are currently signed to Matador Records and were formerly signed to Siltbreeze Records. They have released three records: 2005's Dig Yourself, 2007's Present the Paisley Reich, and 2008's Rip It Off, which NME gave an 8/10. Rip it Off reached #17 on the Billboard Heatseekers chart.


text:
For Immediate Release:
May 29, 2007
For Further Information Contact:
Adam Kokesh ###-###-####
Kevin Zeese 301-996-6582
In Unprecedented Prosecution Former Marine Adam Kokesh Rejects Plea Bargain
Fights to Protect Free Speech Rights of Vets
Washington, DC: Former Marine Sergeant Adam Kokesh is embroiled in a conflict that could have major implications for the free speech rights of veterans especially recent Vets who are in the Inactive Ready Reserve. Kokesh is facing an administrative hearing for his anti-war activities but recognizing the high stakes the military has offered a plea bargain. In response, Kokesh rejected the offer saying it risks the "free speech rights" of vets and "allow you to silence the voices of those whose experiences are most relevant in the most pressing debate before the nation." Below this release is his letter to Captain Sibert and Brigadier General Moore, who is the convening authority for the hearing.
This Friday at 5:00 PM at Union Station Kokesh will be participating in a press conference when he departs to Kansas City, MO for the hearing which is scheduled for June 4th at the Marine Mobilization Command. Adam Kokesh, his attorney, and his witnesses, will be taking the Yellow Rose of Texas Peace Bus from DC to Kansas City.
Adam Kokesh was deployed to Fallujah and received an honorable discharge last November. Since then, he has become active with the national organization, Iraq Veterans Against the War. After participating in Operation First Casualty, a demonstration at which he wore parts of his utility uniform, he received a warning from Major Whyte, an active duty Marine Corps Major who had been assigned to investigate the incident. After replying with a strongly worded email, the Marine Corps decided to prosecute him and separate him from the IRR with an Other Than Honorable Discharge. He could have ignored the letter of notification, but instead chose to exercise his right to challenge the decision in a hearing.
The implications of this hearing may be far reaching, as the prosecution of a member of the inactive reserves under these circumstances is unprecedented. At stake is the right of freedom of speech for the hundreds of thousands of members of the Inactive Ready Reserve, as well as the nation's right to get the unbiased truth out of Iraq. Last week, the prosecuting attorney, Captain Sibert, offered Kokesh a general discharge. To accept this would be to allow the Marines to say that members of the IRR do not have freedom of speech, so naturally, he declined.
The hearing will be held on June 4, at the Marine Corps Mobilization Command in Kansas City, MO. Kokesh requested the hearing be held closer to Washington, DC, his current residence and a much more convenient location for the witnesses to the event in question, which happened in Washington, but was denied. He has the right to call witnesses, but has to provide for their transportation.
Adam Kokesh is represented by Mike Lebowitz and Eric Seitz. Mike Lebowitz is a combat veteran of Iraq, having been deployed in 2005-2006 as a paratrooper in the Pathfinder Company of the 101st Airborne Division. Lebowitz currently serves part-time as a JAG officer in the National Guard. He also is an attorney at the Washington, DC-based intellectual property law firm of Greenberg & Lieberman. Mike practices media law, First Amendment and military expression. He previously worked as a journalist and consultant in places such as East Africa and the Middle East. Ph: 202-625-7000, Fx: 202-625-7001, cell: 571-251-1490. Eric Seitz is an attorney engaged in private practice in Honolulu, Hawaii emphasizing civil rights, criminal defense, and military law. Mr. Seitz graduated from Oberlin College in 1966 and received his law degree from Boalt Hall (University of California at Berkeley) in 1969. Among the thousands of military cases in which he has participated Mr. Seitz represented Navy FN Patrick Chenoweth who was acquitted in a general court-martial of sabotage in time of war, Marine Cpl. Jeff Paterson who was the first service member to refuse to deploy during the first Gulf War, and most recently Army 1st Lt. Ehren Watada who refused to deploy to Iraq.
# # #
Dear Captain Sibert and Brigadier General Moore,
As an esteemed US Attorney and a General, you both must have a sense of the potential significance of my separation hearing. The prosecution of a member of the inactive reserve under these circumstances is unprecedented. As citizens, we all have a right to freedom of speech. In the Marines, we often joke that you signed away that freedom, and I understand the necessity for certain restrictions while on active duty. But those who have risked their lives to defend the rights of all Americans have a special claim to those rights when they have completed their service. Is the Marine Corps attempting to strip away those rights from the hundreds of thousands in the inactive reserves?
Maybe that's not the case. Perhaps I am being singled out because I have become a vocal opponent of the war. Maybe Brigadier General Darrell L. Moore just got upset when he saw a picture of a Marine in the paper disagreeing with him. Maybe that's when he decided to order Colonel Steve Brown, Deputy Commander of the Mobilization Command to recommend that I be separated with an Other Than Honorable Discharge. Maybe he thought that I would be intimidated by the long letter, the official letterhead, and the threats in official Marine Corps terminology. Maybe he thought that I would just ignore it, and let the Marines "paper-f***" me behind my back. Maybe I would shut up for a while. But let me tell you, you messed with the wrong veteran.
While there may be some purpose of this prosecution in order to maintain the, "good order and discipline" of the inactive reserve, it is clear by its prejudice that it is intended to silence the voices of dissent. Thousands of taxpayers' dollars are being spent on this case. I love the Marine Corps, and to see it abused for political ends makes me sick. You should all be ashamed to call yourselves Marines.
I joined the Marines out of patriotism. I said that when I enlisted in 1999, before it was cool, and even wrote it as my reason on the form I filled out at the Military Entrance Processing Station. As Thomas Jefferson said, "Dissent is the highest form of patriotism." Now that I am out of the Marines, I am continuing my patriotic duty by speaking out. It is Marines like you, Brigadier General Moore, and Colonel Brown, who are preventing the American public from hearing the truth about Iraq by intimidating those who would disagree with you from speaking out. If the policies that you support are so righteous, why are you afraid of the truth?
If I accept this "plea bargain," I would have to allow you to punish me for speaking my mind, allow you to say that it is somehow less than honorable for thousands of IRR Marines to exercise their freedom of speech, allow you to silence the voices of those whose experiences are most relevant in the most pressing debate before the nation, and allow you to say that Thomas Jefferson was wrong. If this is your intent, I would ask to please, kindly, go f*** yourself. I will not allow it.
Semper Fi,
Adam Kokesh, PFC
Proud F***ing Civilian


text:
Guide to Teaching Online Courses
download the full document
Guide to Teaching Online Courses ( PDF, 1.3MB, 32pgs.)
NEA's "Guide to Teaching Online Courses" was developed to help ensure the quality of online instruction to secondary students in the United States. It is meant to serve as a guide for policymakers, administrators, educators, and others engaged in selecting, hiring, training, and supporting teachers to provide quality online instruction to students, or in making policy choices affecting online education.
Barbara Stein, NEA's manager of 21st Century Initiatives, said, "This document demonstrates that fully involved teachers are the linchpin of quality online education, and provides detailed information on the support and preparation teachers need, and the role they play."
It is designed to provide an overview of the development of an effective online education system, focusing particularly on the skills teachers need to teach effectively online, the professional development necessary to acquire those skills, and the models schools need to evaluate and improve online teaching.
NEA and its partners in developing the Guide believe it's "critically important that school systems and school administrators contemplate such issues before launching online courses or enrolling significant numbers of their students in such courses. Crucial lessons from decades of offline instruction are applicable, and the body of new and instructive information about the unique nature of online education is growing every day."
This latest Guide complements an earlier publication, Guide to Online High School Courses, that sets forth criteria for quality online courses, seeking to empower students, parents, educators, administrators, and policymakers to assess the quality of online courses and to help them establish quality standards for courses of their own design.
By contrast, this publication is focused on ensuring that the teachers leading online courses are of the highest quality, well equipped, trained, and supported for the many challenges of educating today's students via online instructional delivery.
The organizations collaborating in the creation of the online teaching guide are:
- International Society for Technology in Education (ISTE)
- National Education Association
- North American Council for Online Learning
- National Commission for Teaching and America's Future
- Virtual High School, Inc.


text:
Sunday School – 10:00 am
Worship Service – 11:00 am
Bible Study – 12:15 pm
Wednesday Bible Study - 6:30 pm
12859 Martin Road Spur
Northport, AL 35473
Watering the Tulips
August 8, 2012
"Now godliness with contentment is great gain"– 1 Timothy 6:6
Americans, by and large, are living on the brink of financial collapse. Many regularly spend more than they bring in. Multitudes have more credit card debt than they ever intend to pay back. Millions have built up massive debt for things they do not need. Logic escapes us when we consider that we are the best paid society on the planet. Worse yet, many if not most believers have fallen prey to the same schemes that those of this world have.
Why should we even deal with this in a weekly Bible-based article? Well, the problem is a spiritual one. Our text verse explains plainly that "godliness with contentment is great gain". However, we are taught from a young age in America not to be content with what we have. There is always something better and we ought to want it whether it is clothes, homes, new cars, or any other item. This whole attitude is destroying our financial stability from homes to our government.
So, what is the real problem? The answer is two-fold. First, we as Americans (and even as believers, sadly) are often not content with the lot we have been given by God. In reality, this means we do not trust our Heavenly Father to supply our needs. Or worse, we believe we know more about running our lives than He does. Certainly, God has promised to supply all our needs (Philippians 4:19). However, as a good Heavenly Father He frequently withholds things that we want because He knows what's best. However, this can be frustrating to us. That makes us as believers little better than a spoiled brat child.
The second problem can be traced all the way to the root of the financial crisis in America. Frankly, we are a covetous society. Webster's 1828 Dictionary defines "covetous" as "Very desirous; eager to obtain". Covetous is a great sin in God's sight. Paul says that covetous people will not inherit the kingdom of God (1 Corinthians 6:10). Worse yet, he declares that covetousness is equated with idolatry in Colossians 3:5. Most of us can easily recognize sins like immorality, drunkenness and drug abuse. But, what worse sin can there be than idolatry? Certainly, this sheds a different light on the sin of covetousness.
Children of God, American humanism and covetousness are working against your faith. Many of us have gotten ourselves in a financial bind because of our own refusal to follow God's truths. Obviously, this means we have fallen prey to the temptations of this world. Let us commit this moment to follow the instructions of God's Word so that we may have time to serve Him as we should.
Watering the Tulipsis brought to you by Sovereign Grace Baptist Church in Northport, AL. For more information, please visit www.sovereigngrace.net. "Your app to the Gospel" is available in the iTunes app store as well as Google Play for Android devices. Please download it today!


text:
May 2013
Cover Story
Get Moving!
From yoga and tai chi to kettlebells and volkswalking, some NEA-Retired members find that old-school exercises hold the key to fitness.
NEA Retired President's Message
Activism: Everyone Has a Role!
Retiree Robert Wesolowski continues to fight for public education.
Classroom to Cézanne
Retired teachers infuse an Oregon community with art.
From NEA Today
New teachers get help from their veteran counterparts.
Learning sign language can benefit all children.
Aging Buildings
Aging schools create hazardous learning environments.
What I've Learned
For a Vermont history teacher,creativity is the key to keeping students engaged.


text:
Using Statistics to Improve Query Performance
The query optimizer uses statistics to create query plans that improve query performance. For most queries, the query optimizer already generates the necessary statistics for a high quality query plan; in a few cases, you need to create additional statistics or modify the query design for best results.
This topic discusses the following concepts and guidelines for using query optimization statistics effectively:
What are Query Optimization Statistics?
Using the Database-Wide Statistics Options
Determining When to Create Statistics
Determining When to Update Statistics
Designing Queries that Use Statistics Effectively
For more information about the query plan and how it relates to query performance, see Analyzing a Query.
What Are Query Optimization Statistics?
Statistics for query optimization are objects that contain statistical information about the distribution of values in one or more columns of a table or indexed view. The query optimizer uses these statistics to estimate the cardinality, or number of rows, in the query result. These cardinality estimates enable the query optimizer to create a high-quality query plan. For example, the query optimizer could use cardinality estimates to choose the index seek operator instead of the more resource-intensive index scan operator, and in doing so improve query performance.
Each statistics object is created on a list of one or more table columns and includes a histogram displaying the distribution of values in the first column. Statistics objects on multiple columns also store statistical information about the correlation of values among the columns. These correlation statistics, or densities, are derived from the number of distinct rows of column values. For more information about statistics objects, see DBCC SHOW_STATISTICS (Transact-SQL).
Filtered Statistics
Filtered statistics can improve query performance for queries that select from well-defined subsets of data. Filtered statistics use a filter predicate to select the subset of data that is included in the statistics. Well-designed filtered statistics can improve the query execution plan compared with full-table statistics. For more information about the filter predicate, see CREATE STATISTICS (Transact-SQL). For more information about when to create filtered statistics, see the Determining When to Create Statistics section in this topic. For a case study, see the blog entry, Using Filtered Statistics with Partitioned Tables, on the SQLCAT Web site.
Using the Database-Wide Statistics Options
It is important to understand what the following database-wide statistics options do and to verify they are set appropriately:
Using the AUTO_CREATE_STATISTICS Option
When the automatic create statistics option, AUTO_CREATE_STATISTICS, is on, the query optimizer creates statistics on individual columns in the query predicate, as necessary, to improve cardinality estimates for the query plan. These single-column statistics are created on columns that do not already have a histogram in an existing statistics object.
You can use the following query to determine if the query optimizer has created statistics for a query predicate column. It queries the catalog views sys.stats and sys.stats_columns to return the database object name, the column name, and the statistics name for all of the columns that have single-column statistics. When the query optimizer creates statistics on single columns as a result of using the AUTO_CREATE_STATISTICS option, the statistics name starts with _WA.
USE AdventureWorks;
SELECT OBJECT_NAME(s.object_id) AS object_name,
COL_NAME(sc.object_id, sc.column_id) AS column_name,
s.name AS statistics_name
FROM sys.stats AS s Join sys.stats_columns AS sc
ON s.stats_id = sc.stats_id AND s.object_id = sc.object_id
WHERE s.name like '_WA%'
ORDER BY s.name;
The AUTO_CREATE_STATISTICS option does not determine whether statistics get created for indexes. This option also does not generate filtered statistics. It applies strictly to single-column statistics for the full table.
Using the AUTO_UPDATE_STATISTICS Option
When the automatic update statistics option, AUTO_UPDATE_STATISTICS, is on, the query optimizer determines when statistics might be out-of-date and then updates them when they are used by a query. Statistics become out-of-date after insert, update, delete, or merge operations change the data distribution in the table or indexed view. The query optimizer determines when statistics might be out-of-date by counting the number of data modifications since the last statistics update and comparing the number of modifications to a threshold. The threshold is based on the number of rows in the table or indexed view.
The query optimizer checks for out-of-date statistics before compiling a query and before executing a cached query plan. Before compiling a query, the query optimizer uses the columns, tables, and indexed views in the query predicate to determine which statistics might be out-of-date. Before executing a cached query plan, the Database Engine verifies that the query plan references up-to-date statistics.
The AUTO_UPDATE_STATISTICS option applies to statistics objects created for indexes, single-columns in query predicates, and statistics created with the CREATE STATISTICS statement. This option also applies to filtered statistics.
Setting AUTO_CREATE_STATISTICS and AUTO_UPDATE_STATISTICS Options To On
The automatic create statistics option, AUTO_CREATE_STATISTICS, and the automatic update statistics option, AUTO_UPDATE_STATISTICS, are on by default and we recommend using the default for most user databases. You can use the following SELECT statement to view the current values of these options for all user databases:
SELECT name AS "Name",
is_auto_create_stats_on AS "Auto Create Stats",
is_auto_update_stats_on AS "Auto Update Stats",
is_read_only AS "Read Only"
FROM sys.databases
WHERE database_ID > 4;
The following example sets AUTO_CREATE_STATISTICS and AUTO_UPDATE_STATISTICS to ON for the AdventureWorks2008R2 database:
USE AdventureWorks2008R2;
ALTER DATABASE AdventureWorks2008R2
ALTER DATABASE AdventureWorks2008R2
For more information about how to set these statistics options, see ALTER DATABASE SET Options (Transact-SQL).
Disabling and Re-enabling AUTO_UPDATE_STATISTICS for Some Statistics
When AUTO_UPDATE_STATISTICS is on, you can override the database-wide statistics update behavior and set automatic statistics updates off for an individual table, index, or column, as required by your application. When AUTO_UPDATE_STATISTICS is on, you can disable and re-enable automatic statistics updates for a table, index, or column in the following ways:
Use the sp_autostats system stored procedure. This can disable or re-enable statistics updates for a table or index.
Specify the NORECOMPUTE option with the UPDATE STATISTICS statement. To re-enable statistics updates rerun UPDATE STATISTICS without the NORECOMPUTE option.
Specify the NORECOMPUTE option with the CREATE STATISTICS statement. To re-enable statistics updates, remove the statistics with DROP STATISTICS and then run CREATE STATISTICS without the NORECOMPUTE option.
Specify the STATISTICS_NORECOMPUTE option with the CREATE INDEX statement. To re-enable statistics updates, you can run ALTER INDEX with STATISTICS_NORECOMPUTE = OFF.
When AUTO_UPDATE_STATISTICS is off, you cannot set automatic updates to on for an individual table, index, or column. Re-enabling automatic statistics updates restores the behavior specified by the AUTO_UPDATE_STATISTICS option. If the AUTO_UPDATE_STATISTICS option is off, statistics updates will not occur.
When to Use Synchronous or Asynchronous Statistics Updates
Statistics updates can be either synchronous (the default) or asynchronous. With synchronous statistics updates, queries always compile and execute with up-to-date statistics; When statistics are out-of-date, the query optimizer waits for updated statistics before compiling and executing the query. With asynchronous statistics updates, queries compile with existing statistics even if the existing statistics are out-of-date; The query optimizer could choose a suboptimal query plan if statistics are out-of-date when the query compiles. Queries that compile after the asynchronous updates have completed will benefit from using the updated statistics.
The database-wide asynchronous statistics update option, AUTO_UPDATE_STATISTICS_ASYNC, determines whether the query optimizer uses synchronous or asynchronous statistics updates. By default, the asynchronous statistics update option is off, and the query optimizer updates statistics synchronously. The AUTO_UPDATE_STATISTICS_ASYNC option applies to statistics objects created for indexes, single columns in query predicates, and statistics created with the CREATE STATISTICS statement.
You can use the following command to view the automatic update asynchronous option for all databases:
SELECT name AS "Name",
is_auto_update_stats_async_on AS "Asynchronous Update"
FROM sys.databases;
Consider using synchronous statistics for the following scenario:
- You perform operations that change the distribution of data, such as truncating a table or performing a bulk update of a large percentage of the rows. If you do not update the statistics after completing the operaton, using synchronous statistics will ensure statistics are up-to-date before executing queries on the changed data.
Consider using asynchronous statistics to achieve more predictable query response times for the following scenarios:
Your application frequently executes the same query, similar queries, or similar cached query plans. Your query response times might be more predictable with asynchronous statistics updates than with synchronous statistics updates because the query optimizer can execute incoming queries without waiting for up-to-date statistics. This avoids delaying some queries and not others. For more information about finding similar queries, see Finding and Tuning Similar Queries by Using Query and Query Plan Hashes.
Your application has experienced client request time outs caused by one or more queries waiting for updated statistics. In some cases, waiting for synchronous statistics could cause applications with aggressive time outs to fail.
Determining When to Create Statistics
The query optimizer already creates statistics in the following ways:
The query optimizer creates statistics for indexes on tables or views when the index is created. These statistics are created on the key columns of the index. If the index is a filtered index, the query optimizer creates filtered statistics on the same subset of rows specified for the filtered index. For more information about filtered indexes, see Filtered Index Design Guidelines and CREATE INDEX (Transact-SQL).
The query optimizer creates statistics for single columns in query predicates when AUTO_CREATE_STATISTICS is on.
For most queries, these two methods for creating statistics ensure a high-quality query plan; in a few cases, you can improve query plans by creating additional statistics with the CREATE STATISTICS statement. These additional statistics can capture statistical correlations that the query optimizer does not account for when it creates statistics for indexes or single columns. Your application might have additional statistical correlations in the table data that, if calculated into a statistics object, could enable the query optimizer to improve query plans. For example, filtered statistics on a subset of data rows or multicolumn statistics on query predicate columns might improve the query plan.
When creating statistics with the CREATE STATISTICS statement, we recommend keeping the AUTO_CREATE_STATISTICS option on so that the query optimizer continues to routinely create single-column statistics for query predicate columns. For more information about query predicates, see Search Condition (Transact-SQL).
Consider creating statistics with the CREATE STATISTICS statement when any of the following applies:
The Database Engine Tuning Advisor suggests creating statistics.
The query predicate contains multiple correlated columns that are not already in the same index.
The query selects from a subset of data.
The query has missing statistics.
Database Engine Tuning Advisor Suggests Creating Statistics
The Database Engine Tuning Advisor is a a tool that analyzes the performance effects of workloads on one or more databases. It offers recommendations for improving performance (such as suggesting indexes to create) and might suggest using CREATE STATISTICS to create query optimization statistics. You should follow this recommendation. For more information about the Database Engine Tuning Advisor, see Tuning the Physical Database Design.
Query Predicate Contains Multiple Correlated Columns
When a query predicate contains multiple columns that have cross-column relationships and dependencies, statistics on the multiple columns might improve the query plan. Statistics on multiple columns contain cross-column correlation statistics, called densities, that are not available in single-column statistics. Densities can improve cardinality estimates when query results depend on data relationships among multiple columns.
If the columns are already in the same index, the multicolumn statistics object already exists and it is not necessary to create it manually. If the columns are not already in the same index, you can create multicolumn statistics by creating an index on the columns or by using the CREATE STATISTICS statement. It requires more system resources to maintain an index than a statistics object. If the application does not require the multicolumn index, you can economize on system resources by creating the statistics object without creating the index.
When creating multicolumn statistics, the order of the columns in the statistics object definition affects the effectiveness of densities for making cardinality estimates. The statistics object stores densities for each prefix of key columns in the statistics object definition. For more information about densities, see DBCC SHOW_STATISTICS (Transact-SQL).
To create densities that are useful for cardinality estimates, the columns in the query predicate must match one of the prefixes of columns in the statistics object definition. For example, the following creates a multicolumn statistics object on the columns LastName, MiddleName, and FirstName.
USE AdventureWorks2008R2;
IF EXISTS (SELECT name FROM sys.stats
WHERE name = 'LastFirst'
AND object_ID = OBJECT_ID ('Person.Person'))
DROP STATISTICS Person.Person.LastFirst;
CREATE STATISTICS LastFirst ON Person.Person (LastName, MiddleName, FirstName);
In this example, the statistics object LastFirst has densities for the following column prefixes: (LastName), (LastName, MiddleName), and (LastName, MiddleName, FirstName). The density is not available for (LastName, FirstName). If the query uses LastName and FirstName without using MiddleName, the density is not available for cardinality estimates.
Query Selects from a Subset of Data
When the query optimizer creates statistics for single columns and indexes, it creates the statistics for the values in all rows. When queries select from a subset of rows, and that subset of rows has a unique data distribution, filtered statistics can improve query plans. You can create filtered statistics by using the CREATE STATISTICS statement with the WHERE clause to define the filter predicate expression.
For example, using AdventureWorks2008R2, each product in the Production.Product table belongs to one of four categories in the Production.ProductCategory table: Bikes, Components, Clothing, and Accessories. Each of the categories has a different data distribution for weight: bike weights range from 13.77 to 30.0, component weights range from 2.12 to 1050.00 with some NULL values, clothing weights are all NULL, and accessory weights are also NULL.
Using Bikes as an example, filtered statistics on all bike weights will provide more accurate statistics to the query optimizer and can improve the query plan quality compared with full-table statistics or nonexistent statistics on the Weight column. The bike weight column is a good candidate for filtered statistics but not necessarily a good candidate for a filtered index if the number of weight lookups is relatively small. The performance gain for lookups that a filtered index provides might not outweigh the additional maintenance and storage cost for adding a filtered index to the database.
The following statement creates the BikeWeights filtered statistics on all of the subcategories for Bikes. The filtered predicate expression defines bikes by enumerating all of the bike subcategories with the comparison Production.ProductSubcategoryID IN (1,2,3). The predicate cannot use the Bikes category name because it is stored in the Production.ProductCategory table, and all columns in the filter expression must be in the same table.
USE AdventureWorks2008R2;
IF EXISTS ( SELECT name FROM sys.stats
WHERE name = 'BikeWeights'
AND object_ID = OBJECT_ID ('Production.Product'))
DROP STATISTICS Production.Product.BikeWeights;
CREATE STATISTICS BikeWeights
ON Production.Product (Weight)
WHERE ProductSubcategoryID IN (1,2,3);
The query optimizer can use the BikeWeights filtered statistics to improve the query plan for the following query that selects all of the bikes that weigh more than 25.
SELECT P.Weight AS Weight, S.Name AS BikeName
FROM Production.Product AS P
JOIN Production.ProductSubcategory AS S
ON P.ProductSubcategoryID = S.ProductSubcategoryID
WHERE P.ProductSubcategoryID IN (1,2,3) AND P.Weight > 25
ORDER BY P.Weight;
Query Has Missing Statistics
If an error or other event prevents the query optimizer from creating statistics, the query optimizer creates the query plan without using statistics. The query optimizer marks the statistics as missing and attempts to regenerate the statistics the next time the query is executed.
Missing statistics are indicated as warnings (table name in red text) when the execution plan of a query is graphically displayed using SQL Server Management Studio. For more information, see Displaying Graphical Execution Plans (SQL Server Management Studio). Additionally, monitoring the Missing Column Statistics event class by using SQL Server Profiler indicates when statistics are missing. For more information, see Errors and Warnings Event Category (Database Engine).
If statistics are missing, perform the following steps:
Verify that AUTO_CREATE_STATISTICS and AUTO_UPDATE_STATISTICS are on.
Verify that the database is not read-only. If the database is read-only, the query optimizer cannot save statistics.
Create the missing statistics by using the CREATE STATISTICS statement.
Determining When to Update Statistics
The query optimizer determines when statistics might be out-of-date and then updates them when they are needed for a query plan. In some cases you can improve the query plan and therefore improve query performance by updating statistics more frequently than occur when AUTO_UPDATE_STATISTICS is on. You can update statistics with the UPDATE STATISTICS statement or the stored procedure sp_updatestats.
Updating statistics ensures that queries compile with up-to-date statistics. However, updating statistics causes queries to recompile. We recommend not updating statistics too frequently because there is a performance tradeoff between improving query plans and the time it takes to recompile queries. The specific tradeoffs depend on your application.
When updating statistics with UPDATE STATISTICS or sp_updatestats, we recommend keeping AUTO_UPDATE_STATISTICS set to ON so that the query optimizer continues to routinely update statistics. For more information about how to update statistics on a column, an index, a table, or an indexed view, see UPDATE STATISTICS (Transact-SQL). For information about how to update statistics for all user-defined and internal tables in the database, see the stored procedure sp_updatestats (Transact-SQL). For example, the following command calls sp_updatestats to update all statistics for the database.
EXEC sp_updatestats
To determine when statistics were last updated, use the STATS_DATE function.
Consider updating statistics for the following conditions:
Query execution times are slow.
Insert operations occur on ascending or descending key columns.
After maintenance operations.
Query Execution Times Are Slow
If query response times are slow or unpredictable, ensure that queries have up-to-date statistics before performing additional troubleshooting steps. For more information about troubleshooting slow-running queries, see Checklist for Analyzing Slow-Running Queries.
Insert Operations Occur on Ascending or Descending Key Columns
Statistics on ascending or descending key columns, such as IDENTITY or real-time timestamp columns, might require more frequent statistics updates than the query optimizer performs. Insert operations append new values to ascending or descending columns. The number of rows added might be too small to trigger a statistics update. If statistics are not up-to-date and queries select from the most recently added rows, the current statistics will not have cardinality estimates for these new values. This can result in inaccurate cardinality estimates and slow query performance.
For example, a query that selects from the most recent sales order dates will have inaccurate cardinality estimates if the statistics are not updated to include cardinality estimates for the most recent sales order dates.
After Maintenance Operations
Consider updating statistics after performing maintenance procedures that change the distribution of data, such as truncating a table or performing a bulk insert of a large percentage of the rows. This can avoid future delays in query processing while queries wait for automatic statistics updates.
Do not update statistics after operations such as rebuilding, defragmenting, or reorganizing an index. These operations do not change the distribution of data and have no impact on statistics. Note, however, that the query optimizer updates statistics when you rebuild an index on a table or view by using ALTER INDEX REBUILD or DBCC DBREINDEX. This occurs as a byproduct of the internal implementation of these operations and is not done because statistics need to be updated. The query optimizer does not update statistics after defragmentation or reorganization operations because these operations do not drop and recreate the index.
Designing Queries That Use Statistics Effectively
Certain query implementations, such as local variables and complex expressions in the query predicate, can lead to suboptimal query plans. Following query design guidelines for using statistics effectively can help to avoid this. For more information about query predicates, see Search Condition (Transact-SQL).
You can improve query plans by applying query design guidelines that use statistics effectively to improve cardinality estimates for expressions, variables, and functions used in query predicates. When the query optimizer does not know the value of an expression, variable, or function, it does not know which value to lookup in the histogram and therefore cannot retrieve the best cardinality estimate from the histogram. Instead, the query optimizer bases the cardinality estimate on the average number of rows per distinct value for all of the sampled rows in the histogram. This leads to suboptimal cardinality estimates and can hurt query performance.
The following guidelines describe how to write queries to improve query plans by improving cardinality estimates.
Improving Cardinality Estimates for Expressions
To improve cardinality estimates for expressions, follow these guidelines:
Whenever possible, simplify expressions with constants in them. The query optimizer does not evaluate all functions and expressions containing constants prior to determining cardinality estimates. For example, simplify the expression ABS(-100) to 100.
If the expression uses multiple variables, consider creating a computed column for the expression and then create statistics or an index on the computed column. For example, the query predicate WHERE PRICE + Tax > 100 might have a better cardinality estimate if you create a computed column for the expression Price + Tax.
Improving Cardinality Estimates for Variables and Functions
To improve the cardinality estimates for variables and functions, follow these guidelines:
If the query predicate uses a local variable, consider rewriting the query to use a parameter instead of a local variable. The value of a local variable is not known when the query optimizer creates the query execution plan. When a query uses a parameter, the query optimizer uses the cardinality estimate for the first actual parameter value that is passed to the stored procedure.
Consider using a standard table or temporary table to hold the results of multi-statement table-valued functions. The query optimizer does not create statistics for multi-statement table-valued functions. With this approach the query optimizer can create statistics on the table columns and use them to create a better query plan. For more information about multi-statement table-valued functions, see Types of Functions.
Consider using a standard table or temporary table as a replacement for table variables. The query optimizer does not create statistics for table variables. With this approach the query optimizer can create statistics on the table columns and use them to create a better query plan. There are tradeoffs in determining whether to use a temporary table or a table variable; Table variables used in stored procedures cause fewer recompilations of the stored procedure than temporary tables. Depending on the application, using a temporary table instead of a table variable might not improve performance.
If a stored procedure contains a query that uses a passed-in parameter, avoid changing the parameter value within the stored procedure before using it in the query. The cardinality estimates for the query are based on the passed-in parameter value and not the updated value. To avoid changing the parameter value, you can rewrite the query to use two stored procedures.
For example, the following stored procedure Sales.GetRecentSales changes the value of the parameter @date when @date is NULL.
USE AdventureWorks2008R2; GO IF OBJECT_ID ( 'Sales.GetRecentSales', 'P') IS NOT NULL DROP PROCEDURE Sales.GetRecentSales; GO CREATE PROCEDURE Sales.GetRecentSales (@date datetime) AS BEGIN IF @date is NULL SET @date = DATEADD(MONTH, -3, (SELECT MAX(ORDERDATE) FROM Sales.SalesOrderHeader)) SELECT * FROM Sales.SalesOrderHeader h, Sales.SalesOrderDetail d WHERE h.SalesOrderID = d.SalesOrderID AND h.OrderDate > @date END; GO
If the first call to the stored procedure Sales.GetRecentSales passes a NULL for the @date parameter, the query optimizer will compile the stored procedure with the cardinality estimate for @date = NULL even though the query predicate is not called with @date = NULL. This cardinality estimate might be significantly different than the number of rows in the actual query result. As a result, the query optimizer might choose a suboptimal query plan. To help avoid this, you can rewrite the stored procedure into two procedures as follows:
USE AdventureWorks2008R2; GO IF OBJECT_ID ( 'Sales.GetNullRecentSales', 'P') IS NOT NULL DROP PROCEDURE Sales.GetNullRecentSales; GO CREATE PROCEDURE Sales.GetNullRecentSales (@date datetime) AS BEGIN IF @date is NULL SET @date = DATEADD(MONTH, -3, (SELECT MAX(ORDERDATE) FROM Sales.SalesOrderHeader)) EXEC Sales.GetNonNullRecentSales @date; END GO IF OBJECT_ID ( 'Sales.GetNonNullRecentSales', 'P') IS NOT NULL DROP PROCEDURE Sales.GetNonNullRecentSales; GO CREATE PROCEDURE Sales.GetNonNullRecentSales (@date datetime) AS BEGIN SELECT * FROM Sales.SalesOrderHeader h, Sales.SalesOrderDetail d WHERE h.SalesOrderID = d.SalesOrderID AND h.OrderDate > @date END; GO
Improving Cardinality Estimates with Query Hints
To improve cardinality estimates for local variables, you can use the OPTIMIZE FOR or OPTIMIZE FOR UNKNOWN query hints with RECOMPILE. For more information, see Query Hints (Transact-SQL).
For some applications, recompiling the query each time it executes might take too much time. The OPTIMIZER FOR query hint can help even if you don't use the RECOMPILE option. For example, you could add an OPTIMIZER FOR option to the stored procedure Sales.GetRecentSales to specify a specific date. The following example adds the OPTIMIZE FOR option to the Sales.GetRecentSales procedure.
USE AdventureWorks2008R2;
IF OBJECT_ID ( 'Sales.GetRecentSales', 'P') IS NOT NULL
DROP PROCEDURE Sales.GetRecentSales;
CREATE PROCEDURE Sales.GetRecentSales (@date datetime)
IF @date is NULL
SET @date = DATEADD(MONTH, -3, (SELECT MAX(ORDERDATE) FROM Sales.SalesOrderHeader))
SELECT * FROM Sales.SalesOrderHeader h, Sales.SalesOrderDetail d
WHERE h.SalesOrderID = d.SalesOrderID
AND h.OrderDate > @date
OPTION ( OPTIMIZE FOR ( @date = '2004-05-01 00:00:00.000'))
Improving Cardinality Estimates with Plan Guides
For some applications, query design guidelines might not apply because you cannot change the query or using the RECOMPILE query hint might be cause too many recompiles. You can use plan guides to specify other hints, such as USE PLAN, to control the behavior of the query while investigating application changes with the application vendor. For more information about plan guides, see Optimizing Queries in Deployed Applications by Using Plan Guides.
See Also


text:
According to reviewer Robert C. Deal (Marshall University), the book is "a rich addition to the discussion of the historical evolution in how Americans think about property" and "a joy to read." Here's more:
American Property is a welcome antidote to many standard discussions of property law which despite attention to iconic cases such as the 1805 matter of Pierson v. Post are oddly ahistorical in their treatment of what constitutes property. A fox, a beehive, or--by implication--an entire continent are all treated in much the same manner. Banner historicizes the issue by looking beyond the perennial law school question of what one must do to claim a piece of property. He deals, instead, with what sorts of things are considered property and how the interests competing for the monetary, ideological, or other value to be derived from these things shape the definition of property prevailing in any period. At the center of the book is Banner's thesis that much of this change over time has been driven by advances in technology.The full review is here.
American Property is also featured in the June 6 issue of Rorotoko. Following the site's standard format, Banner describes the book "in a nutshell" and from the "wide angle," then provides a "close-up" and a final take-away ("lastly").


text:
Hi please contact me, i will send you pictures...worldwide shipping...i come from germany.
Jersey for sale:
Jamal Crawford, white, season 2005/2006, jersey signed by the team
COA Grey Flannel Auction and JSA
Fred Jones, blue, season 2007/2008, Meigray
and some more......noKnicks
((((((Drew Coleman,green, New York Jets, Season 2007,gameworn, COA New york Jets
Gabe Pruitt, green, Celtics Season 2007/2008, Hardwood Classic, meigray))))))
Thanks Markus
My John Starks Jersey Collection:
Knicks Away Blue Replica (1996)
Knicks Home White Authentic (1997)
Knicks Away Blue Authentic (Autographed)
Golden State Away Dark Blue Replica
Utah Jazz Away Purple Replica (Autographed)
Does anyone know if any John Starks Bulls jerseys were sold when he made the brief stop at Chicago? That one is on my most wanted list (as a collectors item).
Also, still looking for Golden State Home and Utah Jazz Home jerseys if anyone has any idea where I can get those from. I monitor ebay regularly.
Hey quiggle,
Yeah, I even bid on this one but it was way to expensive, I couldn't believe how much it went for. I guess the only Starks Bulls jerseys in circulation are either Game-Used ones or perhaps custom made ones.
maybe you could look on Ebay for Bulls jerseys from that season and take the name number off and have it recustomize? good luck Levell!
David Lee Knicks home jersey Swingman
Jamal Crawford Knicks away jersey Swingman
Julius "Dr.J" Erving jersey Nets ABA hardwood classics jersey
Bernard King Knicks home jersey by Mitchell and Ness
Carmelo Anthony Syracuse Jersey
By Nike
Nate Robinson Away jersey Replica
Allan Houston Knicks away replica jersey
Latrell Sprewell Knicks replica away jersey
Amare Stoudemire Knicks Swingman replica home jersey
David Lee Golden State replica jersey
Tracy McGrady high school jersey replica
That's just Basketball.
bump for new jersey pick-ups
Last edited by feetoe; Jul 07, 2011 at 15:55.