Kenneth Igiri

Kenneth Igiri is an Enterprise Architect with eProcess International S.A., Ecobank Group's Shared Services Centre. Kenneth has over nine years' experience with SQL Server and Oracle databases as well as related technologies. His interests include database performance, HADR, Cloud and recently Enterprise Architecture. Asides from work, Kenneth teaches at Children's Church, writes faith-based fiction and helps small business grow. You can connect with Kenneth via his blog https://kennethigiri.com, LinkedIn or on Amazon.com.
  • Interests: Creative Writing

The IDENTITY Column Property

There are a number of ways to generate key values in SQL Server tables including the IDENTITY column property, the NEWID() function and more recently, SEQUENCES. The IDENTITY column property is the earliest of these methods. It was introduced very early in the history of SQL Server and it is arguably the simplest approach. Though old, IDENTITY is still maintained in modern versions of SQL Server and is still relevant for simple use cases.

5 (7)

2020-05-21

4,186 reads

Blogs

Quick Start to Using Influxdb on Macos

By

Intro OSS 2.0 is a release candidate at this time, so this may change once...

Error: 8623 - The query processor ran out of internal resources and could not produce a query plan

By

 Unfortunately a common error in many of our client environments is this: -- Error: 8623, Severity:...

Goal Progress– October 2020

By

This is my report, which continues on from the Aug report. After that report,...

Read the latest Blogs

Forums

How to minimize the SQL Server log growth

By 892717952

In SQL Server 2014,  I go to my database properties and tempdb's database properties...

What is Possible?

By Kathi Kellenberger

Comments posted to this topic are about the item What is Possible?

I cannot add a replica because of difference between instances

By vavoem

Hi There, Let me start with to say I am not a SQL administrator,...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

The Best Query

See possible answers