Website: Get noticed in google search engine

Check out: http://www.vodahost.com/vodatalk/google/11694-google-search-does-not-show-my-page.html


Step 1: check can be viewed in googlebot by using Lynx viewer
http://www.yellowpipe.com/yis/tools/lynx/lynx_viewer.php

Step 2: look at google's webmaster guidelines:
http://www.google.com/support/webmasters/bin/answer.py?answer=35769

Step 3: Give your page title something like "Microsoft Business Intelligence Consultant John Ilett"
Right-click on your BV page (away from any element or object), and you will see Page Properties > Click > Page Properties Dialog Box...

Step 4: General tips
It needn't be so, however, and at VodaHost, we believe you will find no easier means to apply this technical expertise to your website designs as an effective element to your online success with the tools, technologies, and peer support so freely available!You need to "search" the various Forums here in VodaTalk to read up on various means to "optimize" you design to be 'friendly' to the Search Engines, as there are foundational methods and forms you need to consider.You can start in the "Search Engine Topics & VodaHits" Forum, and move to others like "General Support" where you can actually perform a "Search Forum" based on key words to bring up relevant topics as you glean information. (To "Search Forum" you will find this available in the blue header of the VodaHost "VodaTalk Forum" itself)Also, don't neglect the "KeyWord Digger" Tutorial already prepared for your use by VodaHost, which can visually tie together some of the new terms and principles for you whilst offering specific instructions on how to complete the task itself!To begin, actually right-click on a blank area of your page in Blue Voda, and then select PAGE PROPERTIES....tabbed, you will now see some of the various information you should carefully construct that is extremely important to how your Page is actually "recognized" and "cached" by the no-nonsense Search Engines....now you can understand the relevance of the mentioned principles, and have the means to investigate and learn them yourself!**When you have neared completion of your website, you should consider enrolling in the extremely affordable and very effective VodaHits SEO program. There is no better value for this critical service on the web!


More...
Search 1: andysbodyseBay Member Profile for andysbodysMember Profile : andysbodys ( 519 ) ... 627 feedback received by andysbodys ( 0 ratings mutually withdrawn ), Page 1 of 26 ...feedback.ebay.com/ws/eBayISAPI.dll?ViewFeedback&userid=andysbodys - 79k - Supplemental Result - Cached - Similar pagesSearch 2: andysbodiesDid you mean: andy's bodies Andy's Auto Sport - Body Kits and Carbon Fiber Hoods Superstore!You really need to see you are putting a space where it should never go.You have saved your pages as : http://andysbodies.net/You left out the www. part, first of all.....AND1. Your CONTACT US link lists the link "andys bodys.net/contact" See the space?? Use an underscore, if you need to between page titles, but you do NOT have a space in your registered domain, do you? > Nor should you anywhere else!2. You have not named/titled your pages, so there is no association for them to "Go" or even be "Found"

SQL: Performance tuning guide

http://www.sql-server-performance.com/tips/all_main.aspx

1. Query optimisation can be achieved using the Query optimiser on most common queries. Will determine best indexes to build.

INDEXES
2. ALL table should have a CLUSTERED INDEX - this is an index on PK which is increasining (only 1 per table).
3. Index should be considered on any column in WHERE, ORDER BY, GROUP BY, TOP and DISTINCT experssions. (may be optmial for one query but not for other).
4. Setting different settings on index can affect performance. Clustered, non clustered, and composite indexes as well as setting FILLFACTOR and PAD_INDEX.
5. Static tables (dont change frequently) set FILL and Pad_index to 100 and can be heavily indexed as update/insert/delete not a problem.
6. Drop indexes not used by the Query optimiser.

INDEXED VIEWS
1. Create indexed view. Must set up the following:
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
SET CONCAT_NULL_YIELDS_NULL ON
SET NUMERIC_ROUNDABORT OFF
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
2.
CREATE VIEW Vdiscount1 WITH SCHEMABINDING AS
SELECT SUM(UnitPrice*OrderQty) AS SumPrice, SUM(UnitPrice*OrderQty*(1.00-UnitPriceDiscount)) AS SumDiscountPrice, COUNT_BIG(*) AS Count, ProductIDFROM Sales.SalesOrderDetail GROUP BY ProductID
GO
CREATE UNIQUE CLUSTERED INDEX VDiscountInd ON Vdiscount1 (ProductID,colb,..)

3. When to use indexed view:
Data marts, data warehouses, decision support, data mining, OLAP applications.
Views that join two or more large tables.
Views that aggregate data.
Repeated patterns of queries.

Triggers
1. 2 triggers(Instead and After).
If likely only a few rolebacks then use instead otherwise after as overhead is less.
2. When ordering first trigger set it to the most likely rollback trigger so doesn't have to rollback all triggers throughout.
3. Run Query anaylizer to see performance of trigger on system.

Check Constraint
1. Faster than trigger for referential integrity

Use SP for client calls
1. As SP reduce network traffic because SQL in SP and not over network.
2. More secure
3. Better logic.

**Turn off nocount
1. Everytime SP is run returns rowcount to client. This is rarely useful
2. Switch off either putting this is each sp:
SET NOCOUNT ON
or switch off:
SP_CONFIGURE 'user options', 512RECONFIGURE

Check running latest version:
SELECT @@Version

Database tuning Advisor
1. Run profiler to pick up all current queries. (SQL:BatchCompleted and the RPC:Completed)
2. Then save trace and point DB tuning advisor to it.

SSRS 2008: Column Header remain visible

Need to create a second group on dynamic group the same.
1. Then go to Report > Grouping.
2. In the groups (bottom of report) select the arrow in the top right hand corner and select advanced mode.
3. Click the top group and go to properties.
4. Set the FixedData to true.
5. Set Row Visibility of group below to hiden.

You're done!