text:
The State Crown of George I is the imperial and state crown crafted in 1714 for King George I. It was modified and used by subsequent monarchs until 1838. The empty gold frame and its aquamarine monde which dates from the reign of King James II are both part of the Crown Jewels of the United Kingdom. They are on public display in the Martin Tower at the Tower of London.

Origin
The crown, made by royal jeweller Samuel Smithin, replaced the state crown of Charles II (also used by his successors, James II, William III and Queen Anne) and incorporated some of the jewels and pearls from the old crown, with the addition of 265 new pearls, 160 diamonds, 6 emeralds and 2 sapphires, at a total cost of £1,440. Very little change was made to either the shape of the crown or the arrangement of the stones. The gold frame is  tall, and the monde and cross surmounting it are  tall.

Watercolour

The crown is vibrantly depicted in a watercolour painting by Bernard Lens III, the miniature painter to the court of George II, dated 1731. This date suggests that Lens had made a sketch of the crown before it was entirely reset in 1727 for George II but did not finish it until some time afterwards. The inscription reads:

The crown with which George I, King of Great Britain, was crowned on 20 October 1714. The cap is of crimson velvet or purple; welt of ermine; circle and arches of beaten gold. The ornaments are silver and set with diamonds; the larger stones are sapphires and emeralds, and a few small rubies. The balas in the cross in front was given to the crown by James II. The ball on which the upper cross is fixed is an aquamarine but the lower part is gold enamelled green. It is worn when the king goes to parliament, is made new for every coronation, and kept at the Tower of London.

The "balas" mentioned here is the Black Prince's Ruby, a large spinel that was actually in the state crown of Charles II, and is first mentioned in Tudor inventories as being set in a crown used by Henry VIII. The "aquamarine" dates from 1685, when it replaced the original monde in the state crown of Charles II, and was later found to be paste or coloured glass.

Subsequent use and fate
George I's state crown was subsequently used at the coronations of George II, for whom the arches were pulled upwards, and George III. In 1821, because it was seen as being a "very poor affair", the crown underwent extensive changes, including the replacement of the rhombus-shaped monde with a globe of diamonds. Although the crown was present at the coronation of George IV, he was crowned using a new coronation crown made especially for him. William IV was the last monarch ever to use the crown. For her coronation in 1838, Queen Victoria had a new Imperial State Crown made, using precious stones from George I's state crown.

Emptied of its jewels and discarded by the royal family, the 1714 crown was loaned to the Museum of London by the Amherst family from 1933 until 1985. It was purchased by Asprey in 1987 and later acquired by Jefri Bolkiah, Prince of Brunei, who presented it to the United Kingdom. It had been valued at £576,000 in 1995 for the purposes of an application to export the crown to the United States. The application was withdrawn during a review by the Reviewing Committee on the Export of Works of Art. It is part of the Royal Collection and has been on public display in the Martin Tower at the Tower of London since 1996.

References

External links

1714 works
Crown Jewels of the United Kingdom
George I
George I of Great Britain


2015-16: Played in first five games of season before having season ended by injury … notched an assist in each of the first three games of the year, including the 3-2 win at Northeastern on Oct. 16.
2014-15: Played in 28 games … registered a 4-7-11 scoring line … made collegiate debut at Quinnipiac in season opener (Oct. 11) … had first career goal and assist win at RPI (Oct. 25) … credited with the game-winner at Mercyhurst (Jan. 30) … also scored in wins over Air Force (Dec. 6) and RIT (Jan. 24) … had two assists in a 4-4 tie at AIC (Dec. 13) … Atlantic Hockey All-Academic.
Before Bentley: Played two full seasons of junior hockey with the Tri-City Storm of the USHL (2012-14) … played in 56 games in the 2013-14 season, and posted a 12-7-19 scoring line … during the 2012-13 season, played in 58 games and had a 2-6-8 scoring line.
Personal: Majoring in finance with a minor in computer information systems … graduated from Frisco High School in 2012 … age as of Oct. 15: 22 … son of Craig and Becky McMurphy … has one sibling, Kacie (24).


Last weekend was SUCH a great weekend! Honestly, I had such a good weekend this weekend that I think the only weekend that beat it was the weekend Mr Jones proposed to me.
Apologies for the low resolution photos - I didn't want to carry my big camera with me so depended on my phone!
We were lucky enough to be in a box to see Russell Howard so although we weren't close to the stage at all it was a great experience seeing the whole arena and there screens on either side of the stage so we could see what was going on.
By the way...everything is so symmetrical except for one thing and being someone who likes symmetry it bothered the heck out of me! Can you see what it is?
I laughed so much that on Monday my stomach muscles were so sore I felt as if I had done a load of sit-ups!
After a lot of beer/wine the night before the only sensible thing to start Sunday with was a big breakfast. The hotel had a great selection of traditional English breakfast things plus cereals, fruit, cheese and cold cuts.
Fuelled for the day ahead we headed to Fulham. Unfortunately due to tube issues we had to get off at Hammersmith and walk at a brisk pace to Craven Cottage while constantly checking over our shoulders to see if there was a taxi heading our way so we wouldn't miss kickoff.
We managed to get to our seats, right at the front, 3 minutes after kickoff. We were so close I could smell the grass!
I won't go into too many details about the game but it was excellent! It's only the second game I've been to and my first away game but I throughly enjoyed it. I sang along with the songs ("'cause we only know that there's gonna be a show, the Everton boys are there"), boo-ed when goals were missed, jumped up and cheered when Everton scored.
After the game we wandered with the crowds through Bishop's Park to the tube then made our way to the Kings Road Steakhouse and Grill.
The restaurant was smaller than I thought it would be but the decor and atmosphere was exactly what I expected. The host and servers were all well presented, helpful and there in a flash with food and drinks. We were presented with a menu for three courses that included cocktails.
I chose the potted duck for starters, house cut steak (rare, of course) and triple fried chips for my main course and vanilla cheesecake for dessert. All courses were perfection! It did make me realise why I never order three courses anywhere - I was stuffed!
Luckily we had a bit of a walk through Kensington to get to the tube to walk off the food. I was completely in awe of some of the houses that we walked past - I don't think I could ever afford even a room of those 3 story, gated houses with Porches and Range Rovers parked inside the gates!
By the time we got on the train home at Euston we both could have easily fallen asleep! It really was a wonderful weekend but wow was it tiring!


text:
Determining the True Cost of the Humanities
A conversation is going on in Wyoming and all around our country, and it is about the very soul of our nation. On March 16, the Trump administration released its first federal budget plan which called for the elimination of 62 agencies and programs, including the National Endowment for the Humanities, the National Endowment for the Arts and the Corporation for Public Broadcasting. This possibility had been rumored for some time, but most of us thought that the value of these cultural organizations, which is so widely recognized around the country, would temper the new administration's inclinations. We were wrong.
The Trump "Skinny Budget" eliminates these programs and proposes steep cuts in the Environmental Protection Agency and the State Department. Indeed, virtually every agency will see some cut, with only Defense, Homeland Security, and Veterans Affairs seeing increases. To increase the defense budget by $54 billion—a sum that is itself larger than that which all but two countries on the planet spend on their entire military budget—programs and services of all types that touch nearly all of our citizens will be slashed or eliminated.
The breadth and depth of the cuts go far beyond our beloved arts and cultural organizations; science and health research, social services, community development, education, housing, and transportation are all hit hard. Our national debt, and how our budgets and taxes impact it, is a very complex issue that should concern us all, but we should not fall for simple narratives designed to scare us into completely reshaping our nation's core character.
As you know, as our state's humanities council we are Wyoming's affiliate of the National Endowment for the Humanities, and about 70% of our revenue comes from the NEH. If they go under, so do we. To convince you why that is a terrible idea and a major loss for Wyoming, I could talk about the impact we make, elaborating upon the depth and breadth of our own humanities programs throughout the state—serving up several hundred talks, lectures, community conversations, exhibits, documentary films, and reading groups every year. But I don't think that case needs to be made. If you are reading this, you are likely already a believer in our work.
I could also expound upon the economic lunacy of the proposed cut to the NEH, that the minuscule amount in relation to the entire federal budget makes a mighty impact at the local level: for every dollar in federal funding we receive in Wyoming, we match it four- or five-fold in private donations and in-kind contributions from our many, many partners around the state. Plus, every dollar we invest in a program supports economic development by attracting visitors or improving the quality of life in Wyoming. But these economic cases speak to only a part of the larger question that we need to address:
What does the United States of America truly stand for—who are we as a nation and as a people?
Make no mistake about it, how our Congress addresses the president's proposed budget will be the first step in defining the values and national character of the United States going forward. It's hard for me to say that taxpayers should support the NEH (thus sparing my job and that of six other Wyomingites who work here) over, say, research into coastal and marine management or funding Amtrak or before- and after-school and summer programs for kids in need or any of the 60-some-odd other programs facing elimination including many that will eliminate or dramatically stifle scientific research. But it sure feels like the nation has an urgent need for public humanities programs that can help citizens take a closer look at these important issues in a non-partisan way and guided by experts who have devoted their lives to researching and understanding the complexities of modern life.
Wyoming Humanities invests in the people who live in communities of all sizes, stimulating local economies through partnerships with libraries, schools, veterans' hospitals, nonprofit arts and cultural organizations, colleges and universities, museums and more. Like our sister humanities councils around the United States, we help our fellow citizens achieve a better understanding of the past, a better analysis of the present, and a better view of the future—knowledge that is needed now more than ever.
Opening with "The arts and the humanities belong to all the people of the United States," the founding legislation of the National Endowments for the Arts and Humanities signed by President Lyndon B. Johnson in 1965 further declares that "The encouragement and support of national progress and scholarship in the humanities and the arts, while primarily a matter for private and local initiative, are also appropriate matters of concern to the Federal Government." I ask you to consider Neil deGrasse Tyson's recent tweet that the combined Federal budgets of the NEA and NEH equals four hours and 23 minutes of spending on the US Military and then contemplate this: what has changed in our nation's value system between 1965 and today?
U.S. citizens will have a lot to consider over the next few months as Congress decides how much or little of the Trump blueprint will inform the 2018 budget. I don't know if we'll be asked to prioritize or pick from an a la carte menu of what we are willing and unwilling to support, or if we'll be asked to get down to the very meat of issue: what is it that makes us a nation and how much are we willing to pay to maintain the social contract that binds us together? I, for one, agree with our founding legislation, the humanities and arts (and sciences and technologies!) are indeed appropriate matters of concern for the Federal Government.

redpajama_set_name: RedPajamaCommonCrawl


I am new at pivot table.
always get the message "cannot group that selection"
I have checked that the data source used is properly formatted as a date.
without any other field dropped into the pivot table.
From here I right click then select group, and grouping options etc.


text:
Historic Hotels of America  is a program of the National Trust for Historic Preservation that was founded in 1989 with 32 charter members; the program accepts nominations and identifies hotels that have maintained their authenticity, sense of place, and architectural integrity. In 2015, the program included over 260 members in 44 states, including the District of Columbia, Puerto Rico, and the U.S. Virgin Islands. In 2022, the program includes 273 hotels. This article lists current and former member hotels.

Authentically historic hotels "that have a story to tell" are worth more.

Membership
To be included in the program, a hotel must be at least 50 years old; designated by the U.S. Secretary of the Interior as a National Historic Landmark or listed on or eligible for listing on the National Register of Historic Places; and recognized as having historic significance.

The program generates funds for the National Trust through commissions on bookings done through their website, and from membership fees.

