Tags » SQL Server 2008 R2

Sql Server : Error Message : DBCC SHRINKDATABASE: File ID 1 of database ID 2 was skipped because the file does not have enough free space to reclaim.

Quick one today:

A few weeks ago, I ran into an interesting error message:

Error Message:

DBCC SHRINKDATABASE: File ID 1 of database ID 2 was skipped because the file does not have enough free space to reclaim. 261 more words
DBA

SQLNCLI11 for linked server "XYZ" returned message "Requested conversion is not supported" | SQL Server 2012 upgrade behavior changes

This was a year long pending post that got lost in my blog posts archives. Today while filtering the Posts on my Dashboard I saw this in Edit mode. 606 more words

SQL Server 2012

Sql Server Errors: The name "DATETIME" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted.

Quick one today:

Recently, I ran into this interesting error message. The actions that resulted in this error are silly, but the message is interesting. The language used in the error message dignifies the actions to the same level as other valid error messages. 93 more words

DBA

Accessing SQL Server data with Simple.Data

Recently Michael suggested me a lightweight framework for accessing and manipulating data with SQL Server. I’ve tried it and I’ve found some misunderstanding on the official documentation. 55 more words

SQL Server

Sql Server : How to configure Sql Server instance to listen in static port

Sometimes, in our environment, we have multiple instances of Sql Server running on the same machine. In default configuration, when named instances come up, they listen on some port number. 241 more words

DBA

Sql Server : CPU affinity mask or how to limit Sql Server to selected CPU (or processors or NUMA set)

Quick one today:

Recently, during troubleshooting an issue with one of our customers, some patterns emerged that indicated the possibility of resource contention for their repeated timeout issues. 758 more words

DBA

Sql Server : Convert from INTEGER (decimal) to HEX and HEX to INTEGER

Quick one today:

Sometimes there is a need to convert data from integer to HEX and from HEX to integer. There are ways to accomplish this and today, this post covers one such ways. 27 more words

DBA