Sqlserver Interview questions


Total available count: 45
Subject - Databases
Subsubject - Sqlserver

Explain the difference between text and image data type?

Use text type for character data if you need to store more than 255 characters in SQL server 6.5 or more than 8000 in SQL Server 7.0.

Use image type for binary large objects (BLOBs) such as digital images.
 
With text and image data types, the data is not stored in the row, so the limit of the page size does not apply.



Next 5 interview question(s)

1
What are the data types in SQL Server?
2
What is fill factor in SQL Server?
3
What is sorting and what is the difference between sorting & clustered Indexes?
4
Difference between Index defrag and Index rebuild in SQL Server?
5
How many clustered indexes can a table have?