Dinesh's Blog :::: Being Compiled ::::

Showing posts with label IDENTITY. Show all posts
Showing posts with label IDENTITY. Show all posts
Wednesday, August 2, 2017

How to reset IDENTITY in Memory-Optimized Tables

›
Even though SEQUENCE object is available with much more flexibility, we still use IDENTITY property for adding sequence values to tables, ...
Wednesday, January 18, 2017

SQL Server Identity value suddenly became 1000+

›
I noticed that values of a column related to newly inserted records which is an identity property enabled column in one of the tables, sud...
Sunday, September 4, 2016

SQL Server Brain Basher of the Week #052 - Identity property

›
The Identity property is not something new and it has been widely used with most of table when a surrogate key is required. It can be simp...
Sunday, May 8, 2016

SQL Server Brain Basher of the Week #042 - Identity property

›
Let's talk about an important property we always use; Identity property. This property has been used for generating Ids automatically,...
Thursday, March 26, 2015

My Application needs a new sequence number to the table without inserting the record

›
This is something I discussed with one of my colleagues, it was all about obtaining the next sequence number from Identity type column wit...
Thursday, June 17, 2010

What is $IDENTITY?

›
This was in one of my slides of SQL Brain Bashers presentation which was done at SQL Server User Group Meeting. What is $IDENTITY? Everybo...
›
Home
View web version

About Me

My photo
Dinesh Priyankara
Colombo, Sri Lanka
Dinesh Priyankara (MSc IT) is an MVP – Data Platform (Microsoft Most Valuable Professional) in Sri Lanka with 16 years’ experience in various aspects of database technologies including business intelligence. He has done many local and foreign business intelligence implementations and has worked as a subject matter expert on various database and business intelligence related projects. He is the Founder/Principal Architect of dinesQL (Pvt) Ltd and he consults, teaches and runs training programs on data related solutions and subjects.
View my complete profile
Powered by Blogger.