Interval queries in SQL Server

In mathematics, the interval is a set of values ​​between some lower value, and some high value. There are different types of intervals, which are required to provide a database, including the time (e.g., sessions, contracts, projects, appointments, validity period), spatial (e.g. road segments) and numeric (for example, temperature ranges).

Starting with SQL Server 2008, spatial intervals can be represented using spatial data types GEOMETRY and GEOGRAPHY and handle these types of data through methods. For spatial queries can also use indexing and optimization.

For other types of slots, in particular a very common temporary type in SQL Server

Continue reading Interval queries in SQL Server

S.Horevskogo 34 floors put a shadow on the entire Upper Town

Administrative, business and public center "Minsk-City" is to appear on the 350 acres of terrain. The approximate price of the project — about 1 billion dollars. Sunday reports from municipal channels followed that in the center of Minsk, near the museum majestically Russian war may seem over 30-storey hotel, and under October Square — multilevel parking. What are the consequences for Minsk can have these projects? Views on art historian, architectural historian Sergei Hareuski, Minsk, as though what a big city, required such a huge structure. But must built out of need and not on the orders of the country,

Continue reading S.Horevskogo 34 floors put a shadow on the entire Upper Town

Doctor instead of a priest

On this "Radio Liberty" is now Chairman of the Central Election Commission Lidia Yermoshina. It is understood that the CEC November 14 register his candidacy. One vacancy in the list so called Senators from the capital appeared after, as a month and a half back the Archpriest Fedor Full recently registering suddenly withdrew his candidacy. Belarusian Constitution defines — in the upper chamber of the National Assembly includes 64 people. Any area of the city of Minsk and isolated by 8 people, and another 8 appointed by the head of the country. On present day in the upper chamber of

Continue reading Doctor instead of a priest

Successful launch of Proton-M

Today at 23.15 MSK with launcher platform 39 200 Baikonur starting calculations of rocket-space industry of Russia made a successful launch of a space rocket "Proton-M" with the upper stage "Breeze-M" and the spacecraft "Telstar 14R." After separation from the regular third-stage rocket booster "Briz-M" continues the removal of spacecraft "Telstar-14P" on the desired orbit. Separation of the spacecraft from the upper stage is scheduled for 8:28 MSK May 21, 2011 The contract for the use of the carrier rocket "Proton-M" to launch U.S. satellite "Telstar 14R" concluded the company International Launch Services Inc. (ILS). Controlling stake in

Continue reading Successful launch of Proton-M

The upper layers of the soil in some parts of the U.S. contain up to 10,000 percent more cesium than previously thought

The upper layers of the soil in some parts of the U.S. contain up to 10,000 percent more cesium than previously thought Danger Zone

Many people have stopped talking about the consequences of the accident at the nuclear power plant "Fukushima-1", but the pollution continues. The upper layers of the soil in the state of California and the Pacific Northwest are at risk of radiation after the disaster. Soil samples taken from different locations in California, showed that the greatest amount of radioactive cesium, 0.0739 Ci / kg was found in the city of Sacramento. But, according to the scientist

Continue reading The upper layers of the soil in some parts of the U.S. contain up to 10,000 percent more cesium than previously thought

Big earthquake in Tohoku affected upper atmosphere earlier than Earth

Big earthquake in Tohoku affected upper atmosphere earlier than Earth Natural Disasters

An earthquake of magnitude 9 struck March 11, 2011 on the coast of the Tohoku region in Japan, heralded the world's first integrated global disasters wrought disastrous tsunami, micro-earthquakes and tremors around the world.

Scientists have recently discovered that the earthquake was preceded by fluctuations in the ionosphere, the upper part of the atmosphere. Failures of electrically charged particles in the ionosphere caused by an abnormality in the radio signals between systems through global positioning satellite receivers and repeaters ground stations.

Geophysicist Kosuke Heki analyzed data from more

Continue reading Big earthquake in Tohoku affected upper atmosphere earlier than Earth

With the Plesetsk cosmodrome carrier rocket Soyuz-2.1b

November 28 at 12:00 MSK 25 minutes from Launch Complex 43 pad of Plesetsk cosmodrome by the crews of the Space Forces, with the participation of specialists aerospace industry, the launch of a space rocket "Soyuz-2.1b" with the upper stage "Fregat" and navigation spacecraft (SC) "Glonass-M" (JSC "ISS them. Academician Reshetnev"). In accordance with cyclogram launch a spacecraft to the target orbit separation «Glonass-M" from the upper stage is scheduled for 15 hours 57 minutes MSK.

 Photo source:uralinform.ru

Saw the launch of the head of Russian Federal Space Agency, who arrived the day before in the framework of

Continue reading With the Plesetsk cosmodrome carrier rocket Soyuz-2.1b

With the Plesetsk cosmodrome carrier rocket Roar

 

Russian carrier rocket "rumble" was launched on January 15 from Plesetsk (Arkhangelsk region). This launch was the first in 2013. Carrier rocket was launched at 20:24 Moscow time.

At 20:30 it successfully separated from the upper stage "Breeze-KM" on spacecraft. In orbit, can see three military satellite "Cosmos."

At 22.09 MSK military spacecraft successfully separated from the third stage booster rocket "rumble" — the upper stage "Breeze-KM". They are taken for management of ground automated control

Note that the start of "Rokot" was planned for December 8. However, on the

Continue reading With the Plesetsk cosmodrome carrier rocket Roar

From Baikonur launched the Proton-M with a European telecommunications satellite

May 14, 2013 at 16:01:59.976 UTC (20:01:59.976 MSK) with PU pad number 39 number 200 Baikonur starting team of rocket-space industry, the launch of Russian rocket "Proton-M" (8K82KM) № 93538 with the upper stage "Breeze-M" (14S43) № 99538 and European telecommunications satellite W3D.

10 minutes after the start of the last stage of the carrier separated orbital assembly in the upper stage and the spacecraft. Further removal is achieved by "razgonnika".

Separation unit from the upper stage is scheduled for May 15 in the 01:15 UTC (05:15 MSK).

Continue reading From Baikonur launched the Proton-M with a European telecommunications satellite

From Baikonur launch rocket Zenit-2SB with American communications satellite

 Photo source:federalspace.ru

On October 6, 01.00.02 MSK with the 45th site Baikonur Cosmodrome launch vehicle launched "Zenit-2SB" with the upper stage "DM-SLB" and the telecommunications spacecraft, "Intelsat-18."

Launch of a space rocket "Zenit-2SB" with the upper stage "DM-SLB" was held as usual. Spacecraft "Intelsat-18" was separated from the upper stage "DM-SLB" and was referred to the management of the customer.

Spacecraft "Intelsat-18" — telecommunications satellite C and Ku-bands for the provision of data services and video on the territory of North America, Australia, New Zealand, Asia and the Pacific. Earlier launch scheduled for Wednesday morning, October

Continue reading From Baikonur launch rocket Zenit-2SB with American communications satellite

SQL - 16 | 0,640 сек. | 7.27 МБ