March 2023 Discount: Comprehensive Database Performance Health Check | Testimonials

  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
    • Search SQLAuthority
  • Downloads
  • Hire Me
  • Health Check
  • Training

Find Missing Identity – SQL in Sixty Seconds #195

March 3, 2022
Pinal Dave
SQL Video
SQL Identity, SQL in Sixty Seconds, SQL Server

Today, we will discuss a very interesting topic about how to find missing identities from our database table. I have previously blogged.

Read More
Missing-Identity

SQL SERVER – Find Missing Identity Values

February 28, 2022
Pinal Dave
SQL Tips and Tricks
SQL Identity, SQL Server

I recently received a question during Comprehensive Database Performance Health Check about how to Find Missing Identity Values.

Read More
Difficult to Remove

SQL SERVER – Identity Column is Difficult to Remove

June 16, 2021
Pinal Dave
SQL Tips and Tricks
SQL Identity, SQL Scripts, SQL Server

I discuss this during  Comprehensive Database Performance Health Check. It is true that the identity Column is Difficult to Remove.

Read More
no validation

How to Add Constraint With No Validation? – Interview Question of the Week #299

October 25, 2020
Pinal Dave
SQL Interview Questions and Answers
SQL Constraint and Keys, SQL Error Messages, SQL Identity, SQL Scripts, SQL Server

Question: How to Add Constraint With No Validation?

Answer: I got this question from one of my clients of who is an Oracle user.

Read More
Identity Constraint

SQL SERVER – Identity and Constraint Confusion

October 24, 2020
Pinal Dave
SQL Tips and Tricks
SQL Constraint and Keys, SQL Identity, SQL Scripts, SQL Server

What is going on with their server as I had no access to their data or schema. Let us learn about how identity and constraint confusion created problems.

Read More
negative identity

Negative Identity Column – SQL in Sixty Seconds #101

August 14, 2020
Pinal Dave
SQL Video
SQL Identity, SQL in Sixty Seconds, SQL Performance, SQL Scripts, SQL Server

I had a very interesting story to tell about a negative identity column from my recent Comprehensive Database Performance Health Check. 

Read More
two identity columns

SQL SERVER – Having Two Identity Columns for A Single Table

June 5, 2020
Pinal Dave
SQL Tips and Tricks
Computed Column, SQL Identity, SQL Scripts, SQL Server, SQL Server DBCC

In yesterday’s session, a DBA asked an interesting question that if it is possible to have two identity columns for a single table. Yes and No. 

Read More
1 2 3 4 … 6 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

© 2006 – 2023 All rights reserved. pinal @ SQLAuthority.com

Go to mobile version