sql server

Database
SQL Server

Max Memory Configuration set too low [SQL Server]

We have been experiencing an issue with a clustered node where instances will run extremely slow and the only process eating CPU resources is “NT Kernel & System”. We have upgraded drivers and even wiped out and reinstalled Windows and SQL Server (both 2008 R2) and the issue reappears. In the process of troubleshooting with […]

Read More
Analytics
Database
SQL Server

Windowed Functions empowering analytics [#TSQL2sday]

This blog entry is participating in the T-SQL Tuesday #16 for the month of February, hosted by Jes Schultz Borland (Blog|Twitter). Back in 2001 I was involved in a project migrating an e-commerce site to a new platform. We were mapping and moving data from an Oracle 8.1.5 to an Oracle 8.1.7 instance. The framework […]

Read More
Database
SQL Server

Table Structure, Trading Maintenance with Performance [SQL Server]

With this exercise we have effectively increased performance at the expense of maintenance. Well worth the change.

Read More
Database
SQL Server

Denali, the next release [SQL Server]

SQL Server Codename “Denali” Community Technology Preview 1 released

Read More