Adding Indexes to SQL Server 2005 Tables I had the opportunity this week to tune a SQL Server 2005 database to improve the performance of a web application. I first created indexes on the temporary tables within a stored procedure that was causing much of the delay and later discovered through the execution plan, there was specific bottle-neck that could be cleared. Here is an illustration of the temp table indexing:

IF OBJECT_ID('#TempTable') IS NOT NULL CREATE NONCLUSTERED INDEX [#idxTemp_TempTable_Field1_Field2] ON #TempTable ( [Field1] ASC, [Field2] ASC, )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = ON, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = OFF, ALLOW_PAGE_LOCKS = OFF) ON [PRIMARY] .csharpcode, .csharpcode pre { font-size: small; color: black; font-family: consolas, "Courier New", courier, monospace; background-color: #ffffff; /*white-space: pre;*/ } .csharpcode pre { margin: 0em; } .csharpcode...

Quite Possibly the Best Backlink Finder After working with a number of Backlink Finders including several I have mentioned on CapturedTech previously, I have really grown to love LinkDiagnosis.com. It is not the 100% solution without imperfections but it provides information about Backlinks that I have not seen in other free and paid services.

Google Backlinks Getting ranked in Google is still about having backlinks from relevant sites without nofollow rel tags for relevant keywords. Page rank and the number of outgoing links on the linked page are also very important. LinkDiagnosis.com combines all these factors into a Link Quality score which you can then sort report results by. Search someone else’s site backlinks and discover why they are ranked so high in Google and then duplicate their backlinks as much as possible.

One of the interesting facts about the Quality Link Score are that the nofollow tag isnt’ the end all to a quality link like many write. Numerous sites with good...

The Importance of the Landing Page for SEO The Landing Page is a single page website where a visitor comes after clicking on your PPC ad or natural search engine link. The main objective of the page is to introduce the guest to your product or service. A prospect maybe in search of a service that has the ability to resolve his or her problem, and your lead capture page helps them to find this product easily.

The different gears of the landing page serve to educate the prospect, instill confidence in your service or product, and motivate them to make a purchase. For instance, the headline of the page not only grabs the awareness of the visitor, but also gives them a reasonable idea whether he has reached the right place or a site that does not contain what they are looking for. Likewise, the contents of the page enlist the significant features of the product as well as its benefits. This helps the prospect evaluate the goodness of the product, and...

Another Great SQL Server Grep Function The first SQL Server Grep function I posted is one of the most popular items on the site to today therefore I thought I would share another great version of the MS SQL string search function you can use to search for terms within your database. This version uses a temporary table to store the results from a cursor and then displays the results to the output screen before dropping the temporary table.

create procedure searchforstring @searchstring varchar(100) as begin declare @SQLString as varchar(1000) declare @TableName as varchar(255) declare @ColumnName as varchar(255) declare @Count as int DECLARE C_SOURCE CURSOR FOR select sysobjects.name tablename,syscolumns.name columnname,'select top 1 * from [' + sysobjects.name + '] where ' + syscolumns.name +' like ''%' + @searchstring + '%'' ' SQL_String from syscolumns , sysobjects, systypes where sysobjects.xtype='U' and sysobjects.id = syscolumns.id and systypes.xtype=syscolumns.xtype and systypes.name...