SQL Server 2005 vs SQL Server 2008
-
Posted on June 25, 2009 by Derek Dieter
Outlines some new features of SQL Server 2008 and provides the reasons to upgrade instead of 2005.
Continue reading ...SQL Server Indexes Tutorial
-
Posted on June 24, 2009 by Derek Dieter
This article gives a real world explanation (and code examples) of indexing along with the tools necessary to be able to choose the right indexing strategy for your tables.
Continue reading ...SQL Server Interview Questions
-
Posted on June 23, 2009 by Derek Dieter
Real world questions asked to real interviewees. These interview questions cover the different areas of SQL Development, data flow, and Database Administration.
Continue reading ...Delete Duplicate Records in SQL
-
Posted on June 23, 2009 by Derek Dieter
Examples on how to removed duplicate rows from your table even if you do not have a primary key.
Continue reading ...Replace Invalid Characters
-
Posted on June 23, 2009 by Derek Dieter
Example on how to replace characters within a SQL String. Examples would be to remove all alpha or numeric characters from a string.
Continue reading ...