Its charter members were as follows (this includes a number of charter members no longer with the organization as of 2022):

 Fairmont Copley Plaza (1912), Boston, Massachusetts
 Hotel duPont (1903), Wilmington, Delaware
 John Rutledge House (1763), Charleston, South Carolina
 Kings Courtyard Inn (1853), Charleston, South Carolina
 La Valencia Hotel (1926), La Jolla, California
 Moana Surfrider (1901), the first hotel in Waikiki, Honolulu, Hawaii
 Morrison-Clark Historic Inn (1864), Washington, D.C.
 Omni Bretton Arms Inn, Bretton Woods, New Hampshire (1896)
 Omni Mount Washington Resort, Bretton Woods, New Hampshire (1902)
 Strater Hotel (1887), Durango, Colorado
 The Broadmoor (1918), Colorado Springs, Colorado
 The Brown Hotel (1923), Louisville, Kentucky
 The Don CeSar (1928), St. Pete Beach, Florida
 The Menger Hotel (1859), San Antonio, Texas
 The Jefferson Hotel (1895), Richmond, Virginia
 The Martha Washington Inn & Spa (1832), Abingdon, Virginia
 The Mayflower Hotel, Autograph Collection (1925), Washington, D.C., the oldest continuously operating hotel in D.C.
 The Omni Homestead Resort (1766), Hot Springs, Virginia
 The Red Lion Inn (1773), Stockbridge, Massachusetts

Former members:
 The Admiral Hotel (1940), Mobile, Alabama
 The Bellevue Hotel (1904), Philadelphia, Pennsylvania
 Timberline Lodge (1937), Mount Hood, Oregon

Current and former members of the HHA program, by state, include:

KEY

Alabama
 Battle House Hotel (1852), Mobile
 Grand Hotel Golf Resort & Spa (1847), Point Clear

Former members:
 founding: The Admiral Hotel (1940), Mobile
 Redmont Hotel (1925), Birmingham.

Alaska
 Hotel Captain Cook (1964), Anchorage

Arizona
 Bright Angel Lodge & Cabins (1935), Grand Canyon
 El Tovar Hotel (1905), Grand Canyon
 Phantom Ranch (1922), Grand Canyon
 The Wigwam (1929), Litchfield Park
 Hotel San Carlos (1886), Phoenix
 Royal Palms Resort and Spa (1948), Phoenix
 Hassayampa Inn (1927), Prescott
 Tubac Golf Resort and Spa (1959), Tubac
 Hacienda Del Sol Guest Ranch Resort (1929), Tucson
 White Stallion Ranch (1900), Tucson.  A dude ranch.

Former members:
 Hotel Valley Ho (1956), Scottsdale
 The Hotel Congress (1919), Tucson.  Where John Dillinger was captured.

Arkansas
 1886 Crescent Hotel & Spa (1886), Eureka Springs
 Capital Hotel (1870), Little Rock

California

 The Inn at Death Valley (1927)
 Stonepine Estate (1920), Carmel Valley
 Hayes Mansion (1905), San Jose
 Claremont Club & Spa (1915), Berkeley (a Fairmont hotel).
 Palace Hotel (1875), San Francisco
 Omni San Francisco Hotel (1926–27), San Francisco, was built as the Finance Center Building, "designed by architect Frederick H. Meyer in collaboration with Albin R. Johnson"
 Intercontinental Mark Hopkins Hotel (1926), San Francisco
 Fairmont Heritage Place, Ghirardelli Square (1893), San Francisco. Includes NRHP-listed clocktower.
 Inn at the Presidio (1903), San Francisco, originally Pershing Hall Bachelor Officers' Quarters.
 The Lodge at the Presidio (1894), San Francisco
 Cavallo Point (1903), Marin County
 Hotel del Coronado (1888), Coronado
 Napa River Inn (1884), Napa
 Fairmont Sonoma Mission Inn & Spa (1927), Sonoma
 Hotel La Rose (1907), Santa Rosa
 The Fairmont Hotel San Francisco (1907)
 Benbow Inn (1926), Garberville
 The Alisal Guest Ranch and Resort (1946), Solvang
 Rancho Bernardo Inn (1963), San Diego
 Surf & Sand Resort (1948), Laguna Beach
 Fairmont Century Plaza (1961), Los Angeles.

Former members:
 Hotel Constance Pasadena (1926), Pasadena
 Berkeley City Club (1929), Berkeley, built as a women's club.  Designed by Julia Morgan.
 Hotel Whitcomb (1916), San Francisco
 The Huntington Hotel (1924), San Francisco

Colorado
 founding: Strater Hotel (1887), Durango
 founding: The Broadmoor (1918), Colorado Springs
 Hotel Boulderado (1909), Boulder
 The Cliff House at Pikes Peak (1874), Manitou Springs
 Hotel Colorado (1893), Glenwood Springs

Former members:
The Stanley Hotel, Estes Park, Colorado

Connecticut
 1754 House (1754), Woodbury, Connecticut
 Water's Edge Resort and Spa (1920s), Westbrook. "Originating from the vision of humanitarian Bill Hahn, the resort has jovial beginnings."

Former members:
 The Spa at Norwich Inn (1929), Norwich. Colonial Revival.

Delaware
 founding: Hotel duPont (1903), Wilmington, within DuPont Building
 The Inn at Montchanin Village (1799), Montchanin, which is distributed through 11 buildings.

Florida

 founding: The Don CeSar (1928), St. Pete Beach. Ten-story hotel on St. Pete Beach. Moorish Revival.
 Belleview Inn (1897), Belleair.  Built for Henry Plant.
 The Gasparilla Inn & Club (1913), Boca Grande. Classic Revival.
 Colony Hotel & Cabana Club (1926), Delray Beach. Spanish Colonial Revival
 Casa Marina Hotel and Restaurant (1925), Jacksonville Beach. Spanish Colonial Revival.
 La Concha Hotel & Spa (1926), Key West. Colonial Revival.
 Casa Faena (1928), Miami Beach.
 The National Hotel (1940), Miami Beach. Art Deco, designed by Roy France.
 Casa Monica Resort & Spa (1888), St. Augustine. Moorish Revival.
 The Vinoy Renaissance St. Petersburg Resort & Golf Club (1925), St. Petersburg, overlooking Tampa Bay.  Mediterranean Revival.
 The Lodge at Wakulla Springs (1937), Wakulla Springs. Built in 1937 by industrialist Edward Ball.
 The Savoy Hotel & Beach Club (1935), Miami Beach, Florida

Former members:
 The Terrace Hotel (1924), Lakeland. Renaissance Revival.
 Greystone Miami Beach (1939), Miami Beach. Designed by Henry Hohauser. Art Deco.

Georgia

 The Candler Hotel Atlanta, Curio Collection by Hilton (1904), Atlanta
 Georgian Terrace Hotel (1911), Atlanta. Gone with the Wind-related, in Fox Theatre Historic District.
 Greyfield Inn (1900), Cumberland Island
 Jekyll Island Club Resort (1887), Jekyll Island
 River Street Inn (1817), Savannah. In former cotton warehouse buildings.
 The King and Prince Beach and Golf Resort (1935), St. Simons Island
 The DeSoto (1890), Savannah.  This is a 1968 replacement to a historic hotel that was built in 1890, demolished in 1965 or so. It is located in Savannah Historic District.
 JW Marriott Savannah Plant Riverside District (1912), Savannah.
 Hotel Indigo Atlanta Midtown (1925), Atlanta.

Former members:
 Partridge Inn (1910), Augusta

Hawaii

 Mauna Kea Beach Hotel, Kohala Coast
 Hilton Hawaiian Village/Waikiki Beach Resort (1957), Honolulu, Oahu
 The Royal Hawaiian (1927), Honolulu, Oahu
 Pioneer Inn (1901), Maui
 founding: Moana Surfrider (1901), the first hotel on Waikiki, Honolulu, Oahu

Former members:
 Grand Naniloa Hotel (1939), Hilo

Illinois
 Hilton Chicago (1927), Chicago. Beaux Arts.
 InterContinental Chicago Magnificent Mile, Chicago.  Built "in 1929 as the Medinah Athletic Club, a luxury men's club for members of the Shrine organization." Art Deco.
 Palmer House, A Hilton Hotel, Chicago. Remodeled in 2004. Beaux Arts
 The Drake Hotel (1920), Chicago. Italian Renaissance.
 The Silversmith Hotel (1896), Chicago. Arts & Crafts.
 21c Museum Hotel Chicago by MGallery (1927), Chicago.

Former members:
 LondonHouse Chicago, Chicago.  Or LondonHouse Chicago, Curio Collection by Hilton. Beaux Arts.

Indiana
 French Lick Springs Hotel (1901), French Lick, at Pluto Mineral Springs. Beaux Arts.
 Omni Severin Hotel, Indianapolis (1913), Beaux Arts.
 Morris Inn at Notre Dame (1952), Notre Dame. Gothic Revival.
 West Baden Springs Hotel (1901), West Baden Springs. "is the crown jewel of French Lick Resort's $500 million restoration." It is a National Historic Landmark.

Former members:
 The Sherman, (1852), Batesville. "in the heart of historic downtown Batesville, a convenient midway meeting point between Indianapolis and Cincinnati, The Sherman is a well-loved locale for the people of the town and an important Indiana landmark." Tudor Style.

Kentucky
 Boone Tavern Hotel of Berea College (1909), Berea
 21c Museum Hotel Lexington by MGallery (1914), Lexington, Beaux Arts
 21c Museum Hotel Louisville by MGallery (1800s), Louisville.  Incorporates Falls City Tobacco Bank
 The Brown Hotel (1923), Louisville

Former members:
 The Campbell House Curio, A Collection by Hilton (1951), Lexington
 The Sire Hotel Lexington, Tapestry Collection by Hilton (1916), Lexington. The Sire Hotel Lexington "on site of the former Gratz Park Inn, which is part of Lexington's beautiful Gratz Park Historic District. The location was originally the home of a family medical practice called the Lexington Clinic."
 The Seelbach Hilton Louisville (1905), Louisville, in Beaux Arts style

Louisiana
 Hilton Baton Rouge Capitol Center (1927), Baton Rouge
 Southern Hotel (1907), Covington, Louisiana, included in the Division of St. John Historic District
 Bienville House (1835), New Orleans, converted into a hotel in 1967
 Hilton New Orleans/St. Charles Avenue (1926), New Orleans
 Hotel Monteleone (1886), New Orleans
 Le Pavillon Hotel (1907), New Orleans, an early skyscraper
 NOPSI New Orleans (1927), New Orleans, in Chicago School style.  It is a Salamander Hotel.
 Omni Royal Orleans (1843), New Orleans, previously known as The City Exchange, as St. Louis Hotel, and as St. Louis Exchange

Former members:
 Nottoway Plantation and Resort (1859), White Castle, whose original mansion is claimed to be the largest surviving antebellum plantation mansion

Maine
 The Colony Hotel (1914), Kennebunkport, also known as "The Colony", included in Cape Arundel Summer Colony Historic District.
 Portland Regency Hotel & Spa (1895), Portland

Former members:
 The Westin Portland Harborview, originally "The Eastland", Portland.  Refused to let Eleanor Roosevelt stay there.

Maryland
 Historic Inns of Annapolis (1727), Annapolis. Colonial Revival
 Hotel Brexton (1881), Baltimore. Queen Anne
 Lord Baltimore Hotel (1928), Baltimore. Listed on the National Register of Historic Places. Beaux Arts
 Inn at Perry Cabin (1816), St. Michaels.  designed by Commodore Oliver Hazard Perry's aide-de-camp, Samuel Hambleton. Greek Revival
 Antrim 1844 (1844), Taneytown.  Listed on the National Register of Historic Places

Massachusetts
 Inn on Boltwood (1926), Amherst. Colonial – Colonial Revival
 founding: Fairmont Copley Plaza (1912), Boston. Designed by Henry Janeway Hardenbergh. Renaissance Revival
 Hilton Boston Downtown/Faneuil Hall (1928), Boston.  Asserted to be "Boston's first Art Deco skyscraper".
 Omni Parker House, Boston (1855), Boston. Classic Revival
 XV Beacon (1903), Boston. Beaux Arts
 The Kendall Hotel (1895), Cambridge.  In Victorian firehouse asserted to be the oldest building in the Kendall Square area.
 Concord's Colonial Inn (1716), Concord. Federal.
 Crowne Pointe Historic Inn (1900), Provincetown. Victorian
 Hawthorne Hotel (1925), Salem. Colonial Revival
 founding: The Red Lion Inn (1773), Stockbridge. Federal
 Publick House Historic Inn (1771), Sturbridge
 Chatham Bars Inn (1914), Chatham, Massachusetts

