July 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home
  • 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

SQL SERVER – Measuring the Length of VARCHAR and NVARCHAR Columns with COL_LENGTH

December 29, 2018
Pinal Dave
SQL Tips and Tricks
SQL Column, SQL Datatype, SQL Function, SQL Scripts, SQL Server

I love my job because I get to help people learn new technology as well as help them clear their confusion about the older technology. Recently during SQL Server Performance Tuning Practical Workshop, I was asked a very simple but interesting question by an attendee about NVARCHAR column. 

Read More

SQL SERVER – FIX: Number Data Type from Oracle Linked Sever Shown in Scientific Notation

January 15, 2018
Pinal Dave
SQL Tips and Tricks
Linked Server, Oracle, SQL Datatype, SQL Error Messages, SQL Server

One of my clients contacted me for an issue where they reported that they are seeing an issue with numbers when they are accessed via Oracle linked server.

Read More

SQL SERVER – How to Change Column Property From NULL to NOT NULL Value?

January 12, 2018
Pinal Dave
SQL Tips and Tricks
SQL Column, SQL Datatype, SQL NULL, SQL Scripts, SQL Server

A Very popular question I often here whenever I am presenting at the developer conference – How to Change Column Property From NULL to Not NULL Value?

Read More

SQL SERVER – Puzzle – Brain Teaser – Changing Data Type is Changing the Default Value

December 8, 2017
Pinal Dave
SQL Puzzle
SQL Column, SQL Datatype, SQL NULL, SQL Server

Today, we will see a very interesting puzzle about data types and default values.
You need to answer-

1 The original datatype A and default value B
2 The new datatype C and new default value D

Read More

SQL SERVER – Convert Decimal to Time Format in String

September 13, 2017
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL DateTime, SQL Function, SQL Scripts, SQL Server, SQL String

A very strange question I received the other day in an email about how to convert decimal to time format string.

Read More

What is the Default Datatype of NULL? – Interview Question of the Week #131

July 16, 2017
Pinal Dave
SQL Interview Questions and Answers
SQL Datatype, SQL Server

Question: What is the Default Datatype of NULL?

Read More

SQL SERVER – ALTER Column from INT to BIGINT – Error and Solutions

July 4, 2017
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Error Messages, SQL Scripts, SQL Server

Sometime ago I wrote a blog on identity column value jump issue, you can read it from here SQL SERVER –  Jump in Identity column after restart! In this blog post we will learn how to resolve the error when we alter column from int to bigint. 

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

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

Go to mobile version