Technical Article

List DB tables and their maximum row size (bytes)

Many users during the process of insert or update get the following warning issued by SQL ServerWarning: The table 'TABLE NAME' has been created but its maximum row size (XXXX) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length […]

5 (1)

You rated this post out of 5. Change rating

2005-09-02 (first published: )

312 reads

Blogs

How Long Will It Take to Learn SQL? The Truth Might Surprise You

By

In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...

Flying Halfway Around the World to Australia

By

I leave tonight for Australia. I was in London 3 days ago, so this...

Dealing with Change – Two Resources

By

As I look at the state of information technology today, I see one constant:...

Read the latest Blogs

Forums

Db growth rate

By mtz676

Sample data: jan   10gb feb 15gb mar 16gb april 14gb(truncate data) may 18gb june...

Reference for doing Data Warehousing in SQL Server

By pietlinden

Everybody (well almost) knows that if you want to learn the design patterns for...

SSIS Execution Error

By Wecks

I am no SSIS expert and am struggling here I am hoping some of...

Visit the forum

Question of the Day

Using Table Hints in a Query

How many table hints can I include in a query?  

See possible answers