Sql Server Errors : Arithmetic overflow error converting IDENTITY to data type int. Why does changing INT column run faster than changing VARCHAR/CHAR column?

Posted by Sqltimes
On June 27, 2015
0 Comments

Quick one today: Earlier, we ran into an interesting error in our lab environment. Msg 8115, Level 16, State 1, Line 2 Arithmetic overflow error converting IDENTITY to data type int. Arithmetic overflow occurred. Initially, this error did not make sense. There are no calculations performed on this column data for it to overflow, but […]

Posted by Sqltimes
On June 20, 2015
0 Comments

Quick one today: Recently, in our lab, we ran into this interesting error: 1 Backup, file manipulation operations (such as ALTER DATABASE ADD FILE) and encryption changes on a database must be serialized. Turns out, we were attempting to multiple operations there were mutually exclusive. For example, Adding a new data file while backup operation […]

Posted by Sqltimes
On June 13, 2015
0 Comments

Quick one today: Sometimes there is a need to query Environment Variables using T-SQL. ‘xp_cmdshell’ allows us to query environment variables. First we need to enable ‘xp_cmdshell’ in ‘sys.configurations’ using EXEC sp_configure. It is an advanced option, so enable ‘advanced options’ first. 1 2 3 4 5 6 7 8 9 10 11 12 13 […]

Posted by Sqltimes
On June 6, 2015
0 Comments

Quick one today: Recently, we kept running into this question from several people. So, adding a dedicated post made sense. In short, yes. Rebuilding indexes increases database file size. There are some nuances, but in general terms it is true. Both ONLINE or OFFLINE rebuild/reindexing operations increase file size. For more information about reindexing indexes and […]

Posted by Sqltimes
On June 1, 2015
0 Comments

There are several ways to measure, capture & analyze meta to fully map out Sql Server performance on a given server (hardware). Regularly capturing this data allows identifying trends of resource consumption and helps in Capacity Planning. PerfMon (Performance Monitor) has Data Collectors that allow us to capture good meta-data. Operating System calculates this data […]

Sql Server Errors : Arithmetic overflow error converting IDENTITY to data type int. Why does changing INT column run faster than changing VARCHAR/CHAR column?

Sql Server Error : Backup, file manipulation operations (such as ALTER DATABASE ADD FILE) and encryption changes on a database must be serialized.

Sql Server : Read environment variables from T-SQL

Sql Server : Does REBUILDing indexes increase data file size?

Sql Server : Use Performance Monitor to capture Sql Server resource consumption metrics