I can create this table:
CREATE TABLE MyBigTable2
( myint INT,
mychar CHAR(8000),
mydate DATETIME,
mychar2 VARCHAR(8000),
mychar3 VARCHAR(8000)
)
GO
If I do this, however, I get an error. The error lets me know a row with those max sizes will exceed the page size. This code
INSERT dbo.MyBigTable2 (myint, mychar, mydate, mychar2, mychar3)
VALUES (1, REPLICATE('A',8000), GETDATE(), REPLICATE('A',8000), REPLICATE('A',8000))
Generates the error.
You cannot put more than 8060 bytes on a page. That's a SQL Server limit.