My wife asked me to install a named instance of SQL Server 2005 Enterprise Edition x64 on top our existing SQL Server 2008 R2 Enterprise x64. HA! As a SQL Server MCT (besides the fact that I did quite a few installs in my time) I should have known better how to do it. So … Continue reading Side-by-side installation of SQL 2008 R2 and SQL Server 2005
Category: choice
much ado about data types
I recently (yesterday, in fact), got to see some amazing recommendations regarding the use of data types. Now I have the chance to provide my personal opinions (guidelines):primary keys: monotonous, ever increasing values - personal choice, but it can introduce unnecessary complexity. So, for the case of small tables, use whatever fits you:as an example, … Continue reading much ado about data types
SQL-PLAY 