Former members:
 Boston Park Plaza, (1927) Boston
 Harbor View Hotel of Martha's Vineyard (1891), Edgartown. Shingle Style.

Michigan
 Amway Grand Plaza, Curio Collection by Hilton (1913), Grand Rapids, originally the Pantlind Hotel
 Grand Hotel (1887), Mackinac Island
 Island House Hotel (1887), Mackinac Island

Former members:
 Landmark Inn (1930), Marquette
 DoubleTree Suites by Hilton Hotel Detroit Downtown - Fort Shelby (1917), Detroit
 The Inn on Ferry Street, Detroit, in East Ferry Avenue Historic District

Minnesota
 St. James Hotel (1875), Red Wing
 The Saint Paul Hotel (1910), Saint Paul

Missouri
 The Raphael Hotel (1928), Kansas City
 St. Louis Union Station Hotel (1894), St. Louis, in Union Station (St. Louis)
 Hotel Indigo St. Louis Downtown (1909), St. Louis

Former members:
 Hilton President Kansas City (1926), Kansas City
 Hotel Phillips Kansas City (1931), Kansas City
 Hilton St. Louis Downtown at the Arch (1888), St. Louis, was the Merchant Laclede National Bank

Montana
 Many Glacier Hotel (1915), Babb
 Lake McDonald Lodge (1914), Glacier National Park
 The Andrus Hotel (1917), Dillon.  HHA member in 2022, has been member since 2021.

Nebraska
 The Peregrine Omaha Downtown, Curio Collection by Hilton (1912), Omaha, Nebraska

Former members:
 The Redick Tower was formerly an HHA member.

Nevada
 Mizpah Hotel (1907), Tonopah, aka Grand Old Lady

New Hampshire
 founding: Omni Bretton Arms Inn (1896), Bretton Woods.  "44-nation Bretton Woods Monetary Conference in 1944." Queen Anne.
 founding: Mount Washington Hotel (1902), Bretton Woods. "was the setting for the historic Bretton Woods Monetary Conference in 1944." Renaissance Revival.
 Hanover Inn Dartmouth (1780?), Hanover. On site of home of General Ebenezer Brewster. Colonial Revival.
 Eagle Mountain House, Jackson. Colonial Revival
 Wentworth by the Sea (1874), New Castle. Second Empire
 Mountain View Grand Resort & Spa, Whitefield

Former members:
 The Bedford Village Inn, Bedford.  Colonial Revival

New Mexico
 Hilton Santa Fe Historic Plaza (1625), Santa Fe
 La Fonda (1922), Santa Fe
 La Posada de Santa Fe (1882), Santa Fe
 Old Santa Fe Inn (1930), Santa Fe

Formerly listed:
 Plaza Hotel 1982 (1882), Las Vegas

New Jersey
 Caribbean Motel (1957), Wildwood Crest.  " in the New Jersey beach resort community of The Wildwoods – home to the largest surviving collection of mid-20th century commercial beach resort architecture in North America."

New York
 Bear Mountain Inn, Bear Mountain
 The Otesaga Hotel and Cooper Inn, Cooperstown. Colonial Revival
 The Queensbury Hotel, Glens Falls. Overlooking City Park on Ridge Street. Colonial Revival
 Oheka Castle, Huntington. Renaissance Revival
 Mohonk Mountain House (1869), New Paltz. Victorian
 JW Marriott Essex House, New York. Art Deco
 Omni Berkshire Place, New York City (1926), New York. "Warren & Wetmore built this historic landmark hotel in 1926. The Berkshire Hotel was purchased in May 1978 by the Dunfey Hotels Corporation, which included the Omni Hotels and Dunfey Hotels groups. The property received a $9.5 million face-lift in 1979." Classic Revival.
 Martinique New York on Broadway, Curio Collection by Hilton, New York. "Designed by Henry Hardenbergh, who also designed the Waldorf Astoria, the Plaza Hotel, and the Dakota Apartments on Central Park." Beaux Arts
 The Plaza, New York. Beaux Arts
 The Redbury New York, New York. Renaissance Revival
 The Renwick Hotel New York City, Curio Collection by Hilton, New York. Renaissance Revival
 Beekman Arms and Delamater Inn (1766), Rhinebeck
 Hotel Saranac, Curio Collection by Hilton, Saranac Lake. Colonial Revival
 Marriott Syracuse Downtown (1924), Syracuse.  Originally the Hotel Syracuse, reopened in 2016 as Marriott Syracuse Downtown. Renaissance Revival.
 The Sagamore, Bolton Landing
 Blue Moon Hotel, New York, New York (1879), New York.

Former members:
 AKA Sutton Place, New York. Art Deco
 AKA Times Square, New York. Romanesque Revival
 AKA Wall Street, New York. Beaux Arts
 Hotel Skyler Syracuse, Tapestry Collection by Hilton (1921), Syracuse. Occupied by the Temple Adath Yeshurun for more than 50 years, later housed the Salt City Theatre Group. Now asserted to be "the third hotel in the United States and the first in Syracuse to be certified LEED Platinum." Georgian Revival.
 Jefferson Clinton Hotel (1927), Syracuse. Beaux Arts
 Castle Hotel & Spa, Tarrytown. Gothic Revival
 Hotel Utica (1912), Utica. "Opened as Hotel Utica in 1912, it was the premier hotel in Central New York."

North Carolina
 Haywood Park Hotel (1923), Asheville. Located in a former department store building. Classic Revival
 The Omni Grove Park Inn (1913), Asheville. Arts & Crafts, with red clay tile roof and original Roycroft furnishings and fixtures.
 Green Park Inn (1891), Blowing Rock. Queen Anne Victorian style
 The Dunhill Hotel (1929), Charlotte
 21c Museum Hotel Durham by MGallery (1937), Durham. Art Deco.  Also known as Hotel Durham, it is located in the former Durham Bank & Trust Company building.
 Pinehurst Resort (1895), Pinehurst.  Includes 3 hotels, in a National Historic Landmark District.
 The Graylyn Estate (1932), Winston-Salem
 The Historic Magnolia House (1889), Greensboro.

Former members:
 Mast Farm Inn (1792), Banner Elk "an award-winning and world renowned historic country inn and restaurant" in the Valle Crucis Historic District, "which has been welcoming guests since the 1800s."  Colonial Revival

Ohio
 21c Museum Hotel Cincinnati (1912), Cincinnati.
 Ariel Broadway Hotel (1925), Lorain.
 Best Western Mariemont Inn (1926), Cincinnati.
 Hilton Cincinnati Netherland Plaza (1931), Cincinnati.

Oklahoma
 Inn at Price Tower (1956), Bartlesville. In the Price Tower designed by Frank Lloyd Wright
 21c Museum Hotel Oklahoma City by MGallery (1916), Oklahoma City. NRHP-listed, in Albert Kahn-designed Oklahoma City Ford Motor Company Assembly Plant
 The Skirvin Hilton Oklahoma City (1911), Oklahoma City. NRHP-listed as Skirvin Hotel
 The Atherton Hotel at Oklahoma State University (1950), Stillwater. Originally the "Union Club"

Former members:
 Tulsa Club Hotel, Curio Collection by Hilton (1927), Tulsa

Oregon
 Ashland Springs Hotel, Ashland
 Crater Lake Lodge, White City
 Embassy Suites by Hilton Portland Downtown (1912), Portland. Originally the Multnomah Hotel.

Former members:
 The Heathman Hotel (1927), Portland

Pennsylvania
 Omni Bedford Springs Resort (1806), Bedford. Eclectic
 Hotel Bethlehem (1922), Bethlehem. Beaux Arts
 The Sayre Mansion (1858), Bethlehem. Gothic Revival
 The Lodge at Nemacolin Woodlands Resort (1968), Farmington.  Located "at the center of the world-famous Nemacolin Woodlands Resort, it was once the peaceful hunting lodge of the Pittsburgh industrial titan, Willard F. Rockwell. Constructed in 1968, its immense popularity among his loved ones inspired Rockwell to turn the building into a vacation spot open to the public." Tudor Revival
 Ledges Hotel (1890), Hawley. Originally the John S. O'Connor Glass Factory. Federal
 Silver Birches (hotel) (1929), Hawley.  In 13 historic structures on shoreline of Lake Wallenpaupack. Includes Colonial Revival architecture.
 The Settlers Inn at Bingham Park (1927), Hawley. Has Arts & Crafts furniture. Tudor Revival
 The Hotel Hershey (1933), Hershey.  Implemented idiosyncratic vision of Milton S. Hershey. Spanish Colonial Revival
 Cork Factory Hotel (1865), Lancaster. Eclectic
 Lancaster Arts Hotel (1881), Lancaster. Eclectic
 The Inn at Leola Village, Est. 1867 (1867), Leola. In Pennsylvania Dutch Country near Lancaster, Pennsylvania.  Includes "five restored agricultural structures including two 19th-century farmhouses and a tobacco barn," three holding guest rooms.
 Omni William Penn Hotel (1916), Pittsburgh.  Classic Revival
 Skytop Lodge (1928), Skytop. Colonial Revival
 The Nittany Lion Inn of the Pennsylvania State University (1931), State College. Colonial Revival
 Penn Wells Hotel (1869), Wellsboro.  Adjacent to associated Art Deco-style Arcadia Theatre. Victorian.
 Hotel Warner (1930), West Chester, also known as the Warner Theater.  NRHP-listed in 1979 as a theater; converted into a hotel in 2012.
 Eagles Mere Inn (1887), Eagles MERE became an HHA member in 2021 It is a contributing building in the NRHP-listed Eagles Mere Historic District,
 Glasbern (1870), Fogelsville.
 Morris House Hotel (1787), Philadelphia.
 Historic Americus Hotel (1926), Allentown.

Former members:
 Gettysburg Hotel, Est.1797 (1797), Gettysburg.  Beaux Arts
 AKA Rittenhouse Square (1912), Philadelphia. Beaux Arts
 The Bellevue Hotel (1904), Philadelphia.  Renovated in 2016. Renaissance Revival.
 Distrikt Hotel Pittsburgh, Curio Collection by Hilton (1924), Pittsburgh. Listed on the National Register of Historic Places.  Originally served as the headquarters for the Salvation Army's Western Pennsylvania Division.

Rhode Island
 Newport Beach Hotel & Suites (1940), Middletown, "formerly known as the Inn at Newport Beach." A massive hurricane in 1938 wiped out the town's numerous beach establishments. Two years later, after the sand settled, the Toppa family decided to build a new inn on the beach, positioning the property 100 feet from the rocks and the ocean's crashing waves." Colonial Revival
 The Hotel Viking (1926), Newport, "the most recent multi-million dollar renovation finished in 2007".  Viking Hotel.

South Carolina
 Francis Marion Hotel (1924), Charleston
 founding: John Rutledge House Inn (1763), Charleston
 founding: Kings Courtyard Inn (1853), Charleston
 The Dewberry (1964–65), Charleston.  Mid-century modern building, originally the L. Mendel Rivers Federal Building, in the Charleston Historic District.
 Wentworth Mansion (1886), Charleston, Second Empire in style, in the Charleston Historic District.
 The Westin Poinsett (1925), Greenville
 Fulton Lane Inn (1889), Charleston

South Dakota
 Hotel Alex Johnson (1928), Rapid City
 Hotel on Phillips (1917), Sioux Falls

Tennessee
 The Peabody Memphis, Memphis
 General Morgan Inn & Conference Center (1884), Greeneville.  Originally the Grand Hotel, later the Hotel Brumley. John Hunt Morgan was shot and fell here. Included in Greenville Historic District.
 21c Museum Hotel Nashville by MGallery (1895) in  NRHP-listed Second Avenue Commercial District.
 Union Station Hotel Nashville, Autograph Collection, Nashville.  Within Union Station (Nashville), a former National Historic Landmark.
 Hermitage Hotel, Nashville.  Claimed to be "the only remaining grand hotel in Nashville and the only commercial Beaux Arts structure in the state."

