Duluth, GA
+ 678-753-4494
contact@datahills.us

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

  • Posted by Sqltimes
  • On January 31, 2015
  • 0 Comments
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. Upon further digging in, the CPU usage was abnormal. The database server was on a Virtual Machine with 8 processors allocated. The CPU usage was only on one […]
Read More
 

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

  • Posted by Sqltimes
  • On January 24, 2015
  • 0 Comments
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. 1 2 3 4 5 6 -- --  Conversation samples -- SELECT    CONVERT(INT, 0x00F0)      AS [Convert_HEX_to_INT]         , CONVERT(VARBINARY(8), 15) AS [Convert_INT_to_HEX] […]
Read More
 

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

  • Posted by Sqltimes
  • On January 10, 2015
  • 0 Comments
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. After some head scratching and banging on the desk, with no avail, my colleague Dylan rescued the quickly dying hope. Requirement We […]
Read More
 

Database Servers on Virtual Machines with vCPU

  • Posted by Sqltimes
  • On January 3, 2015
  • 0 Comments
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. Database servers are usually the […]
Read More