Differentiate between Wide and Nonwide tables in SQL Server?

HomePage Jobs WalkIn Articles Group Chat Contact Us Feedback Sitemap

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

Differentiate between Wide and Nonwide tables in SQL Server?
Question Posted on 05 Sep 2021Home >> DataBase >> SQL Query >> Differentiate between Wide and Nonwide tables in SQL Server?

Differentiate between Wide and Nonwide tables in SQL Server?
Below are the some common difference between Wide and Non-wide in SQL Server

	0
	0

Base Of Difference	Wide	Nonwide
No of Columns	Wide table can contain upto 30,000 columns	Non-wide table can contain only 1024 columns.
Transactional or Merge	Wide tables will not work with transactional or merge replications.	Non-wide can work with transactional or merge replications.
OLAP System	Wide tables are used in OLAP systems.	Narrow tables are used in OLTP system
Type	We can considered wide table to be denormalized tables.	We can consider Nonwide tables to be normalized tables.
Verison & reason	Wide tables concepts comes in SQL Server 2008 as a new feature	Non-wide comes into picture to overcome the limitation of 1024 columns in narrow tables.


	.

	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...

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