Thank you in advance for your help.

We have a “typical” table that is causing extended query times on even the most simple SQL. A count(*) of ~250k records is taking 6+ minutes. Are there underlying config issues with the table construction?

We use Azure Data Studio and when I right-click on the table for a “Script as Create” this is the SQL that is provided…. it seems odd – but I lack the skills to pinpoint the issue.

CREATE TABLE [SFDC2].[Sales_Interactions](
[Id] [nvarchar](max) NULL,
[Name] [nvarchar](max) NULL,
[UserID] [nvarchar](max) NULL,
[MgrName] [nvarchar](max) NULL,
[MgrID] [nvarchar](max) NULL,
[TopMgr] [nvarchar](max) NULL,
[Mgr4] [nvarchar](max) NULL,
[Mgr3] [nvarchar](max) NULL,
[Mgr2] [nvarchar](max) NULL,
[Mgr] [nvarchar](max) NULL,
[Type] [nvarchar](max) NULL,
[Date] [datetime] NULL,
[ItemID] [nvarchar](max) NULL,
[Match] [nvarchar](max) NULL,
[RecipientID] [nvarchar](max) NULL,
[RecipType] [nvarchar](max) NULL,
[Subject] [nvarchar](max) NULL,
[AddlInfo] [nvarchar](max) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]


select count(*)
from [SFDC2].[Sales_Interactions]

Took 6 minutes to complete on 250k records.