Texas
 founding: Menger Hotel (1859), San Antonio
 Hotel Settles (1930), Big Spring
 The Stagecoach Inn (1852), Salado
 The Ashton Hotel, Fort Worth
 Hilton Fort Worth (1921), Fort Worth.  Originally Hotel Texas
 The Statler (1956), Dallas
 The Whitehall, Houston
 Omni La Mansion Del Rio, San Antonio
 The Crockett Hotel (1909), San Antonio
 Emily Morgan San Antonio - a DoubleTree by Hilton Hotel (1924), San Antonio

Former members:
 The Sam Houston Hotel, Houston

Utah
 Zion Lodge (1924), Springdale, designed by Gilbert Stanley Underwood, located in Zion National Park

Vermont
 Castle Hill Resort and Spa, Cavendish
 The Middlebury Inn (1827?), Middlebury.  Begun as the Vermont Hotel, a brick "public house" opened by Nathan Wood in 1827. Federal.
 Basin Harbor, Vergennes.  On Lake Champlain. Eclectic.
 Woodstock Inn & Resort, Woodstock.

Virginia
 founding: The Omni Homestead Resort (1766), Hot Springs, formerly The Homestead.
 founding: The Martha Washington Hotel & Spa (1832), Abingdon.  Martha Washington Inn.
 The Mimslyn Inn (1931), Luray.  Georgian Revival architecture. Included in Luray Downtown Historic District.
 The Virginian Lynchburg, Curio Collection by Hilton (1913), Lynchburg
 Inn at Willow Grove (1778), Orange
 founding: The Jefferson Hotel (1895), Richmond
 Blackburn Inn (1828), Staunton, Virginia, built as Western State Hospital (Staunton, Virginia).
 Stonewall Jackson Hotel & Conference Center (1924), Staunton. Stonewall Jackson Hotel
 Airlie (1899), Warrenton. Also known as Airlie Conference Center, partly in original post office.
 Williamsburg Inn (1937), Williamsburg
 Williamsburg Lodge, Autograph Collection, and Colonial Houses (1750), Williamsburg

Former members:
 Boar's Head Resort (1834), Charlottesville
 The Georges (1789), Lexington, in the Lexington Historic District
 The Hotel Roanoke & Conference Center, Curio - A Collection by Hilton (1882), Roanoke. Hotel Roanoke, NRHP-listed.
 The Cavalier Virginia Beach, Autograph Collection (1927), Virginia Beach. Cavalier Hotel.

Washington
 Mayflower Park Hotel (1927), Seattle
 Fairmont Olympic Hotel (1924), Seattle.  Originally the Olympic Hotel.

West Virginia
Former members:
 Blennerhassett Hotel, Parkersburg

Wisconsin
 The American Club (1918), Kohler. Walter J. Kohler Sr. founded it.  Tudor-style.
 The Edgewater (1948), Madison.  Art Deco
 Hilton Milwaukee City Center (1928), Milwaukee, built as the Schroeder Hotel
 The Pfister Hotel (1893), Milwaukee.  Romanesque Revival

Wyoming
 Old Faithful Inn (1904), Yellowstone National Park.  A National Historic Landmark.
 Lake Yellowstone Hotel & Cabins (1891), Yellowstone National Park
 Sheridan Inn (1892), Sheridan
 Alpenhof Lodge (1965), Teton Village
 The Wort Hotel (1941), Jackson

Washington, D.C.

 founding: Morrison-Clark Historic Inn (1864)
 founding: The Mayflower Hotel (1925)
 Capital Hilton (1943)
 The Churchill (1906), originally a luxury apartment building
 Georgetown Inn (1962)
 The Graham Georgetown, Tapestry Collection by Hilton (1962)
 Hamilton Hotel (1851)
 The Henley Park Hotel (1918)
 Hotel Lombardy (1929), converted to a hotel in 1994
 Melrose Georgetown Hotel (1947)
 Omni Shoreham Hotel (1930)
 Phoenix Park Hotel (1922)
 Riggs Washington DC (1891)
 Sofitel Washington DC Lafayette Square (1925)
 Willard InterContinental Washington (1901)
 Washington Hilton (1965)

Puerto Rico
 Condado Vanderbilt Hotel (1919), San Juan
 El Convento Hotel (1651), San Juan, Spanish Colonial architecture
 Fairmont El San Juan Hotel (1958), San Juan

Former members:
 Caribe Hilton (1949), San Juan
 The Condado Plaza Hilton (1963), San Juan,  International style

U.S. Virgin Islands

Former members:
 The Buccaneer (1653), Christiansted

See also

Notes

References

External links
 2019 HHA directory

Hotel affiliation groups

National Trust for Historic Preservation

redpajama_set_name: RedPajamaWikipedia


Machine translated chapter 821 of Bringing The Farm To Live In Another World light novel.
A Gnome clan and Ark Continent situation is different, Ark Continent is overall moving to Ark Space, Ark Continent here civilization has not received a point destruction, the preservation absolute complete. But a Gnome clan is different, before a Gnome clan had high Magic-Mechanical Civilization foundation, possibly also wanted compared with Ark Continent here on strongly many, but has not used, their this civilization were destroyed completely " dividing into periods of civilization appears , now in these Gnome " knows the character on few, in this case, Zhao Hai, if one made them study too many thing " to help him handle the too difficult matter, that was almost impossible. But reason that Zhao Hai causes that church, moreover lets Gnome with picking the thing method trades thing " for lets these Gnome understand, gets so far as Space here to come you, did not make you enter Heaven, you still need to work, can trade all that you wanted. It is not Zhao Hai is stingy, but is he does not want to foster the problem that these Gnome are gluttonous and lazy, making them know that no pain , no gain is best. But that church is Zhao Hai makes Cai'er make, thing that this church uses, is actually by a nose control server, so long as Gnome takes thing to enter to teaching in the palm, can receive in exchange for thing that they need, no matter any thing, Zhao Hai can get so far as to them. Naturally, this has received in exchange for thing also having the price, for example an ordinary made of iron axe, these Gnome clan minimum must trade with about hundred jin (0.5 kg) Bread Fruit. This price is Cai'er through buys thing toward Space, in buys thing from Space, after adding on the Ark Continent there price carries on a price that the computation results, this price almost will be forever does not change. He to did not fear that a Gnome clan wants to trade any extraordinary thing, by a present Gnome clan thing in Space, they are wants to trade Advanced level thing, cannot put out thing to trade. In the Space that now a Gnome clan is, most is rich is Bread Fruit, the light trades with Bread Fruit, feared that was they " could not trade the entire Space Bread Fruit natural lighting a piece Crystal Stone, therefore Zhao Hai did not worry. After processing a Gnome clan, Zhao Hai turned the head the vision Accra Mountain defense line there, there still in hitting " Yun Tianlei they also don't know Zhao Hai brightly has taught country here now looting. However now Zhao Hai wants to enter teaches the country to take by force brightly was impossible, God Race toward has taught country here to send reinforcement from God Realm brightly, therefore Zhao Hai prepares to cope with these God Race armies that besieges the Accra Mountain defense line now.
These Demon Race one hear of Great Demon King spoke " the collective has lost one's voice, they have not thought that really can be this, all person one face shocking look at clamped Demon King. The appearance of Great Demon King look at people, then said : "Mr. Zhao Hai gives me a guarantee" our Demon Race to walk to enter to that Space, his absolutely not for no reason suppression our Demon Race, will not meddle the Demon Race internal matter, will not come the slave with own strength we, he thought that our Demon Race does not go bad, does not want to make us destroying completely by Underworld. " Speaking of here, before Great Demon King sighed said : ", our Demon Realm and Underworld several times encounters, although we have repelled Underworld, but we have also paid extremely serious price", moreover everyone/Great Clan was must forget, at that time our fight places in Demon Realm, we can also try to find the solution, gave seal activated with Underworld interlinked that Space passage, but now is different, here was Ark Continent, we and Space passage between Ark Continent opened completely, but Underworld and Space passage between Ark Continent also completely opened " this passage is the seal does not live, that also in other words, we. Demon Race and Underworld " pass Ark Continent this place, by forever successive in together. " Speaking of here Great Demon King to sweep these Demon Race then said : before the eye "we repelled Underworld, guaranteed Demon Realm to be safe, was because we can the Space passage seal on, one, but Space passage seal not on, then regarding our Demon Realm, absolutely was a disaster." These Demon Race are not the fools, meaning of their understand Great Demon King, one, but Space passage cannot " Demon Realm sooner or later be extinguished by Underworld by seal activated, this is the biggest threat. Great Demon King deep voice said : ", if we entered to Mr. Zhao Hai that Space" in do not need to be worried about the Underworld issue, moreover Mr. Zhao Hai allowed us to enter that Space, was not the complete stemming from good intention, our Demon Race had the arrow to use to him. "! ~!
A Gnome clan and Ark Continent situation is different, Ark Continent is overall moving to Ark Space, Ark Continent here civilization has not received a point destruction, the preservation absolute complete. But a Gnome clan is different, before a Gnome clan had high MagicMechanical Civilization foundation, possibly also wanted compared with Ark Continent here on strongly many, but has not used, their this civilization were destroyed completely dividing into periods of civilization appears , now in these Gnome knows the character on few, in this case, Zhao Hai, if one made them study too many thing to help him handle the too difficult matter, that was almost impossible. But reason that Zhao Hai causes that church, moreover lets Gnome with picking the thing method trades thing for lets these Gnome understand, gets so far as Space here to come you, did not make you enter Heaven, you still need to work, can trade all that you wanted. It is not Zhao Hai is stingy, but is he does not want to foster the problem that these Gnome are gluttonous and lazy, making them know that no pain , no gain is best. But that church is Zhao Hai makes Caier make, thing that this church uses, is actually by a nose control server, so long as Gnome takes thing to enter to teaching in the palm, can receive in exchange for thing that they need, no matter any thing, Zhao Hai can get so far as to them. Naturally, this has received in exchange for thing also having the price, for example an ordinary made of iron axe, these Gnome clan minimum must trade with about hundred jin 0.5 kg Bread Fruit. This price is Caier through buys thing toward Space, in buys thing from Space, after adding on the Ark Continent there price carries on a price that the computation results, this price almost will be forever does not change. He to did not fear that a Gnome clan wants to trade any extraordinary thing, by a present Gnome clan thing in Space, they are wants to trade Advanced level thing, cannot put out thing to trade. In the Space that now a Gnome clan is, most is rich is Bread Fruit, the light trades with Bread Fruit, feared that was they could not trade the entire Space Bread Fruit natural lighting a piece Crystal Stone, therefore Zhao Hai did not worry. After processing a Gnome clan, Zhao Hai turned the head the vision Accra Mountain defense line there, there still in hitting Yun Tianlei they also dont know Zhao Hai brightly has taught country here now looting. However now Zhao Hai wants to enter teaches the country to take by force brightly was impossible, God Race toward has taught country here to send reinforcement from God Realm brightly, therefore Zhao Hai prepares to cope with these God Race armies that besieges the Accra Mountain defense line now. However on appears an issue, their manpower was as the matter stands insufficient, although said that Zhao Hai in hand Undead Creature are many, but looks like Barbarian and Pegasus Clan Undead Creature Zhao Hai does not prepare to use now, Barbarian and Undead Creature of wing clan horse, if a use, will possibly enrage Barbarian and Pegasus Clan if advanced that side these two races God Race completely, that Zhao Hai was cries unable to look to move. Zhao Hai and God Race have a grudge, but may not have what enmity to speak the truth with Barbarian and Pegasus Clan, Zhao Hai also really somewhat sympathizes with these two races , because of this, therefore Zhao Hai, when presently Barbarian and Pegasus Clan regarding some order being perfunctory of God Race, his horse are decisive ordering, carries on largescale attack to Barbarian and Pegasus Clan, must make them know that the Ark Continent person with treating God Race has the difference to them. Has to recognize Zhao Hai do very successful, Barbarian and Pegasus Clan these Elite, in these time with the fight of Ark Continent, have walked to be present at work does not strive, this also made the Accra Mountain defense line there pressure more relaxed. However as the matter stands Zhao Hai wanted to cope with God Race appears has the hand to be insufficient Ark Continent these people, just to settle down in Ark Space got down, if at this time, made the person in Ark Space dispatch troops to cause dislike of Ark Space person, such matter Zhao Hai was not dry. But does not make them dispatch troops, now Zhao Hai in hand did not have other military strength, this made some Zhao Hai headaches Zhao Hai suddenly feel that in this time own information in having the sound, Zhao Hai has put out that Message Fish to look, gave the Great Demon King good strip rest fish, Zhao Hai to stare quietly, then one happy. Great Demon King after Demon Dragon King has reached an agreement the later Demon Race trend, has prepared to leave Demon Realm, before returning to Demon Realm some Great Demon King matters must do, first is, he must wait for information of demon vulture clan, so long as there is information of demon vulture clan he to carry on second. The people of demon vulture clan went to three talents to come back, returned to Demon Capital City there, his immediately sought an interview Great Demon King, Great Demon King nature bright grew in vain any matter , therefore he not independent summoned this demon vulture clansman, but in Demon Race city here, groans the Demon Race people of having a face to give to invite. After waiting for all Demon Race people, Great Demon King letting these demon vulture clansman came, that demon vulture clansman face weary look after all people on the scene saluted, Great Demon King said was then good, said. The people of that demon vulture clan complied with said are, Your Majesty, this time I left from Demon Capital City here, after Albanian Bukit Raya, entered in Lyon Empire, then passed through Rosen Empire, Aksu Empire enters to Beastman Prairie that Your Majesty, entire Ark Continent nobody, a person did not have now, all Ark Continent people have outmigrated, but in Beastman Prairie there, I saw Underworld poisonous mist definitely is Underworld poisonous mist will not have wrong, I also noticed that many Undead Creature moved in poisonous mist. The Demon Race person in hall heard demon vulture clansman saying that buzz one blasted out the child pot, they have not thought that the Ark Continent here person has outmigrated, moreover person real appears of Underworld. When Demon Race does not fear any race, but regarding Underworld they is actually dreaded deepest this does not have the matter of means that Underworld there was almost some cold blood Wuqingruthless life form, Demon Race suffers a loss to. Great Demon King looked at people one eyes, deep voice said has given me peacefully, quarrelled anything. In hall one static, all people do not dare to speak, the Great Demon King prestige is placed in there, these people may not have that to dare not to respect Great Demon King. Great Demon King looked that all people do not speak, he then turned the head to be good to that demon vulture clansman said , you got down. That demon vulture clansman complied with one turn around to walk. Great Demon King turned the head look at people said like this looks like Mr. Zhao Hai has not deceived us, I before and Mr. Zhao Hai carried on one time to talk over thoroughly, the Mr. Zhao Hai words, were very sincere, he led me the place that goes to the Ark Continent person to live in now, to be honest, I arrived at there, but also thinks really Zhao Hai was deceiving me, because there was just the same as the Ark Continent here terrain, without any difference, but there that the Ark Continent people lived at there not any war. People look at Great Demon King, dont know he wanted to say anything, Great Demon King looked at people said Mr. Zhao Hai to tell me, he said that he did not hate our Demon Race, our Demon Race invaded Ark Continent, to pursue good life, he did not hate us, in adding on us has not caused the damage of any substance nature to Ark Continent, therefore he understood our, afterward he also led me to go to environment very good Space the there environment also to be better than Ark Continent, Mr. Zhao Hai said , if our Demon Race wanted, can move to that Space to live. Before although, has the Great Demon King words to press in there, but these people could not bear sound key are the information that Great Demon King said are really too astonishing. Great Demon King looked at people one eyes, deep voice said everyoneGreat Clan certain very strange, why Mr. Zhao Hai must such do, good, I explained with everyoneGreat Clan, that Space that Mr. Zhao Hai said that was actually his Space he has one type of Divergent Technique, can open the outoftheway to leave several own Space alone, in that several Space he was the god, the words that he spoke were the decree of god also in other words, if our Demon Race person entered that Space, how that Mr. Zhao Hai does want us on us how, everyoneGreat Clan to listen to understand These Demon Race one hear of Great Demon King spoke the collective has lost ones voice, they have not thought that really can be this, all person one face shocking look at clamped Demon King. The appearance of Great Demon King look at people, then said Mr. Zhao Hai gives me a guarantee our Demon Race to walk to enter to that Space, his absolutely not for no reason suppression our Demon Race, will not meddle the Demon Race internal matter, will not come the slave with own strength we, he thought that our Demon Race does not go bad, does not want to make us destroying completely by Underworld. Speaking of here, before Great Demon King sighed said , our Demon Realm and Underworld several times encounters, although we have repelled Underworld, but we have also paid extremely serious price, moreover everyoneGreat Clan was must forget, at that time our fight places in Demon Realm, we can also try to find the solution, gave seal activated with Underworld interlinked that Space passage, but now is different, here was Ark Continent, we and Space passage between Ark Continent opened completely, but Underworld and Space passage between Ark Continent also completely opened this passage is the seal does not live, that also in other words, we. Demon Race and Underworld pass Ark Continent this place, by forever successive in together. Speaking of here Great Demon King to sweep these Demon Race then said before the eye we repelled Underworld, guaranteed Demon Realm to be safe, was because we can the Space passage seal on, one, but Space passage seal not on, then regarding our Demon Realm, absolutely was a disaster. These Demon Race are not the fools, meaning of their understand Great Demon King, one, but Space passage cannot Demon Realm sooner or later be extinguished by Underworld by seal activated, this is the biggest threat. Great Demon King deep voice said , if we entered to Mr. Zhao Hai that Space in do not need to be worried about the Underworld issue, moreover Mr. Zhao Hai allowed us to enter that Space, was not the complete stemming from good intention, our Demon Race had the arrow to use to him.


