SQL server provides a good set of functions which will perform the required string operation. But, Many times we use T-SQL to do string operation.

Let us create a User Defined Function which will return all the special characters for the specified string.

--Select dbo.udf_RemoveSpecialChars('sarath#revuri##@gmail.com')
Create FUNCTION dbo.udf_RemoveSpecialChars
	(@strValue VARCHAR(1000))
	DECLARE @intAlpha INT
	SET @intAlpha = PatIndex('%[^A-Za-z0-9@._-]%',  @strValue)
	WHILE @intAlpha > 0
		SET @strValue = STUFF(@strValue, @intAlpha, 1, '' )
		SET @intAlpha = PatIndex('%[^A-Za-z0-9@._-]%',  @strValue )
RETURN ISNULL(@strValue,null)

User Rating: / 46

A wiki is a collaboratively-edited, information-centered website: the most famous is Wikipedia. ScrewTurn Wiki is free and open source which allows you to create, manage and share wikis.

ScrewTurn Wiki is based on Microsoft ASP.NET 3.5 and runs on Windows Server 2003 or Windows Server 2008. And it can be extended and customized with plugins and themes. It can store data using a simple, built-in file-system provider or, if you need performance and scalability, it can use SQL Server. If you use Active Directory, you can integrate with that too.

ScrewTurn Wiki is free and open source (GPLv2), meaning that you can use and modify it without limitations. In case GPLv2 is inadequate for your needs, we also offer commercial licenses.

User Rating: / 20

SharePoint is a collection of products and software tools by Microsoft that mainly provides collaboration functions, process management, searching and document management. This article i will try to present some of the new/enhanced features of the Share Point 2010

User Rating: / 20

Alexander Chigrik
This e-mail address is being protected from spambots. You need JavaScript enabled to view it

General Concepts

When you perform any data modification operations (INSERT, UPDATE, or DELETE statements) table fragmentation can occur. When changes are made to the data that affect the index, index fragmentation can occur and the information in the index can get scattered in the database. Fragmented data can cause SQL Server to perform unnecessary data reads, so a queries performance against a heavy fragmented table can be very poor. If you want to determine the level of fragmentation, you can use the DBCC SHOWCONTIG statement. The DBCC SHOWCONTIG statement displays fragmentation information for the data and indexes of the specified table or view.

User Rating: / 21

In this article I am presenting you the simple steps any site can take when they are about to launch on the internet and to help them get off on the right foot for the most basic of search optimization steps. 

The simple rules can launch your website off on the right foot.  Keep in mind that these are just simple steps, there's a lot more that goes into optimization of a website.  This list is just meant as a guide to start you off, and these should assist you in your efforts until you have a full search marketing strategy mapped out for your website.

<< Start < Prev 1 2 3 4 Next > End >>
Page 1 of 4