|
|
Browse by Tags
All Tags » SQL Server » sparse
-
Jedną z istotnych nowości w SQL Server 2005 było zniesienie limitu 8060 bajtów zapisanych w jednym wierszu. Oto krótki test.
[code language=''T-SQL'']
create table dbo.temp_duzaTabela ( a varchar(8000), b varchar(8000), c varchar(8000) )
GO
insert ...
-
Do you think column order doesn't matter in SQL Server tables? Well, if you say it doesn't I would say the same thing as always: ''it depends'' :-)
On SQL Server 2005 instance let's create some table with 50 nullable varchar columns:
[code language=''T-SQL'']USE tempdbGO
IF OBJECT_ID('tempdb.dbo.test_varchar') IS NOT NULL DROP ...
|
|
|