How to find the row count of all the tables present in database in sql server 2005

The below script using Cursor can be used to find the row count.

---Temporary table created for user tables

Select name,Xtype into #Temp from sysobjects where Xtype like 'U'

and name not in ('MSreplication_subscriptions','MSsubscription_agents')

DECLARE @TName sysname

DECLARE @Records nvarchar(3000)

DECLARE CCursor CURSOR READ_ONLY FOR

SELECT name from #Temp

OPEN CCursor

FETCH NEXT FROM CCursor

INTO @TName

WHILE @@FETCH_STATUS=0

BEGIN

           

            SELECT @Records =

            'SELECT ''' + @TName + '''as TableName, COUNT(*) as [No of Records] ' +

            'FROM [' + @TName + ']'

            EXEC SP_EXECUTESQL @Records

            FETCH NEXT FROM CCursor INTO @TName

END

CLOSE CCursor

DEALLOCATE CCursor

Time Management Exercises

10 Tips to Do More in Less Timeby Mark Foo

 

How you use your time is very crucial. You could waste time unneccessarily or have tons of down time by working quickly.

You should look at these tips if you need some tips with time management. However, the truth is, that there are no cookie-cutter rules for managing your time. It is perfectly okay if your friends' strategies do not work for you.

When trying to perfect your time management skills think about these guidelines:

1. Shut your door and turn your phone off. You need to avoid distractions when you have a task that is very important. Your head will be more clear if you are sitting alone. If you are working on your computer, try not to go to social media websites like Twitter, MySpace, and Facebook since they will just waste your time.

2. Group common things together. When you get home, keep things that you use often , such as your keys and wallet, together. This way you will not have to waste valuable time looking for them the next time you are trying to leave the house.

3. Change your actions. You need to consciously change your behavior if you know that it is being counterproductive in your day.

- For instance, if you are always running late after lunch, set a timer so you can be back to work on time, for example.

4. Use fewer documents and keep them organized. You should not keep every email, memo, document, and file that comes across your desk, even though most of them are electronic.

- Get rid of what you do not need, organize what you need to keep in folders, and only keep things that you need at that time.

5. Make a timeline. If you are doing work or out having fun, estimate how long you will take to be engaged in that activity. If you are constantly aware of the time, you will not look at your watch and wonder where several hours went.

6. Act more, plan less. How many times do you catch yourself trying to figure out what you have to do? You will not move forward if you are just thinking about the future.

- Live in the moment by doing what needs to be done to finish your tasks.

7. Do not procrastinate. Many people have trouble with this. You will spend much more time thinking about a project when you are trying to avoid it than you would if you just did it right away.

- Stop making excuses for yourself and just do what needs to be done. Once you finish something that you didn't want to do, you will feel so much better about yourself and you will want to take on another task.

8. Have goals. Every plan should have goals. It is much easier to keep track of your progress if you have goals outlined so you know what is done and what is still waiting for attention.

9. Give yourself a reward. When you do a good job, make sure that you give yourself a reward. If you know that there is a reward at the end of a task, you will be much less likely to procrastinate.

- You need to have some fun in your life.

10. Give yourself a break. You don't want to be overworked and burnt out although discipline is important. When you give yourself a chance to take a break and relax, you will actually give your productivity a boost because your mind has a chance to reflect, rejuvenate, and repair itself subconsciously.

- Clear your mind by taking 10-minute breaks every hour.

A last bit of advice.

You need to find time management tips that work the best for you personally. That is the most important thing. Keep track of when you are wasting time the most and when you procrastinate.

Just be sure to keep taking steps in the right direction and you'll soon conquer the time wasters that have kept you from success for far too long!

 

History of 31st December

335 - St Silvester I ends his reign as Catholic Pope
406 - 80,000 Vandels attack the Rhine at Mainz
406 - Vandals, Alans and Suebians cross the Rhine, beginning an invasion of Gallia.
535 - Byzantine General Belisarius completes the conquest of Sicily, defeating the Ostrogothic garrison of Syracuse, and ending his consulship for the year.
765 - Coffin of Ho-tse Shen-hui interred in a stupa built in China
870 - Skirmish at Englefield: Ethelred of Wessex beats Danish invasion army
1229 - James I of Aragon the Conqueror enters Medina Mayurqa (now known as Palma, Spain) thus consummating the Christian conquest of the island of Majorca.
1492 - 100,000 Jews expelled from Sicily
1502 - Cesare Borgia (son of pope Alexander VI) occupies Urbino
1564 - Willem van Orange demands freedom of conscience/religion
1600 - British East India Company chartered
1604 - Admiral Steven van der Haghen's fleet reaches Bantam
1621 - Hungarian King Bethlen Gabor/Ferdinand II sign Treaty of Mikulov
1660 - James II of England is named Duke of Normandy by Louis XIV of France.
1669 - France & Brandenburg sign secret treaty
1670 - France & England sign Boyne-treaty
1680 - Amsterdam opera at Leidsegracht opens
1687 - 1st Huguenots depart France to Cape of Good Hope
1688 - Pro-James II-earl of Devonshire occupies Nottingham [OS=Dec 21]
1695 - A window tax is imposed in England, causing many shopkeepers to brick up their windows to avoid the tax.
1700 - Frisia/Groningen adopt Gregorian calendar, tomorrow is 1/12/1701
1708 - Great Alliance captures Bridge
1711 - Duke of Marlborough fired as English army commander
1744 - James Bradley announces discovery of Earth's nutation motion (wobble)
1745 - Bonnie Prince Charlies army meets with de Esk
1756 - Russia joins the Alliance of Versailles
1758 - British expeditionary army occupies Goree (Dakar) Senegal
1762 - Mozart family moves from Vienna to Salzburg
1775 - Battle of Quebec; Americans unable to take British stronghold
1776 - Rhode Island establishes wage & price controls to curb inflation: Limit is 70 cents a day for carpenters, 42 cents for tailors
1779 - English fleet beat Dutch Merchant vessels
1781 - Bank of North America, 1st US bank opens
1783 - Import of African slaves banned by all of the Northern states
1805 - End of French Republican calendar; France returns to Gregorianism
1831 - Gramercy Park is deeded to New York City.
1841 - Alabama becomes 1st state to license dental surgeons
1852 - Future president & Mrs Rutherford B Hayes marry
1857 - Queen Victoria chooses Ottawa as new capital of Canada
1859 - Dutch colony in Dutch Indies counts 4,800 slaves
1861 - 22,990 mm of rain falls in Cherrapunji Assam in 1861, world record
1862 - -Jan 20th) Battle of Stone's River, TN (Stone River, Monfreesboro)
1862 - Battle of Murfreesboro, Tennessee
1862 - Pres Lincoln signs act admitting West Virginia to Union
1862 - Skirmish at Parker Cross Roads, Tennessee
1862 - Union ironclad ship "Monitor" sank off Cape Hatteras, NC
1870 - J D Schneiter patents rocket mail in France, (not done)
1879 - Cornerstone laid for Iolani Palace (only royal palace in US)
1879 - Cornerstone laid for Honolulu's Iolani Palace
1879 - Edison gives 1st public demonstration of his incandescent lamp
1879 - Gilbert/Sullivan's "Pirates of Penzance," premieres in NYC
1879 - Opera "Pirates of Penzance" is produced (NYC)
1890 - Ellis Island (NYC) opens as a US immigration depot
1896 - 25th auto built in US
1897 - Brooklyn's last day as a city, it incorporates into NYC (1/1/1898)
1902 - Boers & British army sign peace treaty
1904 - The first New Year's Eve celebration is held in Times Square, then known as Longacre Square, in New York, New York.
1906 - French/British/Italian treaty concerning rights on Abyssinia
1907 - For 1st time a ball drops at Times Square to signal new year
1907 - G Mahler conducts the Metropolitan Opera
1910 - US tobacco industry produced 9 billion cigarettes in 1910
1911 - Marie Curie receives her 2nd Nobel Prize
1914 - Colonel Jacob Ruppert & Cap Huston purchase NY Yankees for $460,000
1917 - Dutch Social-democratic trade union NVV counts 159,450 members
1918 - Kid Gleason replaces Pants Rowland as White Sox manager
1920 - Roy Park makes 1st-ball duck in only Test Cricket inn, v Eng at MCG
1921 - Last San Francisco firehorses retired
1923 - 1st transatlantic radio broadcast of a voice, Pittsburgh-Manchester
1923 - BBC begins using Big Ben chime ID
1923 - H Tierney/J McCarthy's musical "Kid Boots," premieres in NYC
1924 - Hubble announces existence of distant galaxies
1925 - 14th congress of CPSU decides to accelerate industry
1927 - Ponsford scores 336 against SA, giving him 1146 for month
1929 - Pope Pius XI publishes encyclical Divini illius magistri
1930 - Pontifical encyclical Casti connubii against mixed marriages
1930 - US tobacco industry produced 123 billion cigarettes in 1930
1932 - John P O'Brien sworn-in as mayor of NYC
1934 - Helen Richey becomes 1st woman to pilot an airmail transport
1935 - CPH becomes Dutch Communist Party
1935 - Charles Darrow patents Monopoly
1938 - Dr R N Harger's "drunkometer," 1st breath test, introduced in Indiana
1938 - Dutch national debt hits ƒ3,986,629,805.70
1939 - 25 U boats sunk this month (81,000 ton)
1939 - Dutch national debt hits ƒ4,218,553,180.99
1940 - 37 U boats sunk this month (213,000 ton)
1941 - Young Park (2) in the Bronx named in honor of Samuel Young
1942 - 60 U boats sunk this month (330,000 ton)
1942 - Battle in Barents Sea
1942 - Potatoes rationed in Holland
1943 - NYC's Times Square greets Frank Sinatra at Paramount Theater
1944 - 48 people die in a train accident in Ogden, Utah
1944 - Japanese army evacuates harbor city Akyab
1944 - World War II: Hungary declares war on Germany.
1945 - Bradman scores 112, his 1st post-War century, SA v Aust Services
1945 - Ratification of UN Charter completed
1946 - French troops leave Lebanon
1946 - Pres Truman officially proclaims end of WW II
1948 - Dutch police actions up Java gone on strike
1949 - 18 countries recognize Republic Indonesia
1950 - Jockeys W Shoemaker & Joe Culmone set record of 388 wins in a year
1951 - 1st battery to convert radioactive energy to electrical announced

1953 - Hulan Jack sworn in as Manhattan Borough president
1953 - WFBC (now WYFF) TV channel 4 in G'ville-Spartanburg, SC (NBC) begins
1953 - Willie Shoemaker shatters record, riding 485 winners in a year
1955 - "Vamp" closes at Winter Garden Theater NYC after 60 performances
1955 - The General Motors Corporation becomes the first U.S. corporation to make over $1 billion USD in a year.
1957 - AAU awards Bobby Morrow, James Sullivan Memorial Trophy
1958 - 47th Davis Cup: USA beats Australia in Brisbane (3-2)
1958 - Cubans dictator Batista flees
1958 - International Geophyscial Year ends
1958 - Willie Shoemaker 1st jockey to win national riding championship 4X
1961 - "lrma La Douce" closes at Plymouth Theater NYC after 527 performances
1961 - 1st performance of Beach Boys
1961 - Beach Boys play their debut gig under that name
1961 - Failed coup by Syrian group in Lebanon
1961 - Green Bay Packers shutout NY Giants 37-0 in NFL championship game
1961 - Marshall Plan expires after distributing more than $12 billion
1962 - "Match Game" debuts on NBC with host Gene Rayburn
1962 - American Basketball League announces suspension of operation
1962 - Dutch leave New Guinea
1962 - Katanga becomes part of Democratic Republic of Congo
1962 - Ohio ends suit against Reds when they agree to stay in Cin for 10 yrs
1963 - Chicago Bears win NFL championship
1963 - Dear Abby show premieres on CBS radio (runs 11 years)
1963 - Jerry Garcia & Bob Weir played music together for the 1st time
1964 - Donald Campbell (UK) sets world water speed record (276.33 mph)
1964 - Indonesia proclaims expelled from the UN
1966 - Monkee's "I'm a Believer" hits #1 & stays there for 7 weeks
1966 - Pirate Radio 390 (Radio Invicata) off England, resumes transmitting
1966 - Test Cricket debut of Bishen Singh Bedi, India v WI Calcutta, 2-92
1966 - Toboggan Chutes begin operation in Cleveland Metroparks
1967 - "Henry, Sweet Henry" closes at Palace Theater NYC after 80 perfs
1967 - 1st NBA game at Great Western Forum, LA Lakers beat Houston 147-118
1967 - Oakland Raiders beat Houston Oilers 40-7 in AFL championship game
1967 - Packers beat Cowboys 21-17 in NFL championship game (-13°F)
1968 - 1st supersonic airliner flown (Russian TU-144)
1968 - 1st test flight of Tupolev TU 144
1968 - NY Jets win AFL championship
1969 - Congo-Brazzaville becomes People's republic, under major Ngouabi
1970 - Congress authorizes Eisenhower dollar coin
1970 - Paul McCartney files a lawsuit to disolve Beatles
1970 - President Allende nationalizes Chilean coal mines
1970 - Would have been start of Aust/Eng Test Cricket at MCG, washed out
1971 - KAID TV channel 4 in Boise, ID (PBS) begins broadcasting
1971 - Lt Gen Robert E Cushman, Jr, USMC, ends term as deputy director of CIA
1972 - 39th Sugar Bowl: Oklahoma 14 beats Penn State 0
1972 - Leap second day; also in 1973-79, 1987
1972 - Miami Dolphins beat Pitts Steelers 21-7 in AFC championship game
1972 - Washington Redskins beat Dallas Cowboys 26-3 in NFC championship game
1973 - 40th Sugar Bowl: Notre Dame 24 beats Alabama 23
1973 - 61st Australian Mens Tennis: John Newcombe beats O Parun (63 67 75 61)
1973 - Johan Cruyff chosen European soccer Player of year
1974 - 41st Sugar Bowl: Nebraska 13 beats Florida 10
1974 - Free agent pitcher Catfish Hunter signs $3M 5 year NY Yank contract
1974 - Gold legal in US, Franklin Mint strikes Panama's Gold 100 balboa coin
1974 - Lindsey Buckingham & Stevie Nicks join Fleetwood Mac
1974 - NY Yankees sign Jim "Catfish" Hunter to 5 yrs for record $3.75 million
1974 - Popular Electronics displays Altair 8800 computer
1975 - 42nd Sugar Bowl: Alabama 13 beats Penn State 6
1976 - TV soap "Somerset" ends 6 year run
1976 - The Cars played their 1st gig
1977 - "Bubbling Brown Sugar" closes at ANTA Theater NYC after 766 perfs
1977 - "Man of La Mancha" closes at Palace Theater NYC after 124 performances
1977 - Amir Sheikh Jabir al-Ahmad al-Jabir Al Sabah becomes leader of Kuwait
1977 - Cambodia drops diplomatic relations with Vietnam
1977 - Donald Woods, a banned white editor flees South Africa
1977 - Ted Bundy escapes from jail in Colorado
1977 - WFAT (Bkln NY pirate radio station) begins broadcasting on 1620 AM
1978 - "Magic Show" closes at Cort Theater NYC after 1859 performances
1978 - "Runaways" closes at Plymouth Theater NYC after 199 performances
1978 - CIA director, Admiral Stansfield Turner retires from the Navy
1978 - Iran shah names Chapour Bakhtiar premier
1978 - Taiwan's final day of diplomatic relations with US
1979 - Winterland Rock Concert Hall in SF closes after 556 concerts
1980 - A Jewish owned hotel in Nairobi Kenya is bombed killing 18
1980 - NY Islanders greatest shutout margin (9-0) vs Chicago Black Hawks
1980 - Senegal president Leopold Senghor resigns
1981 - CNN Headline News debuts
1981 - Lt Jerry Rawlings becomes head of Ghana, suspends constitution
1981 - Netherlands unemployment stands at record 475,000
1982 - CBS Mystery Theater final episode on radio after 8 years
1982 - NBC radio cancels almost all of its network daily features
1982 - TV soap "Doctors" ends 19 year run
1983 - Brunei gains complete independence from Britain
1983 - Jose Happart installed as mayor of Voeren Belgium
1983 - Nigeria's National Assembly dissolves after military coup
1984 - Def Leppard drummer Rick Allen loses his arm in a car crash
1984 - NYC subway gunman Bernhard Goetz surrenders to police in NH
1984 - Rajiv Gandhi takes office as India's 6th PM succeeds his mom, Indira
1984 - Test Cricket debut of Mohammad Azharuddin, v England at Calcutta
1984 - US leaves UNESCO
1986 - Dupont Plaza Hotel fire in San Juan, Puerto Rico kills 97
1986 - Russian TU-144 flies for 1st time faster than sound
1986 - WIS-AM in Columbia SC changes call letters to WVOC (now WOMG)
1989 - "Me & My Girl" closes at Marquis Theater NYC after 1420 performances
1989 - "Threepenny Opera" closes at Lunt-Fontanne Theater NYC after 65 perfs
1989 - Actress Annabella Sciorra (Jungle Fever) weds Joe Petruzzi
1989 - Fog Bowl: Heavy fog rolls in on Bears 20-12 victory over Eagles
1989 - Jockey Kent Desormeaux sets record with 598 wins in a year
1990 - Iraq begins a military draft of 17 year olds
1990 - Sci-Fi Channel on cable TV begins transmitting

1990 - United Somali Congress seizes Presidential Palace
1991 - CPN, Communist Party of Netherland, last day of existance
1991 - Daniel R McCarthy elected NY Yankee managing general partner
1991 - Dow Jones closes at record high 3168.83
1991 - J Donald Crump resigned as CFL Commissioner
1991 - USSR, last day of existence
1992 - Target date for Europe's single market
1992 - WCBS TV news anchor Carol Martin weds Joe Terry
1993 - Barbra Striesand does her 1st live public concert in 20 years
1993 - Loveboat actress Jill Whelan (27) weds Brad St John (33)
1994 - 1st snowless December in Baltimore Maryland
1994 - Anti Apartheid Group of Netherlands (AABN) disbands
1994 - This date is skipped altogether in Kiribati as the Phoenix Islands and Line Islands change time zones from UTC-11 to UTC+13 and UTC-10 to UTC+14, respectively.
1995 - "Danny Gans on Broadway" closes at Neil Simon NYC
1995 - "Having Our Say" closes at Booth Theater NYC after 308 performances
1995 - "Heiress" closes at Cort Theater NYC after 340 performances
1995 - "Paul Roebson" closes at Longacre Theater NYC after 14 performances
1995 - "Racing Demon" closes at Vivian Beaumont Theater NYC after 48 perfs
1995 - "Tempest" closes at Broadhurst Theater NYC after 71 performances
1995 - 62nd Sugar Bowl: Virginia Tech beats Texas
1995 - Cartoonist Bill Watterson ends his "Calvin & Hobbes" comic strip
1995 - Matthew Elliott scores separate cricket century same day for Victoria
1997 - Intel cuts price of Pentium II-233 MHz from $401 to $268
1997 - Marv Levy, retires as coach of Buffalo Bills
1997 - Microsoft buys Hotmail E-mail service
1997 - More Swedes died than were born in 1997, 1st time since 1809
1997 - Orlando Hernandez, half-brother of pitcher Livan, defects from Cuba
1997 - S Afr & US surgeons separate Zambian Siamese twins joined at the head
1998 - US movie box office hits record $6.24 billion for year
1998 - Exchange rates between the euro and legacy currencies in the Eurozone become fixed.
1999 - Control of Panama Canal reverts to Panama
1999 - Boris Yeltsin resigns as President of Russia, leaving Prime Minister Vladimir Putin as the acting President.
2004 - The official opening of Taipei 101, the current tallest skyscraper in the world, standing at a height of 509 metres (1,670 feet).
2007 - Bocaue Fire. Seven people injured when a fire razed several fireworks stores in the Municipality of Bocaue, Bulacan, Philippines.
2007 - The Massive Big Dig construction project in Boston, Massachusetts ends.

History of 30th December

274 - St Felix I ends his reign as Catholic Pope
987 - French King Hugo Capet crowns his son Robert the compassionate king
1317 - Pontifical degree "Sancta Romania" against spiritualists
1460 - Wars of the Roses: Battle of Wakefield.
1621 - English king James I cracks Protestation of Parliament
1665 - "Messiah" Sjabtai Tswi departs to Constantinople
1666 - Abraham Crijnssen departs to Suriname
1672 - Baron Karl Rabenhaupt occupies Coevorden Neth
1685 - Don Francisco de Agurto installed as land guardian of S Netherlands
1689 - Henry Purcell & Tates opera "Dido & Aeneas," premieres in Chesea
1703 - Tokyo hit by Earthquake; about 37,000 die
1731 - 1st US music concert (Peter Pelham's great room in Boston)
1794 - French troops conquer Grave Neth
1809 - Wearing masks at balls forbidden in Boston
1813 - Danzig surrenders to allied armies
1816 - The Treaty of St. Louis is proclaimed.
1817 - 1st coffee planted in Hawaii (Kona)
1835 - After gold discovery in Ga, Cherokees forced to move across Miss R
1835 - HMS Beagle/Charles Darwin sails from NZ to Sydney
1836 - Lehman-theater in St Petersburg catches fire; 100s die
1844 - Opera "Stradella" after being rewritten is produced (Hamburg)
1853 - A dinner party is held inside a life-size model of an Iguanodon created by Benjamin Waterhouse Hawkins and Sir Richard Owen in south London.
1854 - Pennsylvania Rock Oil Co, 1st in US, incorporated in NYC
1861 - US, banks stops payments in gold
1869 - Philadelphia Knights of Labor forms
1873 - American Metrological Society forms (NYC) weights, measures & money
1875 - Andrassy Note calls for Christian-Muslim religious freedoms
1877 - Johnannes Brahms' 2nd Symphony in D, premieres in Vienna
1879 - Gilbert & Sullivan's "Pirates of Penzance," premieres
1884 - Anton Bruckner's 7th Symphony in E, premieres in Leipzig
1888 - Belgium: king Leopold II installs Order of African Star
1892 - Dr Miles V Lynk, physician, publishes 1st Black medical journal
1893 - Russia signs military accord with France
1896 - Stanley Cup: Montreal Victorias beat Winnipeg Victorias, 6-5
1896 - José Rizal is executed by firing squad in Manila.
1897 - Province of Zululand annexed to Natal colony
1903 - American Political Science Association founded at New Orleans
1903 - Fire at Chicago's Iriquois Theater kills 602
1905 - Former Governor Frank Steunenberg is assassinated near his home in Caldwell, Idaho.
1906 - Iran becomes a constitutional monarchy
1906 - The All India Muslim League is founded in Dacca, East Bengal, British India Empire, which later laid down the foundations of Pakistan.
1907 - Abraham Mills' commission declares Abner Doubleday invented baseball
1908 - Stanley Cup: Mont Wanderers outscore Edmonton, 13-10 in 2 game set
1911 - Crickets S F Barnes takes 5-6 in 1st 11 overs v Aust at MCG
1911 - Sun Yat-sen elected 1st pres of Republic of China
1913 - Barnes takes 17 wickets vs South Africa (8-56 & 9-103)
1915 - Cromarty Harbour, Scot-British cruiser Natal explodes: 405 die
1917 - -32°F (-36°C) in Mountain City, Tennessee (state record)
1917 - -37°F (-38°C) in Lewisburg, WV (state record)
1918 - John E Hoover decides to be called J Edgar Hoover
1919 - Lincoln's Inn in London admits its first female bar student.
1922 - Soviet Union organized as a federation of RSFSR, Ukrainian SSR, Belorussian SSR & Transcaucasian SSR
1924 - Edwin Hubble announces existence of other galactic systems
1925 - NSW score 705 against Victoria, go from 8-475 to 9-701
1926 - Paul Eliot Greens "In Abraham's Bosom," premieres in NYC
1926 - Chicago Tribune reports the Tigers threw a 4-game series to the White Sox in 1917 to help Chicago win the pennant (never substaniated)
1927 - Japan dedicates 1st subway in Orient (route under 2 miles long)
1929 - Cole Porter's musical "Wake Up & Dream," premieres in NYC
1929 - Sigma Gamma Rho Sorority incorporates
1932 - Bradman out for a duck v England at cricket MCG
1933 - -50°F (-46°C) in Bloomfield, Vermont (state record)
1933 - Govt disallows NSB-membership for civil service
1933 - Jack Badcock scores 274 v Victoria, Tasmania's 1st double-ton
1935 - Italian bombers destroy Swedish Red Cross unit in Ethiopia
1936 - United Auto Workers stage 1st sit-down strike, at Fisher Body Plant
1938 - Electronic television system patented (V K Zworykin)
1939 - Bradman scores 267 SA v Vic, world record 34th double cricket century
1939 - O'Reilly takes 14-45 (8-23 & 6-22) as NSW crush Qld in 2 days
1940 - California's 1st freeway, (Arroyo Seco Parkway), opens
1941 - Al Capone's son Sonny marries in Miami Beach
1941 - Nazibezetters oblige artsen member to become of Artsenkamer
1941 - Nazis require Dutch physicians to join Nazi organization
1941 - Winston Churchill addresses Canadian parliament
1943 - Phillies trade Babe Dahlgren to Pitts for Babe Phelps & cash
1943 - Subhash Chandra Bose raises the flag of Indian independence at Port Blair.
1944 - King George II of Greece, abdicates his throne
1947 - 36th Davis Cup: USA beats Australia in New York (4-1)
1947 - King Michael of Romania, forced by communists abdicates his throne
1947 - Romanian republic proclaimed
1948 - "Kiss Me, Kate" opens at New Century Theater NYC for 1077 performances
1949 - India recognizes People's Republic of China
1950 - Vietnam, Laos & Cambodia become Independent states in France Union
1952 - Tuskegee Inst reports 1952 as 1st yr in 71 with no lynchings in US
1953 - The first ever NTSC color television sets go on sale for about USD at $1,175 each from RCA.
1954 - "House of Flowers" opens at Alvin Theater NYC for 165 performances
1954 - 1st use of 24-sec shot clock in pro basketball (Rochester vs Boston)
1954 - Harold Arlen/Truman Capotes musical premieres in NYC
1956 - NY Giants beat Chicago Bears 47-7 in NFL championship game
1957 - Israeli govt of Ben-Gurion, resigns
1957 - New York Giants win NFL championship
1958 - French franc devalued
1959 - George Washington, 1st ballistic missile sub commissioned
1961 - Moscow: premier of Dmitri Sjostakovitch' 4th Symphony (out 1936)
1962 - Green Bay Packers beat NY Giants 16-7 in NFL championship game
1963 - "Let's Make A Deal," debuts on NBC-TV
1963 - Congress authorizes Kennedy half dollar
1963 - Green Bay Packers win NFL championship
1964 - Edward Albee's "Tiny Alice," premieres in NYC
1965 - Ferdinand Marcos inaugurated as president of the Phillipines
1967 - Beatles' "Hello Goodbye," single goes #1 & stays #1 for 3 weeks

1967 - Great Western Forum opens in LA
1968 - -48°F (-44°C), Mazama & Winthrop, Washington (state record)
1969 - USSR performs nuclear test at Eastern Kazakh/Semipalitinsk USSR
1970 - Paul McCartney sues his bandmates to dissolve the Beatles
1971 - Long Island NHL franchise purchased (NY Islanders)
1971 - USSR performs nuclear test at Eastern Kazakh/Semipalitinsk USSR
1972 - Pres Nixon halts bombing of North Vietnam & announces peace talks
1973 - 1st picture of a comet from space (Comet Kohoutek-Skylab)
1973 - Miami Dolphins beat Oakland Raiders 27-10 in AFC championship game
1973 - Minn Vikings beat Dallas Cowboys 27-10 in NFC championship game
1974 - Beatles are legally disbanded (4 years after suit was brought)
1975 - "Boccaccio" closes at Edison Theater NYC after 7 performances
1975 - Constitution of Democratic Republic of Madagascar comes into force
1976 - USSR performs nuclear test at Eastern Kazakh/Semipalitinsk USSR
1977 - Carter holds 1st news conf by US pres in Eastern Europe (Warsaw)
1978 - "King & I" closes at Uris Theater NYC after 719 performances
1978 - Ohio State dismisses Woody Hayes as its football coach
1979 - Rock group, Emerson, Lake & Palmer break up
1979 - Togo adopts constitution
1980 - "Wonderful World of Disney," last performance on NBC-TV
1981 - Wayne Gretzky sets NHL record of 50 goals by 39th game of season
1982 - Anthony Shaffers "Whodunnit," premieres in NYC
1982 - England defeat Australia by three runs at cricket MCG
1982 - US Assay Office in New York City, NY closes
1984 - Miss Elizabeth (Hulette) & Macho Man Randy Savage (Poffo) wed
1985 - IBM-PC DOS Version 3.2 released
1985 - Pakistan restores constitution
1987 - Australia hang on for draw v NZ at MCG, 1 wkt left 17 runs short
1987 - Premier Mugabe elected president of Zimbabwe
1988 - Canadian Senate OK's free trade pact; with US
1988 - Former Soviet Pres Brezhnev's son-in-law sentenced to 12-yr (bribery)
1988 - Mercedes-Benz pays $20.2-M fine failed to meet '86 govt fuel standard
1988 - North subpoenas Reagan & Bush as defense witnesses for upcoming trial
1989 - 10th United Negro College Fund raises $12,000,000
1989 - Dmitri Volkov swims world record 50m freestyle (27.15 sec)
1990 - "Miser" closes at Circle in Sq Theater NYC after 93 performances
1990 - 11th United Negro College Fund raises $10,000,000
1992 - Last day of Test Cricket for Michael Whitney
1992 - Shane Warne takes 7-52 to lead Australian MCG win v West Indies
1993 - "Candles, Snow, & Mistletoe" closes at Palace NYC after 7 perfs
1993 - Singer Deni Hines (22) weds INXS guitarist Kirk Pengilly (35)
1993 - Vatican recognizes Israel
1995 - Carquest Bowl 6: North Carolina beats Arkansas, 20-10
1995 - The lowest ever United Kingdom temperature of -27.2°C was recorded at Altnaharra in the Scottish Highlands. This equalled the record set at Braemar, Aberdeenshire on February 11, 1895 and January 10, 1982.
1996 - Proposed budget cuts by Benjamin Netanyahu spark protests from 250,000 workers who shut down services across Israel.
1997 - An abandoned building collapses on NY's 42nd St, no one hurt
1997 - In the worst incident in Algeria's insurgency, the Wilaya of Relizane massacres, 400 people are killed from four villages.
2000 - Rizal Day Bombings: A series of bombs explode in various places in Metro Manila, Philippines within a span of a few hours, killing 22 and injuring about a hundred.
2003 - U.S. Attorney General John Ashcroft recuses himself and his office from the Plame affair.
2004 - A fire in the República Cromagnon nightclub in Buenos Aires, Argentina kills 194.
2005 - Tropical Storm Zeta forms in the open Atlantic Ocean, tying the record for the latest tropical cyclone ever to form in the North Atlantic basin.
2006 - Madrid Barajas International Airport is bombed.
2006 - Saddam Hussein is executed by hanging.