Tags » SQL Server 2008 R2

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

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. 242 more words
DBA

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

Quick one today:

Recently, in our lab, we ran into this interesting error:

Backup, file manipulation operations (such as ALTER DATABASE ADD FILE) and encryption changes on a database must be serialized. 121 more words
DBA

Sql Server : Read environment variables from T-SQL

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. 172 more words

DBA

Sql Server : Does REBUILDing indexes increase data file size?

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.  291 more words

DBA

SQL Server - Capture Execution Plan of a Currently Running Query/Process SPID

DBAs most often face scenarios where they need to capture graphical execution plan of a query currently running on a live production instance because of multiple reasons like: 176 more words

SQL Server 2012

SQL Server - How to Calculate Length and Size of any field in a SQL Table

Recently I came across a situation where queries are loading extremely slow from a table. After careful analysis we found the root cause being, a column with ntext datatype was getting inserted with huge amounts of text content/data. 162 more words

SQL Server 2012

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

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. 444 more words

DBA