Web design and hosting, database, cloud and social media solutions that deliver business results
  • Business Solutions
    • Robotic Process Automation
    • Software
    • Database Consultancy Services
      • Data Integration
      • Datawarehouse Services
      • Power BI
      • Server Upgrade and DBA Services
    • Web Site Design 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 Office
    • Social Media Management and Advice 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
      • 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 Us
    • 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-Portuguese
      • Translator English-Spanish
    • Portfolio
    • Team
      • Adrian Anandan
      • Ali Al Amine
      • Ayse Hur
      • Chester Copperpot
      • Deepika Bandaru
      • Gavin Clayton
      • Sai Gangu
      • Suneel Kumar
      • Surya Mukkamala
AR - عربىCS - češtinaDE - DeutschEN-GB - EnglishEN-US - EnglishES - EspañolFA - فارسیFR - FrançaisHI - हिंदीIT - italianoJA - 日本語PL - polskiPT - PortuguêsRU - русскийTR - TürkZH - 中国的

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

Building a basic CMS in SQL Server and NET

Building a basic CMS in SQL Server and NET
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)

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

SSIS, Create a Dynamic Excel file with dynamic Sheet Names

SSIS, Create a Dynamic Excel file with dynamic Sheet Names
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

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

Check CUSIP format with an SQL Function

Check CUSIP format with an SQL Function
Create a function to check the CUSIP format in SQL Server

Effective Database Indexing

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

Check ISIN format with an SQL Function

Check ISIN format with an SQL Function
Create a function to Check the ISIN format in SQL Server

Check SEDOL format with an SQL Function

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

Updating, inserting and deleting from large data sets with minimal locking

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

Substring vs Replace vs Stuff in SQL Server

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

SQL WHERE clauses with date intervals - which way is best?

SQL WHERE clauses with date intervals - which way is best?
Examining the way dates are handled within SQL server WHERE clauses, and how best to use them
Copyright Claytabase Ltd 2022

Registered in England and Wales 08985867

RSS Login Contact-UsCookie PolicySitemap

Social Media

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

Get in Touch

+442392064871info@claytabase.com501 Congress Avenue, Suite 150, Austin, Texas, USA, 78701
https://www.claytabase.co.uk/System/Themes/Default/Partners.png
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
Ousia CMS Loader