SQL Server 2005 SP2 December CTP is available for download

SQL Server 2005 Service Pack 2 December CTP is available now for download. You can download it from: http://www.microsoft.com/downloads/details.aspx?FamilyID=d2da6579-d49c-4b25-8f8a-79d14145500d&DisplayLang=en Note that the December CTP has been published to the same location as the November CTP so if you come from the SQL Server 2005 CTP Home Page and get to December CTP don’t be confused….

1

Download SQL Server 2005 SP2 CTP

SQL Server 2005 Service Pack 2 (SP2) CTP has been released. You can provide feedback on the CTP release via http://connect.microsoft.com/sqlserver. The link for the various downloads is: http://www.microsoft.com/sql/ctp.mspx SQL Server 2005 SP2 CTP contains some new features in the database engine (vardecimal data types, object_name function enhancement, logon triggers, Common Criteria Compliance, sys.dm_exec_text_query_plan DMV,…

1

Disabled anonymous comments…

I have disabled anonymous comments due to the inordinate number of spam comments. And since I had email notifications for comments it was pretty bad. Hopefully this is fine.

1

Top 5 relational data warehouse performance improvements you would like to see in next version of SQL Server

Hello Everyone, We are currently looking at top performance issues for various workloads and how we can improve those in next version of SQL Server. We are collecting feedback from various customer sources. I would like to extend an invitation to readers here for feedback on top 5 relational data warehouse performance improvements you would like to…

13

Top 5 OLTP performance improvements you would like to see in the next version of SQL Server

Hello Everyone, We are currently looking at top performance issues for various workloads and how we can improve those in next version of SQL Server. We are collecting feedback from various customer sources. I would like to extend an invitation to readers here for feedback on top 5 OLTP performance improvements you would like to…

31

Using catalog views in SQL Server 2005

Did you know that the catalog views in SQL Server 2005 exposes metadata for various objects in a database and at the server-level? This is the preferred method of accessing metadata. It is a much richer mechanism that doesn’t require access to system tables or undocumented columns or status bits. If you want standard and portable…

2

DATALENGTH optimizations for LOB data types…

DATALENGTH function in TSQL can be used to find the actual length in bytes of the data in a specific value. The value can be any of the data types. It is often used to determine length of LOB data type columns (text, ntext, image, varchar(max), nvarchar(max) and varbinary(max)) in a table. One of the…

10

New whitepapers on physical database storage and tempdb…

Below are links to two new whitepapers from the storage engine team. Please check it out to get better understanding of the new features in SQL Server 2005 and enhancements.   Working with TempDBhttp://download.microsoft.com/download/4/f/8/4f8f2dc9-a9a7-4b68-98cb-163482c95e0b/WorkingWithTempDB.doc Physical Database Storagehttp://download.microsoft.com/download/4/f/8/4f8f2dc9-a9a7-4b68-98cb-163482c95e0b/PhysDBStor.doc

0

Troubleshooting deadlocks in SQL Server 2005

SQL Server 2005 adds new capabilities to troubleshoot deadlocks. I talked about the new trace flag #1222 in a previous post. The blog entry below from the SQL Server Storage Engine team talks about the new trace flag and provides some examples on how to use the new output. http://blogs.msdn.com/sqlserverstorageengine/archive/2006/06/05/617960.aspx

0

Use of SCHEMABINDING option for TSQL UDFs can improve performance in SQL Server 2005…

SQL Server 2005 has new optimization logic to use the SCHEMABINDING option to derive certain properties about the TSQL UDF. This can greatly improve performance of queries that use scalar UDFs in a SELECT statement for example. You can read all about it at the blog entry below from one of  our development engineers. http://blogs.msdn.com/sqlprogrammability/archive/2006/05/12/596424.aspx

2