Newbie here,
I am trying to find out why we sometimes have a bunch of reads from the syscolumns table
It looks like this:
Select CONVERT(CHAR(30),sc.name), sc.type, sc.usertype, sc.length, sc.status from syscolumns sc where sc.id = object_id( 'inventory_ext' )
There can be from a few to as many as 20 such statements in a bunch, all using a different table name (with object_id)
Does anyone know if that really is useful ? Any way to turn that off ?
Thanks