na sql 2019, wersja ODBC 17 (https://www.microsoft.com/en-us/download/details.aspx?id=56567)
Zrobiłem testową tabelke ze 160 kolumnami i 20000 wierszami ok 23 MB:
/****** Object: Table [dbo].[test4] Script Date: 2021-11-18 10:37:04 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[test4]') AND type in (N'U'))
DROP TABLE [dbo].[test4]
GO
/****** Object: Table [dbo].[test4] Script Date: 2021-11-18 10:37:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[test4](
[pk] [int] IDENTITY(1,1) NOT NULL,
[char1] [char](5) NULL,
[char2] [char](5) NULL,
[char3] [char](5) NULL,
[char4] [char](5) NULL,
[char5] [char](5) NULL,
[char6] [char](5) NULL,
[char7] [char](5) NULL,
[char8] [char](5) NULL,
[char9] [char](5) NULL,
[char10] [char](5) NULL,
[char11] [char](5) NULL,
[char12] [char](5) NULL,
[char13] [char](5) NULL,
[char14] [char](5) NULL,
[char15] [char](5) NULL,
[char16] [char](5) NULL,
[char17] [char](5) NULL,
[char18] [char](5) NULL,
[char19] [char](5) NULL,
[char20] [char](5) NULL,
[char21] [char](5) NULL,
[char22] [char](5) NULL,
[char23] [char](5) NULL,
[char24] [char](5) NULL,
[char25] [char](5) NULL,
[char26] [char](5) NULL,
[char27] [char](5) NULL,
[char28] [char](5) NULL,
[char29] [char](5) NULL,
[char30] [char](5) NULL,
[char31] [char](5) NULL,
[char32] [char](5) NULL,
[char33] [char](5) NULL,
[char34] [char](5) NULL,
[char35] [char](5) NULL,
[char36] [char](5) NULL,
[char37] [char](5) NULL,
[char38] [char](5) NULL,
[char39] [char](5) NULL,
[char40] [char](5) NULL,
[char41] [char](5) NULL,
[char42] [char](5) NULL,
[char43] [char](5) NULL,
[char44] [char](5) NULL,
[char45] [char](5) NULL,
[char46] [char](5) NULL,
[char47] [char](5) NULL,
[char48] [char](5) NULL,
[char49] [char](5) NULL,
[char50] [char](5) NULL,
[char51] [char](5) NULL,
[char52] [char](5) NULL,
[char53] [char](5) NULL,
[char54] [char](5) NULL,
[char55] [char](5) NULL,
[char56] [char](5) NULL,
[char57] [char](5) NULL,
[char58] [char](5) NULL,
[char59] [char](5) NULL,
[char60] [char](5) NULL,
[char61] [char](5) NULL,
[char62] [char](5) NULL,
[char63] [char](5) NULL,
[char64] [char](5) NULL,
[char65] [char](5) NULL,
[char66] [char](5) NULL,
[char67] [char](5) NULL,
[char68] [char](5) NULL,
[char69] [char](5) NULL,
[char70] [char](5) NULL,
[char71] [char](5) NULL,
[char72] [char](5) NULL,
[char73] [char](5) NULL,
[char74] [char](5) NULL,
[char75] [char](5) NULL,
[char76] [char](5) NULL,
[char77] [char](5) NULL,
[char78] [char](5) NULL,
[char79] [char](5) NULL,
[char80] [char](5) NULL,
[char81] [char](5) NULL,
[char82] [char](5) NULL,
[char83] [char](5) NULL,
[char84] [char](5) NULL,
[char85] [char](5) NULL,
[char86] [char](5) NULL,
[char87] [char](5) NULL,
[char88] [char](5) NULL,
[char89] [char](5) NULL,
[char90] [char](5) NULL,
[char91] [char](5) NULL,
[char92] [char](5) NULL,
[char93] [char](5) NULL,
[char94] [char](5) NULL,
[char95] [char](5) NULL,
[char96] [char](5) NULL,
[char97] [char](5) NULL,
[char98] [char](5) NULL,
[char99] [char](5) NULL,
[char100] [char](5) NULL,
[char101] [char](5) NULL,
[char102] [char](5) NULL,
[char103] [char](5) NULL,
[char104] [char](5) NULL,
[char105] [char](5) NULL,
[char106] [char](5) NULL,
[char107] [char](5) NULL,
[char108] [char](5) NULL,
[char109] [char](5) NULL,
[char110] [char](5) NULL,
[char111] [char](5) NULL,
[char112] [char](5) NULL,
[char113] [char](5) NULL,
[char114] [char](5) NULL,
[char115] [char](5) NULL,
[char116] [char](5) NULL,
[char117] [char](5) NULL,
[char118] [char](5) NULL,
[char119] [char](5) NULL,
[char120] [char](5) NULL,
[float1] [float] NULL,
[float2] [float] NULL,
[float3] [float] NULL,
[float4] [float] NULL,
[float5] [float] NULL,
[float6] [float] NULL,
[float7] [float] NULL,
[float8] [float] NULL,
[float9] [float] NULL,
[float10] [float] NULL,
[float11] [float] NULL,
[float12] [float] NULL,
[float13] [float] NULL,
[float14] [float] NULL,
[float15] [float] NULL,
[float16] [float] NULL,
[float17] [float] NULL,
[float18] [float] NULL,
[float19] [float] NULL,
[float20] [float] NULL,
[int1] [int] NULL,
[int2] [int] NULL,
[int3] [int] NULL,
[int4] [int] NULL,
[int5] [int] NULL,
[int6] [int] NULL,
[int7] [int] NULL,
[int8] [int] NULL,
[int9] [int] NULL,
[int10] [int] NULL,
[int11] [int] NULL,
[int12] [int] NULL,
[int13] [int] NULL,
[int14] [int] NULL,
[int15] [int] NULL,
[int16] [int] NULL,
[int17] [int] NULL,
[int18] [int] NULL,
[int19] [int] NULL,
[int20] [int] NULL,
[text1] [text] NULL,
[text2] [text] NULL,
CONSTRAINT [PK_test4] PRIMARY KEY CLUSTERED
(
[pk] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
insert into test4 (char1,char2,char3,char4,char5,char6,char7,char8,char9,char10,char11,char12,char13,char14,char15,char16,char17,char18,char19,char20,char21,char22,char23,char24,char25,char26,char27,char28,char29,char30,char31,char32,char33,char34,char35,char36,char37,char38,char39,char40,char41,char42,char43,char44,char45,char46,char47,char48,char49,char50,char51,char52,char53,char54,char55,char56,char57,char58,char59,char60,char61,char62,char63,char64,char65,char66,char67,char68,char69,char70,char71,char72,char73,char74,char75,char76,char77,char78,char79,char80,char81,char82,char83,char84,char85,char86,char87,char88,char89,char90,char91,char92,char93,char94,char95,char96,char97,char98,char99,char100,char101,char102,char103,char104,char105,char106,char107,char108,char109,char110,char111,char112,char113,char114,char115,char116,char117,char118,char119,char120,float1,float2,float3,float4,float5,float6,float7,float8,float9,float10,float11,float12,float13,float14,float15,float16,float17,float18,float19,float20,int1,int2,int3,int4,int5,int6,int7,int8,int9,int10,int11,int12,int13,int14,int15,int16,int17,int18,int19,int20,text1,text2)
values (replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),replicate('A',5),100,200,300,400,500,600,700,800,900,1000,1100,1200,1300,1400,1500,1600,1700,1800,1900,2000,100,200,300,400,500,600,700,800,900,1000,1100,1200,1300,1400,1500,1600,1700,1800,1900,2000,'',''
)
GO
insert into test4 (char1,char2,char3,char4,char5,char6,char7,char8,char9,char10,char11,char12,char13,char14,char15,char16,char17,char18,char19,char20,char21,char22,char23,char24,char25,char26,char27,char28,char29,char30,char31,char32,char33,char34,char35,char36,char37,char38,char39,char40,char41,char42,char43,char44,char45,char46,char47,char48,char49,char50,char51,char52,char53,char54,char55,char56,char57,char58,char59,char60,char61,char62,char63,char64,char65,char66,char67,char68,char69,char70,char71,char72,char73,char74,char75,char76,char77,char78,char79,char80,char81,char82,char83,char84,char85,char86,char87,char88,char89,char90,char91,char92,char93,char94,char95,char96,char97,char98,char99,char100,char101,char102,char103,char104,char105,char106,char107,char108,char109,char110,char111,char112,char113,char114,char115,char116,char117,char118,char119,char120,float1,float2,float3,float4,float5,float6,float7,float8,float9,float10,float11,float12,float13,float14,float15,float16,float17,float18,float19,float20,int1,int2,int3,int4,int5,int6,int7,int8,int9,int10,int11,int12,int13,int14,int15,int16,int17,int18,int19,int20,text1,text2)
select top 2500 char1,char2,char3,char4,char5,char6,char7,char8,char9,char10,char11,char12,char13,char14,char15,char16,char17,char18,char19,char20,char21,char22,char23,char24,char25,char26,char27,char28,char29,char30,char31,char32,char33,char34,char35,char36,char37,char38,char39,char40,char41,char42,char43,char44,char45,char46,char47,char48,char49,char50,char51,char52,char53,char54,char55,char56,char57,char58,char59,char60,char61,char62,char63,char64,char65,char66,char67,char68,char69,char70,char71,char72,char73,char74,char75,char76,char77,char78,char79,char80,char81,char82,char83,char84,char85,char86,char87,char88,char89,char90,char91,char92,char93,char94,char95,char96,char97,char98,char99,char100,char101,char102,char103,char104,char105,char106,char107,char108,char109,char110,char111,char112,char113,char114,char115,char116,char117,char118,char119,char120,float1,float2,float3,float4,float5,float6,float7,float8,float9,float10,float11,float12,float13,float14,float15,float16,float17,float18,float19,float20,int1,int2,int3,int4,int5,int6,int7,int8,int9,int10,int11,int12,int13,int14,int15,int16,int17,int18,int19,int20,text1,text2
from test4 cross join (
select * from master..spt_values) v
go 8
Wyniki:
Serwer w sieci na jakimś słabym serwerze nie lokalnie