Woodworm, damp or rot issues in and around Omagh? Don't worry, your local Property Care team is here to help.
Located at the point where the rivers Drumragh and Carnowen meet to form the Strule River, Omagh hosts a number of residential and commercial properties, both of which can be susceptible to woodworm, damp and wet or dry rot issues. Ensuring the physical barriers of your property are well maintained and water tight will help prevent these problems and reduce the risk to your home or business.
Do you already suspect that you have a woodworm, damp and wood rot problem? We understand that when it comes to your home, property or business, you can't take any chances. Our services give Omagh customers local, tailored solutions backed by a large nationwide company that you can trust.
Looking for property care solutions near Omagh but your area isn't listed? Not to worry, our nationwide service means we are always right on your doorstep.
It can be a daunting experience if you suspect a damp, woodworm or rot problem within your home; luckily our property care specialists based in Omagh ensure your home is properly cared for. We treat your home like its our very own which means you can be sure it is safe for many years to come.
Damp – If left untreated damage to the exterior walls of your property can often lead to damp problems; unfortunately identifying signs of damp can be difficult. Rentokil damp specialists based in Omagh are trained to identify telltale signs of damp in order for our specialist technicians to provide treatment to the effected area.
Woodworm – Omagh surveyors provide local residents with an extensive woodworm survey and report outlining the activity level, species and extent of your issue. Once the best form of treatment has been agreed on, our trained technicians will begin treating the affected area of your home. You can be sure that woodworm will no longer be a problem. Don't believe us? With a 30 year woodworm guarantee you'll be crazy not to.
Wood Rot – Fungal growth can be apparent when moisture levels within an area of the home reach 20%, this can affect: joists, window frames, floorboards and timbers, often a result of poor ventilation. Our local experts are trained to locate, eliminate and replace rotten timbers with preservative-treated timbers ensuring our treatment is guaranteed for 30 years.
We offer commercial property care in Omagh by our local team of experts for businesses of all sizes. Businesses in Omagh, are prone to a number of property issues, including damp, woodworm and rot. Luckily our property specialists are on hand to treat any issues you may have with your facilities.
All of our Omagh surveyors are Certificated Surveyors in Remedial Treatment (CSRT) which is a qualification highly recognised within the property care industry. Whether it's timber treatment, penetrating damp treatment or woodworm treatment, this qualification gives Rentokil Property Care surveyors the expertise to deal with all your property care issues to the highest standard.


Easychoice are happy to be able to offer the best low cost calls available in Spain, this service will change the way you make calls, forever!
Megamobile is a small microchip on a thin sticker that simply goes onto your sim card and then re routs your international calls automatically through the low cost provider.
With Megamobile you can call phones in the UK from just 2.5 cents/min.
Savings are available on ALL your international calls, to any country, not limited to the UK.
Once Megamobile is in your phone, all you need to do is top up on a pay-as-you-go basis and this covers all your international calls.


text:
Podcast Hosting Skills 4 min read
Jakob Lewis knows how to tell the stories of other people. He's producer of the award-winning podcast Neighbors with Nashville Public Radio and founder of Vox Familia, an audio production company which helps families document their stories.
I asked Jakob about how podcasters can tell a better story...
What are the elements of a good story?
Something happens to Someone Somewhere and it means Something. Those four elements are all you need—action, character, setting, and reflection. Basic enough, but it's the artful doling out of that information that turns it from mere data into narrative.
Plot comes from the character. So start there. The character(s) in the story need to want something.
Kurt Vonnegut says "Make your character want something right away—even if it's a glass of water." If this is a true (as in non-fiction) story and you don't have the benefit of making up all the elements then ask the main character what his motivation was. Something like, "Why'd you train so 7 days a week in hope to get a gold medal in curling?"
In addition to motivation for your character, his flaws, desires, goals, and quirks all help make him a three-dimensional character that is more relatable to your audience. In fact, as a general rule of any type of storytelling the more specific your characters are, the more universal they become. Or in other words, the smaller the story, the bigger it is.
If the story you're telling is a personal one, start with your own desire.
"You know my dad was Jamaican and died before I was born, so when a Jamaican man whom I'd never met before showed up at my door and said he was my uncle—I burst into tears."
If I just burst into tears in the story when I saw a man claiming to be my uncle, I would have a compelling scene, but void of meaning. If I just tell you about my dad and uncle, we don't have the "action" happening in the story and then it's just data (although somewhat compelling still).
The order of these in audio matters a great deal.
I try to follow the rule "show don't tell." So rather than saying there was a waterfall and then play a waterfall sound afterward to illustrate that, I play a waterfall sound first and then say under the sound, "the water coming off the falls was mesmerizing in the light." The listener can actually "see" that with their mind's eye.
The last element of a good story is reflection. You may choose not to explain your story very explicitly and let the listener make their own meanings, but often storytellers can bring home and give some finality to a story by offering a zoomed-out reflection on the story they just told. Like in my fake Jamaican uncle example, I could end that story saying something like,"It seems like we all have things that we had put to bed, things that we thought would never be a chapter in our lives, and then they just show up on your doorstep. Ultimately I'm glad I let him in."
Audio vs. Video Storytelling
I think that if I told stories in video. the style would have to be vastly different to be effective. I think audio is the most intimate storytelling medium.
It's an old radio adage that radio is the most "visual" medium. It seems counter-intuitive, but I agree. A video shows you exactly what they've curated for you to see. Radio gives you the prompt of what to see through descriptions and sounds, but then you fill in the rest with your imagination.
Audio gives the listener some more skin in the game and an active role in creating the story. I have a company called Vox Familia that helps family's honor, discover, and share their family's story and I find that having a recording of your grandmother's voice is special and intimate in a way that having a video of your grandma isn't. Once they are gone, to be able to sit in a comfy chair and listen to their laugh and inflection of their voice is an utterly profound experience.
How can podcasters tell a better story?
Podcasters call tell a better story through editing. Even if your podcast is exclusively one long interview, there's still a way to introduce that and layout the information that can be more effective than if you just let the tape roll.
Editing is how you go from good to great. Editing can mean losing things you thought of as precious to your story. Editing is hard, but worth it.
Editing also often requires someone who is not you. Get feedback about your stories from people you trust and who won't lie to you. Then implement what you agree with.
You can subscribe to Neighbors via Apple Podcasts, Google Podcasts, or RSS.
Podcast Hosting Skills Podcast Marketing Media Training 4 min read
Podcaster Spotlight Podcast Hosting Skills 6 min read


