The current datacenter has failed. The company that we have been using Fibercloud in Bellinhgam WA, with their “Always On” slogan has had an epic… Read More »Moving to a new datacenter – EPIC FAIL – Fibercloud.
The question came up as to which version of sql server is being run, and how do you determine the exact version number of the… Read More »Determining the version of SQL server from TSQL
The following applies to SQL Server 2008. How big of an allocation does max represent in the case of varchar(max) and varbinary(max)? Up to 2… Read More »varchar(max) and varbinary(max) Questions and Answers
I recently have had the opportunity to work on performance tuning on Microsoft SQL Server 2005. Recently I have been doing more with performance tuning… Read More »How much Procedure Cache memory does one SQL Statement take up?
SQL Server can run in a number of different compatibility levels, but how do you change it and how do you set it. These compatibility… Read More »SQL Server 2008 compatibility levels
SQL Server can run in a number of different compatibility levels, but how do you change it and how do you set it. These compatibility… Read More »SQL Server 2005 Compatibility Level
Installing, configuring and administering SQL Server for Microsoft Great Plains. What a bunch of crazy table names.
Just started working at Amazon.com. Now I need to take everything that I know about SQL server and apply it to Oracle.
This page is the easter egg page on my site. Just kind of a funny historical page to denote my first introduction to Microsoft SQL… Read More »Just Learning Microsoft SQL Server