SQL Server 2012

Window Functions in SQL Server

• by Additional Articles

• SimpleTalk

• SQL Server 2012

• Article

With SQL Server 2012, we are soon to enjoy a full range of Window Functions. They are going to make for some much simpler SQL queries, as Fabiano Amorim ably demonstrates here.

2011-11-14

4,521 reads

New Spatial Features in SQL Server Code-Named 'Denali'

• by Additional Articles

• Microsoft MSDN

• SQL Server 2012

• Article

SQL Server 2008 introduced spatial data support into the database server. This paper describes and discusses the new spatial features in SQL Server Code-Named “Denali” CTP1 and CTP3 that augment existing SQL Server 2008 and SQL Server 2008 R2 spatial functionality.

2011-11-03

2,943 reads

Help Make SQL Server “Denali” The Best Release Yet!

• by Press Release

• Microsoft MSDN

• SQL Server 2012

• Article

A blog from Dan Jones of Microsoft asks you to test the next release of SQL Server, in CTP3 now, and send your feedback to Microsoft to ensure that the product is well tested.

2011-08-24

2,006 reads

Tool to help you analyze SQLDIAG and PSSDIAG output

• by Additional Articles

• MSSQLTips.com

• SQL Server 2012

• Article

SQLDIAG or PSSDIAG are excellent tools used to collect and analyze data in order to identify possible performance root causes. The issue is that the output produced by such utilities is sometimes convoluted, hard to read and hard to understand. In this tip, I will show you a tool that you can use to read and analyze the data collected by these tools.

2009-12-17

2,873 reads