crackyourinterview.com


To improves our performance please Like Share Subscribe(Will boost us)

Do you knows the size of “Null” value in SQL Server?
Question Posted on 05 Sep 2021Home >> DataBase >> sql questions >> Do you knows the size of “Null” value in SQL Server?

Do you knows the size of “Null” value in SQL Server?
There are two main reason which will impacts the size of "Null" values in SQL Server.
(1)IF the size of column is fixed width then storing NULL takes the same space as any other value in the column will take which is the width of the field.
(2)If we have the variable width in SQL Column then the NULL value takes up no space.
0
0



.


Most Visited Questions:-

Deep Learning Questions Answers
Below are the different Deep Leaning Questions and answer a More...

Continuous Integration Questions Answers
Below are the 20 odd questions for CI or Continuous Integra More...

Derived relationships in Association Rule Mining are represented in the form of __________.
Derived relationships in Association Rule Mining are repres More...

What is Gulpjs and some multiple choice questions on Gulp
Gulpjs is an open source whihc helps in building Javascript More...

Microservices Architecture Questions Answers
Below are the different questions on Microservices Architec More...




Other Important Questions

Define N in nvarchar and in nchar?

difference between drop and truncate command

difference between procedure and function

different types of databases in sql

Difference Between Update Lock and Exclusive Lock






@2014-2022 Crackyourinterview (All rights reserved)
Privacy Policy - Disclaimer - Sitemap