SQL Server allows some interesting index behavior and there's been some debate over whether it makes sense or not. This Friday Steve Jones asks if you have a reason for this.

Seeing Double

by Steve Jones

SQLServerCentral.com

Editorial - MP3

SQL Server allows some interesting index behavior and there's been some debate over whether it makes sense or not. This Friday Steve Jones asks if you have a reason for this.

UPSERT Functionality in SQL Server 2008

by Additional Articles

Database Journal

SQL Server 2008

This article illustrates the functionality of UPSERT via the MERGE command in SQL Server 2008.

The April Energy Update

by Steve Jones

SQLServerCentral.com

Editorial

The bimonthly update on energy news from Steve Jones, focusing mostly this month on wind power.

Reading the SQL Server log files using T-SQL

by Additional Articles

MSSQLTips.com

T-SQL

One of the issues I have is that the SQL Server Error Log is quite large and it is not always easy to view the contents with the Log File Viewer. In a previous tip "Simple way to find errors in SQL Server error log" you discussed a method of searching the error log using VBScript. Are there any other easy ways to search and find errors in the error log files?

Same Report but Different Methods in SQL Server Reporting Services

by Additional Articles

SQL Server Performance

Reporting Services (SSRS)

In Reporting Services in SQL Server 2005 there are several ways of achieving the same result. This article introduces how we can create the same report using several different methods.