Hey folks! So i've finally gotten around to watching the second half of Sword Art Online (for which there will be a review, I promise) and with fantastic timing Lazarinth over at Fantasy & Anime posted an article on why he isn't a fan of the series. Naturally I rose up to defend my love for all things virtual reality (except for maybe Log Horizon, but that's another story).
What emerged was a fairly decent discussion about a number of large and small problems we had with the series as well as some issues we simply couldn't come to an agreement on. So basically, you should check it out.
This entry was posted in Announcement and tagged Anime, Announcement, discussion, SAO, Sword Art Online. Bookmark the permalink.


Fitbit has acquired smartwatch manufacturer Stone and also it is reported that purchase is a small amount as per the information Fitbit has actually obtained its possessions includes Software application and also property. The watch maker Person was significantly thinking about getting stone for about 740 million bucks in 2015 but the offer was fallen short. The Fitbit is paying 40 million dollars for the firm and also is covering their financial obligations. Previously in this year stone CEO has actually verified that firm has elevated 28 million bucks in the red as well as venture financing.
Fitbit acquiring pebble methods that it is not about equipment yet about taking skill, software, as well as native system and also having it will certainly help diversify Fitbit's item schedule as well as if it selects to take place additionally down the smartwatch pathway. This acquisition will likewise allow Fitbit eliminate its rival. Both make their own software and are agnostic when it comes to which mobile phones they function, as both share information complimentary with third party apps as Fitbit has stubbornly rejected to allow information showing Google fit software.
and also started marketing its item on the web site and began including stores as well as was the most significant difficulty ever as it was a totally brand-new product and also took a great deal of job to persuade retailers that consumers were mosting likely to acquire Fitbit and ended up being a mass market product.


Almaden Valley, Thai Restaurant With Type 41 License - Turn Key For Sale On BizBen.
Clean turn-key 720 sq.ft Thai restaurant in a busy shopping center is ready for a bright and inventive new owner.
3.5 years on lease. Rent and NNN is appx. 2200/mo.
Garbage and water is included.
All equipment is in working order and has been maintained on a regular basis. Equipment includes 2 refrigerators, freezer, 6 burner stove with wok grates, char-grill, fryer, 7ft. Hood with updated fire suppression system, and 3 pan warmer.
3 compartment, hand wash, and prep sinks are included, as well as tables, chairs, storage racks, and prep tables. 100lb in-ground grease trap is under 3 years old as is the air compensation unit.
All cookware, storage containers, and storage racks are all under 3 years old. Great location for lunch, dinner, and to-go orders. Catering could be implemented for the right owner. Inside seating for 16 with outside seating for 6.
The listing # 249198 Thai Restaurant With Type 41 License - Turn Key - Almaden Valley, Santa Clara below is currently OFF THE MARKET due to that it is either in escrow at this time or has recently been sold. For more businesses for sale that are like this Thai Restaurant With Type 41 License - Turn Key in Almaden Valley, Santa Clara please see a sample of BizBen active listings below and links to all similar listings on BizBen.com.
Located in the heart of Downtown San Jose. In the San Pedro Square Featuring different types of meats, ribs, salads in Bistro type of cooking. Lots of foot traffic from office buildings and condos in the area. Also close to the Shark tank. Business established in 2012. Major price reduction .


text:
/*
Known Issues & Limitations:
	- no support for Multi-Dimensional Segment Clustering in this version

Changes in 1.5.0
	+ Added new parameter that allows to filter the results by specific partition number (@partitionNumber)
	+ Added new parameter for the searching precise name of the object (@preciseSearch)
	+ Added new parameter for the identifying the object by its object_id (@objectId)
	+ Expanded search of the schema to include the pattern search with @preciseSearch = 0
	+ Added new parameter for showing the number of distinct values within the segments, the percentage related to the total number of the rows within table/partition (@countDistinctValues)
	+ Added new parameter for showing the frequency of the column usage as predicates during querying (@scanExecutionPlans), which results are included in the overall recommendation for segment elimination
	+ Added new parameter for showing the overall recommendation number for each table/partition (@showSegmentAnalysis)
	+ Added information on the Predicate Pushdown support (it will be showing results depending on the used edition) - column [Predicate Pushdown]

Changes in 1.5.1
	+ Added new parameter for specifying the name of the database, where the Columnstore Indexes should be located (@dbName)
*/

declare @SQLServerVersion nvarchar(128) = cast(SERVERPROPERTY('ProductVersion') as NVARCHAR(128)),
		@SQLServerEdition nvarchar(128) = cast(SERVERPROPERTY('Edition') as NVARCHAR(128));
declare @errorMessage nvarchar(512);

-- Ensure that we are running SQL Server 2019 or newer
if substring(@SQLServerVersion,1,CHARINDEX('.',@SQLServerVersion)-1) < N'15'
begin
	set @errorMessage = (N'You are not running SQL Server 2019 or newer. Your SQL Server version is ' + @SQLServerVersion);
	Throw 51000, @errorMessage, 1;
end
GO
--------------------------------------------------------------------------------------------------------------------

/*
	CSIL - Columnstore Indexes Scripts Library for SQL Server vNext:
	Columnstore Alignment - Shows the alignment (ordering) between the different Columnstore Segments
	Version: 1.5.1, September 2017
*/
create or alter procedure dbo.cstore_GetAlignment(
-- Params --
	@dbName SYSNAME = NULL,					-- Identifies the Database to run the stored procedure against. If this parameter is left to be NULL, then the current database is used
	@schemaName nvarchar(256) = NULL,		-- Allows to show data filtered down to the specified schema
	@tableName nvarchar(256) = NULL,		-- Allows to show data filtered down to 1 particular table
	@preciseSearch bit = 0,					-- Defines if the schema and data search with the parameters @schemaName & @tableName will be precise or pattern-like
	@showSegmentAnalysis BIT = 0,			-- Allows showing the overall recommendation for aligning order for each table/partition
	@countDistinctValues BIT = 0,			-- Allows showing the number of distinct values within the segments, the percentage related to the total number of the rows within table/partition (@countDistinctValues)
	@scanExecutionPlans BIT = 0,			-- Allows showing the frequency of the column usage as predicates during querying (@scanExecutionPlans), which results is included in the overall recommendation for segment elimination
	@indexLocation varchar(15) = NULL,		-- Allows to filter Columnstore Indexes based on their location: Disk-Based & In-Memory
	@objectId int = NULL,					-- Allows to idenitfy a table thorugh the ObjectId
	@showPartitionStats bit = 1,			-- Shows alignment statistics based on the partition
	@partitionNumber int = 0,				-- Allows to filter data on a specific partion. Works only if @showPartitionDetails is set = 1
	@showUnsupportedSegments bit = 1,		-- Shows unsupported Segments in the result set
	@columnName nvarchar(256) = NULL,		-- Allows to show data filtered down to 1 particular column name
	@columnId int = NULL					-- Allows to filter one specific column Id
-- end of --
) as
begin
	SET NOCOUNT ON;

	IF @dbName IS NULL
	SET @dbName = DB_NAME(DB_ID());

	DECLARE @dbId INT = DB_ID(@dbName);
	DECLARE @sql NVARCHAR(MAX);

	DROP TABLE IF EXISTS #column_store_segments;
	CREATE TABLE #column_store_segments(
		[SchemaName] SYSNAME NOT NULL,
		[TableName] SYSNAME NOT NULL,
		[object_id] INT NOT NULL,
		[partition_number] INT NOT NULL,
		[hobt_id] INT,
		[partition_id] INT NOT NULL,
		[column_id] INT NOT NULL,
		[segment_id] INT NOT NULL,
		[min_data_id] INT NOT NULL,
		[max_data_id] INT NOT NULL
	);

	SET @sql = N'
	SELECT SchemaName, TableName, object_id, partition_number, hobt_id, partition_id, column_id, segment_id, min_data_id, max_data_id
	INTO #column_store_segments
	FROM ( select object_schema_name(part.object_id,@dbId) as SchemaName, object_name(part.object_id,@dbId) as TableName,
				part.object_id, part.partition_number, part.hobt_id, part.partition_id,
				seg.column_id, seg.segment_id, seg.min_data_id, seg.max_data_id
				FROM ' + QUOTENAME(@dbName) + N'.sys.column_store_segments seg
				INNER JOIN ' + QUOTENAME(@dbName) + N'.sys.partitions part
				   ON seg.hobt_id = part.hobt_id and seg.partition_id = part.partition_id
			union all
			select object_schema_name(part.object_id,db_id(''tempdb'')) as SchemaName, object_name(part.object_id,db_id(''tempdb'')) as TableName,
				part.object_id, part.partition_number, part.hobt_id, part.partition_id,
				seg.column_id, seg.segment_id, seg.min_data_id, seg.max_data_id
				FROM tempdb.sys.column_store_segments seg
				INNER JOIN tempdb.sys.partitions part
				   ON seg.hobt_id = part.hobt_id and seg.partition_id = part.partition_id
		) as Res';

	DECLARE @paramDefinition NVARCHAR(1000) =  '@dbId int';

	EXEC sp_executesql @sql, @paramDefinition, @dbId = @dbId;

	ALTER TABLE #column_store_segments
		ADD UNIQUE (hobt_id, partition_id, column_id, min_data_id, segment_id);

	ALTER TABLE #column_store_segments
		ADD UNIQUE (hobt_id, partition_id, column_id, max_data_id, segment_id);

	DROP TABLE IF EXISTS #SegmentAlignmentResults;

	--- ***********
	CREATE TABLE #SegmentAlignmentResults(
		[TableName] NVARCHAR(256) NOT NULL,
		[Location] VARCHAR(15) NOT NULL,
		[Partition] INT NOT NULL,
		[Column Id] INT NOT NULL,
		[ColumnName] NVARCHAR(128) NOT NULL,
		[ColumnType] NVARCHAR(128) NOT NULL,
		[Segment Elimination] VARCHAR(25) NOT NULL,
		[Predicate Pushdown] VARCHAR(25) NOT NULL,
		[Dealigned Segments] INT NOT NULL,
		[Total Segments] INT NULL,
		[Segment Alignment %] DECIMAL(6,2) NOT NULL);

	SET @sql = N'
	WITH cteSegmentAlignment as (
		select  part.object_id,
				case ind.data_space_id when 0 then ''In-Memory'' else ''Disk-Based'' end as [Location],
				quotename(object_schema_name(part.object_id,@dbId)) + ''.'' + quotename(object_name(part.object_id,@dbId)) as [TableName],
				case @showPartitionStats when 1 then part.partition_number else 1 end as [partition_number],
				seg.[partition_id], seg.[column_id], cols.name as [ColumnName], tp.name as [ColumnType],
				seg.[segment_id],
				CONVERT(BIT, MAX(CASE WHEN filteredSeg.segment_id IS NOT NULL THEN 1 ELSE 0 END)) AS [hasOverlappingSegment]
			from ' + QUOTENAME(@dbName) + N'.sys.column_store_segments seg
				inner join ' + QUOTENAME(@dbName) + N'.sys.partitions part
					on seg.hobt_id = part.hobt_id and seg.partition_id = part.partition_id
				inner join ' + QUOTENAME(@dbName) + N'.sys.indexes ind
					on part.object_id = ind.object_id and ind.type in (5,6)
				inner join ' + QUOTENAME(@dbName) + N'.sys.columns cols
					on part.object_id = cols.object_id and (seg.column_id = cols.column_id + case ind.data_space_id when 0 then 1 else 0 end )
				inner join ' + QUOTENAME(@dbName) + N'.sys.types tp
					on cols.system_type_id = tp.system_type_id and cols.user_type_id = tp.user_type_id
				outer apply (
					SELECT TOP 1 otherSeg.segment_id
					FROM #column_store_segments otherSeg WITH (FORCESEEK)
					WHERE seg.hobt_id = otherSeg.hobt_id
							AND seg.partition_id = otherSeg.partition_id
							AND seg.column_id = otherSeg.column_id
							AND seg.segment_id <> otherSeg.segment_id
							AND (seg.min_data_id < otherSeg.min_data_id and seg.max_data_id > otherSeg.min_data_id )  -- Scenario 1
					UNION ALL
					SELECT TOP 1 otherSeg.segment_id
					FROM #column_store_segments otherSeg WITH (FORCESEEK)
					WHERE seg.hobt_id = otherSeg.hobt_id
							AND seg.partition_id = otherSeg.partition_id
							AND seg.column_id = otherSeg.column_id
							AND seg.segment_id <> otherSeg.segment_id
							AND (seg.min_data_id < otherSeg.max_data_id and seg.max_data_id > otherSeg.max_data_id )  -- Scenario 2
				) filteredSeg
			where
			    (@preciseSearch = 0 AND (@tableName is null or object_name (part.object_id, @dbId) like ''%'' + @tableName + ''%'')
				OR @preciseSearch = 1 AND (@tableName is null or object_name (part.object_id, @dbId) = @tableName) )
			and (@preciseSearch = 0 AND (@schemaName is null or object_schema_name( part.object_id, @dbId ) like ''%'' + @schemaName + ''%'')
				OR @preciseSearch = 1 AND (@schemaName is null or object_schema_name( part.object_id, @dbId ) = @schemaName))
				 AND (ISNULL(@objectId,part.object_id) = part.object_id)
				 AND partition_number = case @partitionNumber when 0 then partition_number else @partitionNumber end
				and ind.data_space_id = isnull( case @indexLocation when ''In-Memory'' then 0 when ''Disk-Based'' then 1 else ind.data_space_id end, ind.data_space_id )
			group by part.object_id, ind.data_space_id, case @showPartitionStats when 1 then part.partition_number else 1 end, seg.partition_id, seg.column_id, cols.name, tp.name, seg.segment_id
		UNION ALL
		select  part.object_id,
				case ind.data_space_id when 0 then ''In-Memory'' else ''Disk-Based'' end as [Location],
				quotename(object_schema_name(part.object_id,db_id(''tempdb''))) + ''.'' + quotename(object_name(part.object_id,db_id(''tempdb''))) as TableName,
				case @showPartitionStats when 1 then part.partition_number else 1 end as partition_number,
				seg.partition_id, seg.column_id, cols.name COLLATE DATABASE_DEFAULT as ColumnName, tp.name COLLATE DATABASE_DEFAULT as ColumnType,
				seg.segment_id,
				CONVERT(BIT, MAX(CASE WHEN filteredSeg.segment_id IS NOT NULL THEN 1 ELSE 0 END)) AS hasOverlappingSegment
			from tempdb.sys.column_store_segments seg
				inner join tempdb.sys.partitions part
					on seg.hobt_id = part.hobt_id and seg.partition_id = part.partition_id
				inner join tempdb.sys.indexes ind
					on part.object_id = ind.object_id and ind.type in (5,6)
				inner join tempdb.sys.columns cols
					on part.object_id = cols.object_id and seg.column_id = cols.column_id
				inner join tempdb.sys.types tp
					on cols.system_type_id = tp.system_type_id and cols.user_type_id = tp.user_type_id
				outer apply (
					SELECT TOP 1 otherSeg.segment_id
					FROM #column_store_segments otherSeg --WITH (FORCESEEK)
					WHERE seg.hobt_id = otherSeg.hobt_id
							AND seg.partition_id = otherSeg.partition_id
							AND seg.column_id = otherSeg.column_id
							AND seg.segment_id <> otherSeg.segment_id
							AND (seg.min_data_id < otherSeg.min_data_id and seg.max_data_id > otherSeg.min_data_id )  -- Scenario 1
					UNION ALL
					SELECT TOP 1 otherSeg.segment_id
					FROM #column_store_segments otherSeg --WITH (FORCESEEK)
					WHERE seg.hobt_id = otherSeg.hobt_id
							AND seg.partition_id = otherSeg.partition_id
							AND seg.column_id = otherSeg.column_id
							AND seg.segment_id <> otherSeg.segment_id
							AND (seg.min_data_id < otherSeg.max_data_id and seg.max_data_id > otherSeg.max_data_id )  -- Scenario 2
				) filteredSeg
			where (@preciseSearch = 0 AND (@tableName is null or object_name (part.object_id,db_id(''tempdb'')) like ''%'' + @tableName + ''%'')
					  OR @preciseSearch = 1 AND (@tableName is null or object_name (part.object_id,db_id(''tempdb'')) = @tableName) )
				 AND (@preciseSearch = 0 AND (@schemaName is null or object_schema_name( part.object_id,db_id(''tempdb'') ) like ''%'' + @schemaName + ''%'')
					  OR @preciseSearch = 1 AND (@schemaName is null or object_schema_name( part.object_id,db_id(''tempdb'') ) = @schemaName))
				 AND (ISNULL(@objectId,part.object_id) = part.object_id)
				 AND ind.data_space_id = isnull( case @indexLocation when ''In-Memory'' then 0 when ''Disk-Based'' then 1 else ind.data_space_id end, ind.data_space_id )
				 AND partition_number = case @partitionNumber when 0 then partition_number else @partitionNumber end
			group by part.object_id, ind.data_space_id, case @showPartitionStats when 1 then part.partition_number else 1 end, seg.partition_id, seg.column_id, cols.name, tp.name, seg.segment_id

	)
	INSERT INTO #SegmentAlignmentResults
	select TableName, Location,
		partition_number as [Partition], cte.column_id as [Column Id], cte.ColumnName,
		cte.ColumnType,
		case cte.ColumnType when ''numeric'' then ''not supported''
							when ''datetimeoffset'' then ''not supported''
							when ''char'' then ''not supported''
							when ''nchar'' then ''not supported''
							when ''varchar'' then ''not supported''
							when ''nvarchar'' then ''not supported''
							when ''sysname'' then ''not supported''
							when ''binary'' then ''not supported''
							when ''varbinary'' then ''not supported''
							when ''uniqueidentifier'' then ''not supported''
			else ''OK'' end as [Segment Elimination],
		case cte.ColumnType when ''numeric'' then ''not supported''
						when ''datetimeoffset'' then ''not supported''
						when ''char'' then CASE WHEN SERVERPROPERTY(''EngineEdition'') = 3 THEN ''OK'' ELSE ''not supported'' END
						when ''nchar'' then CASE WHEN SERVERPROPERTY(''EngineEdition'') = 3 THEN ''OK'' ELSE ''not supported'' END
						when ''varchar'' then CASE WHEN SERVERPROPERTY(''EngineEdition'') = 3 THEN ''OK'' ELSE ''not supported'' END
						when ''nvarchar'' then CASE WHEN SERVERPROPERTY(''EngineEdition'') = 3 THEN ''OK'' ELSE ''not supported'' END
						when ''sysname'' then CASE WHEN SERVERPROPERTY(''EngineEdition'') = 3 THEN ''OK'' ELSE ''not supported'' END
						when ''binary'' then ''not supported''
						when ''varbinary'' then ''not supported''
						when ''uniqueidentifier'' then ''not supported''
			else ''OK'' end as [Predicate Pushdown],
		sum(CONVERT(INT, hasOverlappingSegment)) as [Dealigned Segments],
		count(*) as [Total Segments],
		100 - cast( sum(CONVERT(INT, hasOverlappingSegment)) * 100.0 / (count(*)) as Decimal(6,2)) as [Segment Alignment %]

		from cteSegmentAlignment cte
		where ((@showUnsupportedSegments = 0 and cte.ColumnType COLLATE DATABASE_DEFAULT not in (''numeric'',''datetimeoffset'',''char'', ''nchar'', ''varchar'', ''nvarchar'', ''sysname'',''binary'',''varbinary'',''uniqueidentifier'') )
			  OR @showUnsupportedSegments = 1)
			  and cte.ColumnName  = isnull(@columnName,cte.ColumnName COLLATE DATABASE_DEFAULT)
			  and cte.column_id = isnull(@columnId,cte.column_id)
		group by TableName, Location, partition_number, cte.column_id, cte.ColumnName, cte.ColumnType
		order by TableName, partition_number, cte.column_id;';

	SET @paramDefinition				    =  '@indexLocation varchar(15),
												@preciseSearch bit,
												@tableName nvarchar(256),
												@schemaName nvarchar(256),
												@objectId int,
												@partitionNumber int,

												@showSegmentAnalysis BIT,
												@countDistinctValues BIT,
												@scanExecutionPlans BIT,
												@showPartitionStats BIT,
												@showUnsupportedSegments bit,
												@columnName nvarchar(256),
												@columnId int,
												@dbId int';

	EXEC sp_executesql @sql, @paramDefinition, @indexLocation = @indexLocation,
											   @preciseSearch = @preciseSearch, @tableName = @tableName,
											   @schemaName = @schemaName, @objectId = @objectId,
											   @partitionNumber = @partitionNumber,
											   @showSegmentAnalysis = @showSegmentAnalysis,
											   @countDistinctValues = @countDistinctValues,
											   @scanExecutionPlans = @scanExecutionPlans,
											   @showPartitionStats = @showPartitionStats,
											   @showUnsupportedSegments = @showUnsupportedSegments,
											   @columnName = @columnName, @columnId = @columnId,
											   @dbId = @dbId;

	--- *****************************************************
	IF @showSegmentAnalysis = 1
	BEGIN

		DECLARE @alignedColumnList NVARCHAR(MAX) = NULL;
		DECLARE @alignedColumnNamesList NVARCHAR(MAX) = NULL;
		DECLARE @alignedTable NVARCHAR(256) = NULL,
				@alignedPartition INT = NULL,
				@partitioningClause NVARCHAR(500) = NULL;

		DROP TABLE IF EXISTS #DistinctCounts;
		CREATE TABLE #DistinctCounts(
			TableName SYSNAME NOT NULL,
			PartitionId INT NOT NULL,
			ColumnName SYSNAME NOT NULL,
			DistinctCount BIGINT NOT NULL,
			TotalRowCount BIGINT NOT NULL
		);

		DECLARE alignmentTablesCursor CURSOR LOCAL FAST_FORWARD FOR
			SELECT DISTINCT TableName, [Partition]
				FROM #SegmentAlignmentResults;

		OPEN alignmentTablesCursor

		FETCH NEXT FROM alignmentTablesCursor
			INTO @alignedTable, @alignedPartition;

		WHILE @@FETCH_STATUS = 0
		BEGIN
			IF @countDistinctValues = 1
			BEGIN
				-- Define Partitioning Clause when showing partitioning information
				SET @partitioningClause = '';
				SET @sql = N'
				SELECT @partitioningClause = ''WHERE $PARTITION.['' + pf.name + ''](['' + cols.name + '']) = '' + CAST(@alignedPartition AS VARCHAR(8))
 								 FROM ' + QUOTENAME(@dbName) + N'.sys.indexes ix
								 INNER JOIN ' + QUOTENAME(@dbName) + N'.sys.partition_schemes ps on ps.data_space_id = ix.data_space_id
								 INNER JOIN ' + QUOTENAME(@dbName) + N'.sys.partition_functions pf on pf.function_id = ps.function_id
								INNER JOIN ' + QUOTENAME(@dbName) + N'.sys.index_columns ic
									ON ic.object_id = ix.object_id AND ix.index_id = ic.index_id
								INNER JOIN ' + QUOTENAME(@dbName) + N'.sys.all_columns cols
									ON ic.column_id = cols.column_id AND ic.object_id = cols.object_id
								WHERE ix.object_id = object_id(@alignedTable)
									AND ic.partition_ordinal = 1 AND @showPartitionStats = 1; ';

				SET @paramDefinition =  '@alignedTable NVARCHAR(128),
										 @alignedPartition INT,
										 @showPartitionStats BIT,
										 @dbId int,
										 @partitioningClause NVARCHAR(500) OUTPUT';

				EXEC sp_executesql @sql, @paramDefinition, @alignedTable = @alignedTable,
														   @alignedPartition = @alignedPartition,
														   @showPartitionStats = @showPartitionStats,
														   @partitioningClause = @partitioningClause OUTPUT,
														   @dbId = @dbId;

				-- Get the list with COUNT(DISTINCT [ColumnName])
				SET @sql = N'
				SELECT @alignedColumnList = STUFF((
					SELECt '', COUNT( DISTINCT '' + QUOTENAME(name) + '') as ['' + name + '']''
						FROM ' + QUOTENAME(@dbName) + N'.sys.columns cols
						WHERE OBJECT_ID(''' + QUOTENAME(@dbName) + N'.' + @alignedTable + ''') = cols.object_id
							AND cols.name = isnull(@columnName,cols.name)
							AND cols.column_id = isnull(@columnId,cols.column_id)
						ORDER BY cols.column_id DESC
						FOR XML PATH('''')
					), 1, 1, '''');'

				SET @paramDefinition =  '@alignedTable NVARCHAR(256),
										 @columnName nvarchar(256),
										 @columnId INT,
										 @dbId int,
										 @alignedColumnList NVARCHAR(MAX) OUTPUT';

				EXEC sp_executesql @sql, @paramDefinition, @alignedTable = @alignedTable,
														   @columnName = @columnName,
														   @columnId = @columnId,
														   @alignedColumnList = @alignedColumnList OUTPUT,
														   @dbId = @dbId;

				-- Getting the list with the column names
				SET @sql = N'
				SELECT @alignedColumnNamesList = STUFF((
					SELECt '', ['' + name + '']''
						FROM ' + QUOTENAME(@dbName) + N'.sys.columns cols
						WHERE OBJECT_ID(''' + QUOTENAME(@dbName) + N'.' + @alignedTable + ''') = cols.object_id
							AND cols.name = isnull(@columnName,cols.name)
							AND cols.column_id = isnull(@columnId,cols.column_id)
						ORDER BY cols.column_id DESC
						FOR XML PATH('''')
					), 1, 1, '''');';

				SET @paramDefinition =  '@alignedTable NVARCHAR(128),
										 @columnName nvarchar(256),
										 @columnId INT,
										 @dbId int,
										 @alignedColumnNamesList NVARCHAR(MAX) OUTPUT';

				EXEC sp_executesql @sql, @paramDefinition, @alignedTable = @alignedTable,
														   @columnName = @columnName,
														   @columnId = @columnId,
														   @alignedColumnNamesList = @alignedColumnNamesList OUTPUT,
														   @dbId = @dbId;

				-- Insert Count(*) and COUNT(DISTINCT*) into the #DistinctCounts table
				SET @sql = ( N'INSERT INTO #DistinctCounts ' +
						'SELECT ''' + @alignedTable + ''' as TableName, ' + cast(@alignedPartition as VARCHAR(10)) + ' as PartitionNumber, ColumnName, DistinctCount, __TotalRowCount__ as TotalRowCount ' +
						'	FROM (SELECT ''DistCount'' as [__Op__], COUNT(*) as __TotalRowCount__, ' + @alignedColumnList +
										 ' FROM ' + QUOTENAME(@dbName) + N'.' + @alignedTable + ISNULL(@partitioningClause,'') + ') res ' +
						' UNPIVOT ' +
						'	  ( DistinctCount FOR ColumnName IN(' + @alignedColumnNamesList + ') ' +
						'	  ) AS finalResult;' );

				SET @paramDefinition =  '@alignedTable NVARCHAR(128),
										 @columnName nvarchar(256),
										 @columnId INT,
										 @alignedPartition INT,
										 @dbName SYSNAME,
										 @dbId int,
										 @alignedColumnList NVARCHAR(MAX),
										 @alignedColumnNamesList NVARCHAR(MAX)';

				EXEC sp_executesql @sql, @paramDefinition, @alignedTable = @alignedTable,
														   @columnName = @columnName,
														   @columnId = @columnId,
														   @alignedColumnNamesList = @alignedColumnNamesList,
														   @alignedPartition = @alignedPartition,
														   @alignedColumnList = @alignedColumnList,
														   @dbName = @dbName,
														   @dbId = @dbId;
			END

			FETCH NEXT FROM alignmentTablesCursor
				INTO @alignedTable, @alignedPartition;
		END

		CLOSE alignmentTablesCursor;
		DEALLOCATE alignmentTablesCursor;

		-- Create table storing results of the access via cached execution plans
		DROP TABLE IF EXISTS #CachedAccessToColumnstore;
		CREATE TABLE #CachedAccessToColumnstore(
			[Schema] SYSNAME NOT NULL,
			[Table] SYSNAME NOT NULL,
			[TableName] SYSNAME NOT NULL,
			[ColumnName] SYSNAME NOT NULL,
			[ScanFrequency] BIGINT,
			[ScanRank] DECIMAL(16,6)
		);

		-- Scan cached execution plans and extract the frequency with which the table columns are searched
		IF @scanExecutionPlans = 1
		BEGIN
			-- Extract information from the cached execution plans to determine the frequency of the used(pushed down) predicates against Columnstore Indexes
			SET @sql = N'
			;WITH XMLNAMESPACES (DEFAULT ''http://schemas.microsoft.com/sqlserver/2004/07/showplan'')
			INSERT INTO #CachedAccessToColumnstore
			SELECT [Schema],
				   [Table],
				   [Schema] + ''.'' + [Table] as TableName,
				   [Column] as ColumnName,
				   SUM(execution_count) as ScanFrequency,
				   Cast(0. as Decimal(16,6)) as ScanRank
				FROM (
					SELECT x.value(''(@Database)[1]'', ''nvarchar(128)'') AS [Database],
						   x.value(''(@Schema)[1]'', ''nvarchar(128)'') AS [Schema],
						   x.value(''(@Table)[1]'', ''nvarchar(128)'') AS [Table],
						   x.value(''(@Alias)[1]'', ''nvarchar(128)'') AS [Alias],
						   x.value(''(@Column)[1]'', ''nvarchar(128)'') AS [Column],
						   xmlRes.execution_count
						FROM (
							SELECT dm_exec_query_plan.query_plan,
								   dm_exec_query_stats.execution_count
								FROM ' + QUOTENAME(@dbName) + N'.sys.dm_exec_query_stats
									CROSS APPLY ' + QUOTENAME(@dbName) + N'.sys.dm_exec_sql_text(dm_exec_query_stats.sql_handle)
									CROSS APPLY ' + QUOTENAME(@dbName) + N'.sys.dm_exec_query_plan(dm_exec_query_stats.plan_handle)
								WHERE query_plan.exist(''//RelOp//IndexScan//Object[@Storage = "ColumnStore"]'') = 1
									  AND query_plan.exist(''//RelOp//IndexScan//Predicate//Compare//ScalarOperator//Identifier//ColumnReference'') = 1
						) xmlRes
							CROSS APPLY xmlRes.query_plan.nodes(''//RelOp//IndexScan//Predicate//Compare//ScalarOperator//Identifier//ColumnReference'') x1(x) --[@Database = "[' + @dbName + ']"]
							WHERE
							-- Avoid Inter-column Search references since they are not supporting Segment Elimination
							NOT (query_plan.exist(''(//RelOp//IndexScan//Predicate//Compare//ScalarOperator//Identifier//ColumnReference[@Table])[1]'') = 1
								AND query_plan.exist(''(//RelOp//IndexScan//Predicate//Compare//ScalarOperator//Identifier//ColumnReference[@Table])[2]'') = 1
								AND x.value(''(@Table)[1]'', ''nvarchar(128)'') = x.value(''(@Table)[2]'', ''nvarchar(128)'') )
							) res
				WHERE res.[Database] = QUOTENAME(@dbName) AND res.[Schema] IS NOT NULL AND res.[Table] IS NOT NULL
					AND res.[Column] COLLATE DATABASE_DEFAULT = isnull(@columnName,res.[Column])
				GROUP BY [Schema], [Table], [Column];'

				SET @paramDefinition =  '@alignedTable NVARCHAR(128),
										 @columnName nvarchar(256),
										 @columnId INT,
										 @dbName SYSNAME,
										 @dbId int';

				EXEC sp_executesql @sql, @paramDefinition, @alignedTable = @alignedTable,
														   @columnName = @columnName,
														   @columnId = @columnId,
														   @dbName = @dbName,
														   @dbId = @dbId;

			-- Distribute Rank based on the values between 0 & 100
			UPDATE #CachedAccessToColumnstore
				SET ScanRank = ScanFrequency * 100. / (SELECT MAX(ScanFrequency) FROM #CachedAccessToColumnstore);
		END

		-- Deliver the final result
		SELECT res.*, cnt.DistinctCount, cnt.TotalRowCount,
			CAST(cnt.DistinctCount * 100. / CASE cnt.TotalRowCount WHEN 0 THEN 1 ELSE cnt.TotalRowCount END  as Decimal(8,3)) as [PercDistinct],
			ISNULL(ScanFrequency,0) AS ScanFrequency,
			DENSE_RANK() OVER ( PARTITION BY res.[TableName], [Partition]
						  ORDER BY ISNULL(ScanRank,-100) +
								CASE WHEN [DistinctCount] < [Total Segments] OR [DistinctCount] < 2 THEN - 100 ELSE 0 END +
								( ISNULL(cnt.DistinctCount,0) * 100. / CASE ISNULL(cnt.TotalRowCount,0) WHEN 0 THEN 1 ELSE cnt.TotalRowCount END)
								- CASE [Segment Elimination] WHEN 'OK' THEN 0. ELSE 1000. END
								DESC ) AS [Recommendation]
			FROM #SegmentAlignmentResults res
			LEFT OUTER JOIN #DistinctCounts cnt
				ON res.TableName = cnt.TableName COLLATE DATABASE_DEFAULT
				AND res.ColumnName = cnt.ColumnName COLLATE DATABASE_DEFAULT
				AND res.[Partition] = cnt.PartitionId
			LEFT OUTER JOIN #CachedAccessToColumnstore cache
				ON res.TableName = cache.TableName COLLATE DATABASE_DEFAULT
					AND res.ColumnName = cache.ColumnName COLLATE DATABASE_DEFAULT
			ORDER BY res.TableName, res.Partition, res.[Column Id];
	END
	ELSE
	BEGIN
		SELECT res.*
				FROM #SegmentAlignmentResults res
			ORDER BY res.[TableName], res.[Partition], res.[Column Id];
	END

	-- Cleanup
	DROP TABLE IF EXISTS #SegmentAlignmentResults;
	DROP TABLE IF EXISTS #DistinctCounts;
	DROP TABLE IF EXISTS #CachedAccessToColumnstore;

end

GO

redpajama_set_name: RedPajamaGithub


Cutting-Edge DJ and Live Software to Make Your Beats!
Choose from among the best in DJ software for PC or Mac. Not sure what you need? Read on for expert advice!
Sample decks, high-quality effects, and algorithms that let you create impressive beats are some of the reasons why Native Instruments' Traktor Pro is the top DJing software. Ableton gives you Session View: A beautifully designed and implemented window where you can launch MIDI clips/tracks and sync'd audio samples quickly and easily. There is more prep involved, but your creative side can really come out! Like NI, Ableton also has matching hardware available to allow you to make your music effortless. There are also other great pieces of DJ mixing software for sale, including Sony ACID Pro, Serato DJ, Fruity Loops, and more.
Want it right now? Buy and download DJ software for Mac or PC for select software. Downloadable options include Ableton Live 9, Band in a Box, and more.
Buy DJ software from MIDI Store, a musician-owned online source for all things DJ and live music. Still have software questions? Call us at 928-284-1619! Our owner will answer your call.