Tags » SQL Server 2008 R2

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

Sql Server : ORDER BY clause beauty and complexity (Tidbit 3)

A few days ago, there was an interesting requirement. We have a query that needs to bring data from a set of tables in a particular order that did not seem straight forward. 565 more words

DBA

Database Servers on Virtual Machines with vCPU

More and more database servers are being migrated into virtual machines. The momentum towards virtual machines is strong, with good reasons, and as a DBA we need to come up with ways to make sure that our database servers are correctly configured to fully utilize the capabilities of virtual environments. 503 more words

DBA

SCCM 2012 - Hierarchy with CAS - Installation Central Administration Site [Part 1]

Here is the first part of the SCCM 2012 R2 series. On part one I will show you guys how to configure a Central Administration Site for all your administration and reporting needs with your hierarchy. 712 more words

Microsoft

Sql Server OUTPUT Clause Examples with UPDATE INSERT DELETE MERGE

OUTPUT is an interesting clause added starting Sql Server 2005.

DELETE

Recently, in my previous post, we saw an example with some insight into the usage of OUTPUT clause with DELETE statement. 276 more words

DBA