Sql Server Consultant USA | Sql Server Consultants USA

Dec 26/2011

Remove Duplicate Records in SQL

In MS SQL 2005 and later editions, a much better way has been provided to remove duplicate records smartly, while having full control of which records to remove. It can be accomplished by using the ROW_NUMBER() which will return a number of row within a partition of a result set.

Aug 22/2011

ERP Software Selection

You are an owner of a small or medium size company, and you need to select ERP software to run your business. You are confused between the large availability of ERP software packages. How do you select the right one for your business, and how do you find one you can afford?

Jul 26/2011

Data compression in large tables in MS SQL server

Do you know that you can compress data while using MS SQL 2008 or any later version? Compression is available for now in SQL Server 2008 or 2012 Enterprise and Developer edition.

Jul 20/2011

Benefits of ERP Software for Small or Medium Size Businesses

If you are a typical stakeholder of a small or medium size business, you probably prefer to invest in assets that contribute directly to the growth and revenue of your business (for example, tools for making your product, machines to expand capacity, people to design and sell your product, etc.). You know that information technology and business software is important, but you...

May 16/2011

Secure MS SQL server when running web application

When people need to connect publically, those individuals are taking the risk of outside attacks on your server. A year and half ago I noticed that 2 hackers are trying to get into my MS SQL 2008 server via the SA account.

Mar 28/2011

String Manipulation on large data using LIKE operator or PATINDEX

The idea is to perform data cleansing on the Date and Time field from different formats into a unify format such as: YYYYMMDD. Here is a sample data to be used for the data cleansing that I will perform below...

Remove Duplicate Records in SQL

ERP Software Selection

Data compression in large tables in MS SQL server

Benefits of ERP Software for Small or Medium Size Businesses

Secure MS SQL server when running web application

String Manipulation on large data using LIKE operator or PATINDEX

Categories

Recent Posts

Popular Tags