Development

SQLSaturday Israel 2019 speaker shirt In rough order of how frequently I see ’em: There are different workloads running on the server (like a backup is running right now.) You have a different query plan due to parameter sniffing. The query changed, like someone did a deployment or added a field to the select list.…

First, let’s see the error happen: let’s create a table with small fields, and then try to insert more data than it holds. Transact-SQL CREATE TABLE dbo.CoolPeople(PersonName VARCHAR(20), PrimaryCar VARCHAR(20)); GO INSERT INTO dbo.CoolPeople(PersonName, PrimaryCar) VALUES ('Baby', '2006 Subaru Impreza WRX GD'); GO 12345 CREATE TABLE dbo.CoolPeople(PersonName VARCHAR(20), PrimaryCar VARCHAR(20));GOINSERT INTO dbo.CoolPeople(PersonName, PrimaryCar)VALUES ('Baby', '2006…