Indexes

We looked at how the Dow Jones Industrial Average is not a great gauge of the US stock market here. While we saw that the S&P 500 is a much better gauge of the markets, it's not a great index against which to compare our ability to select stocks, particularly for those of us who invest in small stocks. The Russell family of indexes offers us a solution.The Russell 3000E index contains the larg

World stocks plunged by US market, global recession woes, gloomy economy outlook and fears of lower corporate earnings caused the stock markets to fall. Just when one think a new bottom has been... [[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Asia markets were very sharply lower. The Nikkei was off 9.6% to 8,276. The Hang Seng was down 7.3% to 14,694. The Shanghai Composite dropped 3.5% to 2,001.... [[ This is a content summary only. Visit my website for full links, other content, and more! ]]

For tuning SQL statements often requires the testing of alternate indexing strategies to see the affect on execution plans. Adding extra indexes to large tables can take a considerable amount of time and disk space. The additional indexes are available for use by other sessions, which may affect the performance of other parts of your application that you are not currently testing. This can be prob

Indexes are described as a copy of a database table reduced to specific fields. This data exists in sorted form. This sorting form ease fast access to the field of the tables. In order that other fields are also read, a pointer to the associated record of the actual table are included in the index. The indexes are activated along with the table and are created automatically with it in the database

Japan economy posted negative growth -0.6%. After Canada and Italy it is the third economy in G7 group which is not in expansion. Tomorrow the GDP statistics are released for countries of Euro zone.Last days China is in focus. Unexpectedly high inflation and slowing economic growth dragged Shanghai Composite index 55% from October high. Another hot stock markets in Viet nam lost all the attractive

In this article we’ll review two PDF file scenarios and how search engines such as Google, Yahoo and MSN index them. If you’re reading this, then you’re most likely concerned about SEO and how your site ranks. Before you reach out to a search engine optimization agency read about a few basic SEO tips to [...]

When I was a Windows user (seems so long ago now), I relied heavily on Google Desktop Search to search across my Sametime chat transcripts, Notes mail, Notes replicated databases, and other documents on my local computer. When I migrated to Mac, I quickly discovered Spotlight, but it couldn't index my Lotus Notes databases . That all changed today! I discovered in an internal forum that the latest

Five days ago the Associated Press (among others) reported that Google will begin indexing Flash content on a text level. For those of us who work with Flash and SEO on a daily basis the news came as a pleasant surprise. Let's examine the key points of the announcement:1) Flash content (.swf files) will be indexed according to text rendered within the movie or application. This includes hyperlin

It’s time to broaden our perspective and view the major market indexes from countries around the world.  How have they performed since the October 2007 US Stock Market Peak?  Let’s review the percentage comparison for insights. Since the October preak, only Brazil ($BVSP) has held its own, and has now turned negative from the peak after [...]

Updated commentary on trends in each of the top zipcodes in North Atlanta. These charts represent an index that combines the prices, inventory and days on market to arrive at an index number. Higher than 30 and it is a “seller’s market” lower than 30 and it is a “buyer’s market”. While the indexes confirm that [...]

OK, so before all you Flash-crazed developers get too excited, what Google specifically will index is two things: 1. The text content in .SWF files. 2. URLs can now be followed. This means that Flash websites can indeed be made SEO-friendly, although I am uncertain how much Flash designers would want text content in their files [...]

Bien Viet Securities Joint Stock Co (CBV) recently released two new indexes namely combined index for bonds and shares (CBV Vietnam Equity/Fixed Income Composite Index) and strategic index. Earlier, the company launched a series of other indexes like CBV-Total, CBV-LargeCap, CBV MidCap and CBV-SmallCap that have been... [[ This is a content summary only. Visit my website for full links, other co

After Managing Indexes Part #2 Creating an Index Associated with a Constraint Oracle Database enforces a UNIQUE key or PRIMARY KEY integrity constraint on a table by creating a unique index on the unique key or primary key. This index is automatically created by the database when the constraint is enabled. No action is required by you when you issue the CREATE TABLE or ALTER TABLE statement to

After Managing Indexes Part #2Creating an Index Associated with a ConstraintOracle Database enforces a UNIQUE key or PRIMARY KEY integrity constraint on a table by creating a unique index on the unique key or primary key. This index is automatically created by the database when the constraint is enabled. No action is required by you when you issue the CREATE TABLE or ALTER TABLE statement to creat

Continued after Managing Indexes Part #1 Order Index Columns for Performance The order of columns in the CREATE INDEX statement can affect query performance. In general, specify the most frequently used columns first. If you create a single index across columns to speed up queries that access, for example, col1, col2, and col3; then queries that access just col1, or that access just col1 and

Continued after Managing Indexes Part #1Order Index Columns for PerformanceThe order of columns in the CREATE INDEX statement can affect query performance. In general, specify the most frequently used columns first. If you create a single index across columns to speed up queries that access, for example, col1, col2, and col3; then queries that access just col1, or that access just col1 and col2,

Indexes are optional structures associated with tables and clusters that allow SQL statements to execute more quickly against a table. An Oracle Database index provides a faster access path to table data. You can use indexes without rewriting any queries. Your results are the same, but the execution time increase. Oracle Database provides several indexing schemes that provide complementary

Indexes are optional structures associated with tables and clusters that allow SQL statements to execute more quickly against a table. An Oracle Database index provides a faster access path to table data. You can use indexes without rewriting any queries. Your results are the same, but the execution time increase.Oracle Database provides several indexing schemes that provide complementary performa

Today marked a day of relative indecision for the US Stock Market.  The Dow & S&P are trapped just beneath their 200 day moving average, and formed a strange doji pattern at this level, while the VIX reached new lows for the year. Let’s look at these developments: S&P 500: The NASDAQ actually closed higher than its 200 [...]

The US Markets remain trapped beneath their 200 day moving average but above their rising 20 period average. A breakout is likely, but in which direction will it occur? Let’s look at the SPY (S&P 500 ETF): The 200 period average is declining while the 20 is rising, and price is in a strong uptrending channel line. [...]

Are the Indexes at Support or Resistance?  Today’s action would lend to the “Resistance” camp, but let’s take a closer look. Let’s start with the daily chart of the Dow Jones Index: With this chart, I have Resistance plotted via two areas: 1.  The declining 200 day moving average 2.  The horizontal trendline via prior support/resistance I have Support plotted [...]

Last week’s price action (particularly that of Friday) sent the major US Indexes to test key resistance, a break of which would change the calculus and give more strength to the bulls. 1,400 on the S&P 500 Index proves to be yet another powerful force that price is testing. Should price cleanly break this zone, [...]

Before you post that image or PDF, make sure it’s what you intended. In this article we’ll review two PDF file scenarios and how search engines such as Google, Yahoo and MSN index them. More: continued here

The major U.S. stock indexes all dropped over 2 percent last week after General Electric reported much lower then expected numbers. This was the steepest decline for the indexes in over 5 weeks. The S&P 500 index dropped 2.7 percent, while the Dow Jones Industrial Average declined 2.3 percent for the week.

Today, there are a number of blog indexes available to help you gain a better ranking for your site. These include sites that will search the web looking for blog updates, as well as ones that will... [[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Today, there are a number of blog indexes available to help you gain a better ranking for your site. These include sites that will search the web looking for blog updates, as well as ones that will... [[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Stock indexes saw modest increases at the March 27 trading session, the first day when the stock trading bands reduce to 1% and 2%, respectively, in Ho Chi Minh City and Hanoi. Ending the trading session today March 27, the Ho Chi Minh City Stock Exchange (HOSE) kept increasing impetus on the stock market when the VN... [[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Whar is an index? What are the types of indexes? How many clusteredindexes can be created on a table? I create a separate index on eachcolumn of a table. what are the advantages and disadvantages of thisapproach? Ans: Indexes in SQL Server are similar to the indexes in books. They helpSQL Server retrieve the data quicker. Indexes are of two types. Clustered indexes and non-clustered indexes.When you craete a clustered index on a table, all the rows in thetable are stored in the order of the clustered index key. So, therecan be only one clustered index per table. Non-clustered indexes havetheir own storage separate from the table data storage. Non-clusteredindexes are stored as B-tree structures (so do clustered indexes),with the leaf level nodes having the index key and it's row locater.

Just a day ago, I received email from regular reader Rajiv Kayasthy about a script which demonstrates the A Simple Way To Defragment All Indexes In A Database That Is Fragmented Above A Declared Threshold. He found this script on TechNet BOL and was attempting to run on SQL Server but was getting continuous error Msg [...]

In the end, maybe it's best to toss a few outside links into a piece to make sure. Also, all the other usual SEO tips are liable to help, as well. But it seems like no special actions are necessary (and no anxiety is in order) when trying to get a new blog indexed by Google.

It's been quite a week in the markets. We witnessed the first bear rally since the stock markets officially entered into the Bear territory not so long ago. All major indexes finished te week with positive weekly performance figures. Of course, the major factor behind these moves has a two-part series of interest rate cuts by the Fed, with latest 50 bps cut announced during the regular meeting

While playing with Indexes I have found following interesting fact. I did some necessary tests to verify that it is true. When a clustered index is disabled, all the nonclustered indexes on the same tables are auto disabled as well. User do not need to disable non-clustered index separately. However, when clustered index is enabled, it does not automatically enable nonclustered index. All the nonclustered indexes needs to be enabled individually. I wondered if there is any short cut to enable all the indexes together. Index rebuilding came to my mind instantly. I ran T-SQL command of rebuilding all the indexes and it enabled all the indexes on table. This was very intriguing to me, as I never faced this kind of situation before. Everyday there is something new in SQL Server and that what makes life of DBA refreshing. T-SQL to rebuild all the indexes on table. USE AdventureWorks; GO ALTER INDEX ALL ON Production.Product REBUILD GO Rebuild All Indexes using SQL Server Management Studio.

Physical Database Design: the database professional’s pass to exploiting indexes, views, storage, and more (The moneyman Kaufmann Series in Data Management … Kaufmann Series in Data Management Systems) (Paperback)By Sam S. Lightstone Buy new: $45.4030 utilised and new from $39.00 Customer Rating: First tagged “database” by Sam S Lightstone Customer tags: database, data model, relational, sql, database administration, database programming, data modeling (more…) Technorati Tags: database, data model, relational, sql, database administration, database programming, data modeling

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

While the report is considered less important than the Labor Department’s measure of job growth, which will be released tomorrow, the strong number took many in the market by surprise. “That came out of left field, huh?” said Joshua Shapiro, chief United States economist at the research firm MFR. Economists had expected a gain of about 70,000 jobs for November. “It’s not a dead lock that we’re going to get a good payroll number, but it certainly caused me to raise my estimates.” The government’s report on November employment will be the last piece of important data before the Fed meets on Tuesday, when policy makers are expected to cut interest rates by at least a quarter-point. Fed officials have hinted that they are open to lowering rates to help avert a recession, but a sign of underlying strength — like a big gain in jobs — could persuade them to take a less aggressive stance. “The economy might prove more resilient than a lot of the doomsayers have been sayin

The Berkeley’s School of Information Management Systems calculated how much unique information was produced in 1999 and again in 2002 (measuring the volume of unique data created in the world each year saved to film, disk, optical, and paper). The 1999 study estimated that about 3,000,000 TB of unique information were produced that year. The later study estimated that about 5,609,121 TB was produced in 2002. Assuming the same growth rate to present, about 11,278,629 TB of new information were produced in 2006. In November of 2006, Google released a paper which mentioned that Google’s web index at the time was 800 TB and Bigtable as a whole was approx ~1085 TB. Volume of Information predicted in 2006  : 11,000,000 + TB Volume of Information indexed by Google : 1,000+ TB % of Information of the world indexed by Google ~ 0.02 % [ Via KnowledgeBid ] Share This

7 th November, 2007, find the Stock market review in this video:

By Marie-Hélène Wagner

Via ZDNet. Geospatial startup earthmine gave a preview of its immersive 3D panorama technology at DEMOfall 07. According to their web site: “earthmine is creating a new kind of map, a pre-collected, geospatially accurate data set of the world that is accessed through an intuitive panoramic interface. This new map is accessed from the human perspective, making it instantly understandable by anyone that has ever walked around in our world. But earthmine is much more than pretty pictures. Behind every pixel in each high quality image you’ll find highly accurate latitude, longitude and elevation, immediately adding three-dimensional context to existing spatial data, and providing a whole new model for data collection.” Using a set of calibrated cameras, earthmine vehicles collect data at the street level. Although Google Street View, MapJack, et al, also collect data at street level, earthmine collects 3D panorama data that is more complex and which can be integrated w

The Top Ten Art Price Indexes and Databases The recent increase in popularity of art investment has given rise to many different art price indexes and databases which are a fantastic resource for art investors and collectors who are looking to gauge value, determine popularity and attempt to predict art market movements and price progression. Below is a list of the top ten art price indexes and databases which should be able to provide you with the information you need to make informed decisions. http://www.artprice.com The artprice database includes over 290,000 catalogues with images on line, 25 million auction results, prive levels and indices covering 405,000 artists. Also included are upcoming sales from 2,900 auction houses, signatures and biographies of artists and artwork estimates. http://www.artfact.com Artfact is the world’s largest and most comprehensive fine auction database service including unabridged upcoming and past auction catalogs and price results for over 1

I do read other blogs and sites and I came across something very interesting, so I thought I would share with my readers. Here is a Great Post on Determining When Google Indexes Your Site! I could have taken the story and rewrote if for my readers but it’s too simple and i’m not one to steal content! However I honestly think you can just use Google Alerts to “Alert” you when your site gets in the index, just my 2 cents however now you know about 2 ways of doing the same thing! So, there you have it … a great trick for your new sites or even your current ones! Darin Share

Energy stocks move broadly higher Energy stocks... [[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Energy stocks move broadly higher Energy stocks took their cue from the overall market's Wednesday rally as indexes tracking the oil and gas sectors showed strength and crude-oil futures traded at a one-year high. Marathon Oil (MRO :55.20, -1.80, -3.2% ) was conspicuous by its weakness in the wake of an acquisition valued at more than $6 billion as well as the company's second-quarter financial results. Overall, the Amex Natural Gas Index (XNG :489.33, -2.67, -0.5% ) set the pace, adding 2% to 501.66 amid bets that a wave of summer heat from Chicago to New York, plus a couple of possible hurricanes in the works in the Caribbean, could stoke demand. The Philadelphia Oil Service Index ($OSX :271.30, -1.53, -0.6% ) rose 1.7% to $277.43, amid fresh expectations for more consolidation in the sector. The Amex Oil Index (XOI : 1,362.51, -14.97, -1.1

Energy stocks move broadly higher Energy stocks took their cue from the overall market's Wednesday rally as indexes tracking the oil and gas sectors showed strength and crude-oil futures traded at a one-year high. Marathon Oil (MRO :55.20, -1.80, -3.2% ) was conspicuous by its weakness in the wake of an acquisition valued at more than $6 billion as well as the company's second-quarter financial results. Overall, the Amex Natural Gas Index (XNG :489.33, -2.67, -0.5% ) set the pace, adding 2% to 501.66 amid bets that a wave of summer heat from Chicago to New York, plus a couple of possible hurricanes in the works in the Caribbean, could stoke demand. The Philadelphia Oil Service Index ($OSX :271.30, -1.53, -0.6% ) rose 1.7% to $277.43, amid fresh expectations for more consolidation in the sector. The Amex Oil Index (XOI : 1,362.51, -14.97, -1.1

This is true, a wake up call for all those who are earning by selling or buying links. This all those participating in Advertising Programs like Text-Link-Ads. This is an effort to stop buying Google Pagerank which is mainly based on incoming external links. The paid links reporting form is directly available in the dashboard of Google SitemapsHow will Google punish?A complete exclusion from Google´s SERPs is only one possible consequence of a spam report. Google might also choose to give a site a "yellow card" so that the site can not be found in the index for a short time. However, if a webmaster ignores this signal, then a "red card" with a longer-lasting effect might follow. So it's possible that Google is already aware of an issue and communicating with the webmaster about that issue, or that they have taken action other than a removal on a spam report.Are you the first to be punished?You can still send your Application for reconsiderationBut you can still sell links by-Adding

Whist using the Domain Popularity Checker Tool that I wrote about several weeks ago, I’ve noticed that all of the number of pages that I have indexed within the search engines has steadily increased (as new content is added) with the exception of one search engine, the big daddy, Google. If you compare the number of pages indexed figures below, obtained from the tool, for the dates of 26th April and today 21st May you can see that all of the search engines show an increase with the exception of Google:- 21st May 2007 Google - Pages = 1370 Links = 72 Yahoo - Pages = 1073 Links = 301 MSN - 77 Links = 0 Altavista - Pages = 1080 Links = 197 Excite - Pages = 19 Links = 7 AlltheWeb - Pages = 217 Links = 167 Alexa Rank = 310, 658 PR = 1 26th April 2007 Google - Pages = 2000 Links = 53 Yahoo - Pages = 1028 Links = 285 MSN - 71 Links = 0 Altavista - Pages = 1040 Links = 316 Excite - Pages = 0 Links = 0 AlltheWeb - Pages = 195 Links = 274 Alexa Rank = 286,923 PR = 0 My assumption is that G

Stocks were little changed after the open on Wednesday as investors awaited the release of minutes from the Federal Reserve's recent policy-setting meeting, which may shed light on the direction of...

The price changes in a market or a part of a market are shown in price indices called stock market indices. Such indices are mainly market capitalization (total market value of capital of a company) weighted, the weights reflect the contribution of the stock to it's particular index. The elements that make up the index are reviewed often to include and exclude stocks in order to reflect the ever changing business environment.The definition of a stock index is a statistical average of a particular stock exchange. An index is basically a group of stocks that have something in common. Perhaps they are all part of the same industry or they represent companies of a certain size or geographic location.1. Major Stock Indexes- Dow Jones Industrial Average- NYSE Composite index- S&P 500 Composite Stock Price Index2. Calculating IndexesA price weighted index is solely based on the price of the stock. It doesn't take into consideration the size of the company. An index that is market value weig

Charles Patridge Sr. Data Engineer Full Capture Solutions, Inc Michael has written an excellent learning and reference manual about SAS® indexes which is well thought out and presented aptly. Marje Fecht Partner Prowerk Consulting Michael Raithel effectively demonstrates how to create indexes; more importantly, he explains when to use (and not use) indexes DOWNLOAD

Eric Enge, Recently we had the chance to speak with Tim Mayer about Yahoo's Search Builder product. Search Builder is the vertical search engine offering from Yahoo, that competes with products such... [[ This is a content summary only. Visit my website for full links, other content, and more! ]]