Something that hasn't been mentioned is that many programming tools, including those from Microsoft, don't seem to handle schemas very well. For example, the .NET data source configuration wizard in...

As the stored procedure is written, only backup sets with names are returned.

To return data for all databases except tempdb, the WHERE clause should be:

WHERE k.database_name <> 'tempdb'

Also, the @Days...

The LEFT JOIN for the derived table in the example from stuart.adair should be on b.database_name (not b.DateLogLastBackedUp):

) b ON a.[name] = b.database_name

Yes, AWE applies only to Enterprise or Developer.

http://support.microsoft.com/kb/274750

Dave

Another vote for being able to search specific content areas, such as scripts.

Search results from /columnists and /newsletter return dead links:

http://www.sqlservercentral.com/columnists/bknight/usersqlserver2005features.asp

http://www.sqlservercentral.com/newsletter/view_newsletter.asp?id=1048

It would also be helpful to have a...

It seems that Microsoft has moved the sample files to the codeplex site. As of August, 2007, this link will take you to the 2005 sample downloads.

http://www.codeplex.com/MSFTISProdSamples/Release/ProjectReleases.aspx?ReleaseId=4039

Be aware that...

The Guru's Guide to Transact-SQL by Ken Henderson is an excellent TSQL development reference.

Joe Celko's SQL for Smarties is where I learned many advanced SQL techniques. It took a...

Check the execution plan on View A, as someone already suggested. This will give you a very good idea of where the bottleneck(s) lie.

Also check the indexes on Table D....