I have been testing SQL Server 2008 RC0 (Release Candidate Zero) that was made available recently and I must admit I am beginning to like it. Even the new logo is growing on me. There are many new ...

Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement. It’s sometimes difficult to know which SQL syntax to use when ...

We are developing an asp.net web application for an internal company website. The web app makes heavy use of an SQL database and I feel that future bottlenecks will come down to SQL performance. In ...