Web design and hosting, database, cloud and social media solutions that deliver business results
  • Business Solutions
    • Robotic Process Automation
    • Bespoke Software
    • Database Services
      • Data Integration
      • Datawarehouse Services
      • Power BI
      • Server Upgrade and DBA Services
    • Web Services
      • Logo Design
      • Payment Gateways
      • Web Localisation and Translation
      • Web Site Optimisation
      • Web Site Security
      • Technical Tools
    • Cloud Services
      • Amazon Web Services
      • Google Cloud Services
      • Microsoft Azure
    • Microsoft 365
      • Enabling the Multi Factor Authentication Application
      • Office 365 DNS Settings Generator
    • IT Hardware
    • Social Media Services
  • Academy
    • Our Test Environment
    • Learning Databases
      • The Basics
      • Get Open Query
      • SQL Server Data
      • SQL Server Maintenance
      • Using SQL Server Dates
      • Using SQL Server Functions
      • Using SQL Server Pivot-Unpivot
      • Technical Tools
    • Learning Web Design
      • Building Ousia Content Management System
      • Using ASP-NET
      • Using CSS
      • Using JavaScript
    • Learning Cloud and IT Services
      • Task Scheduler Error 2147943645
      • Blocking Blank Senders
      • Requesting SSL and Generation of PFX file in OpenSSL Simple Steps
    • Using Social Media
      • Asking for a Google Review
      • Changing a Facebook account from personal to business
      • Choosing where to focus Social Media effort
      • Social Media Image Sizes
      • Using Meta Data to set Social Media Images
  • About
    • Blog
      • Building an entry level gaming machine
      • Google Core Update Jan 2020
      • Hot Chilli Internet Closure
      • How To Choose Content For Your Website Adverts Leaflets
      • Preventing Online Scam
      • Skimmers of the gig economy
      • The most annoying things about websites on the Internet
      • Top 5 websites for free Vector Graphics
    • Careers
      • Translator English-Japanese
      • Translator English-Portuguese
      • Translator English-Spanish
      • Translator English-Turkish
    • Portfolio
    • Regulatory
    • Team
      • Chester Copperpot
      • Gavin Clayton
      • Sai Gangu
      • Suneel Kumar
      • Surya Mukkamala
عربى (AR)čeština (CS)Deutsch (DE)English (EN-US)English (EN-GB)Español (ES)فارسی (FA)Français (FR)हिंदी (HI)italiano (IT)日本語 (JA)polski (PL)Português (PT)русский (RU)Türk (TR)中国的 (ZH)

Using SQL Server data effectively

Using SQL Server data effectively can save both man and processing hours. Here are some of our best data processing and cleansing articles

Data Importance

Using SQL Server Data

Focusing on how your data is processed, cleaned and stored has never been more important.

Putting in a clear plan to store your data efficiently can be one of the easiest ways to give your business an advantage over your competitors.

As more and more companies move towards becoming "data companies", we share some of our best functions and data processing techniques.

All Documents

Build a basic Content Management System

How to build a Content Management System with an SQL Server database and ASP.NET web forms application. This is from the very first version of Ousia.

Count vs Count Column

Exploring the differences between COUNT(*) vs COUNT(column) in SQL Server and which one to use in day to day use

Create a Dynamic Excel File with Dynamic Sheet Names SSIS

Create a Dynamic Excel File with Dynamic Sheet Names in SSIS. I found this one of the easiest ways to dynamically create an excel file with dynamic sheet names.

CSS Pre Processor in SQL

Build an SQL Server function to minimise CSS. It can condense your CSS by over 20%, or use our free tool

CUSIP Check Correct Format Function in SQL

Create a function to check the CUSIP format in SQL Server

Effective Database Indexing

Effective Database Indexing in a normalised database will have more performance impact than simply throwing additional resources at the system

ISIN Check Correct Format Function in SQL

Create a function to Check the ISIN format in SQL Server

SEDOL Check Correct Format Function in SQL

Create a function to Check the SEDOL number format in SQL Server

SQL Server Updating Inserting And Deleting From Large Datasets

Using SQL Server to update, insert and delete from a large data set with minimal locking by using loops

Substring vs Replace vs Stuff

Working with text strings and comparing the use of SUBSTRING, REPLACE and STUFF, alongside some other string functions in SQL Server

Where Clause with Intervals

Examining the way dates are handled within SQL server WHERE clauses, and how best to use them
Copyright Claytabase Ltd 2020

Registered in England and Wales 08985867

Site Links

RSSLoginLink Cookie PolicySitemap

Social Media

facebook.com/Claytabaseinstagram.com/claytabase/twitter.com/Claytabaselinkedin.com/company/claytabase-ltd

Get in Touch

+442392064871info@claytabase.co.ukClaytabase Ltd, Unit 3d, Rink Road Industrial Estate, PO33 2LT, United Kingdom

Partnered With

The settings on this site are set to allow all cookies. These can be changed on our Cookie Policy & Settings page.
By continuing to use this site you agree to the use of cookies.
Ousia Logo
Logout
Ousia CMS Loader