Tags » SQL Server 2008 R2

Sql Server : Difference between FREESYSTEMCACHE, FREEPROCCACHE, DROPCLEANBUFFERS, etc

Quick one today:

In a previous post, we discussed the different ways to clean Sql Server cache. Now we look at another one. DBCC FREESYSTEMCACHE. 123 more words

DBA

Sql Server Error Messages : Lock request time out period exceeded. (Microsoft SQL Server, Error: 1222)

Quick one today:

A few weeks ago, we ran into an interesting error. This nebulous error has caused some confusion in the team, as it occurred during a high pressure situation. 226 more words

DBA

Fixing 84b40000 error on SQL Server 2008 updates (like KB2977321 and KB2285068) via: Microsoft Community

When installing SQL Server 2008 Service Pack 3 related updates, some don’t like compressed directories (even if the database files themselves are uncompressed).

I found this holds at least for… 68 more words

Development

Sql Server : How to check transactional log file usage

Quick one today:

Sometimes there is a need to track the usage patterns of transactional log file usage. There is a quick and efficient way to gather this data on regular basis. 50 more words

DBA

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