SQL Server Engine Tips

SQL Server 2005 SP2 Re-release and post fixes

Bob Ward from PSS has a wonderful blog article that explains the details about the re-release of SQL Server 2005 SP2 and fixes posted later. This is a must read for anyone deploying SQL Server 2005 SP2 to understand the various hotfixes, GDRs and procedures. Read More...

Posted Wednesday, April 11, 2007 2:21 PM by SQL Server Engine Team | 1 Comments

New MSDN Books Online search functionality

Check out the new Books Online search functionality online. The link below provides a scoped search of Books Online that returns a more precise and targeted result set. You can use it to search Books Online content quickly. http://search.live.com/macros/sql_server_user_education/booksonline Read More...

Posted Friday, March 30, 2007 11:53 AM by SQL Server Engine Team | 1 Comments

SQL Server 2005 Performance Dashboard Reports

The SQL Server 2005 Performance Dashboard Reports are Reporting Services report files designed to be used with the Custom Reports feature introduced in the SQL Server 2005 SP2 release of SQL Server Management Studio. The reports allow a database administrator Read More...

Posted Thursday, March 29, 2007 12:22 PM by SQL Server Engine Team | 1 Comments

SQL Server Performance Engineering Team Blog

I would like to announce the blog from my team - SQL Server Performance Engineering. Feel free to visit our blog at http://blogs.msdn.com/sqlperf for your performance related questions and needs. Use the email link in the home page to share your feedback Read More...

Posted Tuesday, February 27, 2007 4:16 PM by SQL Server Engine Team | 1 Comments

SQL Server 2005 SP2 has been released...

SQL Server 2005 Service Pack 2 has been released. You can find more information from the service pack 2 page . This service pack extends the functionality of SQL Server in many ways. The What's New document highlights the major changes in the Database Read More...

Posted Monday, February 19, 2007 2:24 PM by SQL Server Engine Team | 1 Comments

Database Applications Profile Survey in http://connect.microsoft.com/sqlserver

My team (Data & SQL Storage Performance Team) is conducting a survey on http://connect.microsoft.com/sqlserver to better understand SQL Server workloads. The connect link below will take you directly to the survey: https://connect.microsoft.com/SQLServer/Survey/Survey.aspx?SurveyID=2226 Read More...

Posted Sunday, February 04, 2007 11:16 AM by SQL Server Engine Team | 1 Comments

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 Read More...

Posted Tuesday, December 19, 2006 5:37 PM by SQL Server Engine Team | 1 Comments

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 Read More...

Posted Wednesday, November 08, 2006 1:04 PM by SQL Server Engine Team | 1 Comments

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 Read More...

Posted Wednesday, September 20, 2006 4:35 PM by SQL Server Engine Team | 13 Comments

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 Read More...

Posted Wednesday, September 20, 2006 4:28 PM by SQL Server Engine Team | 31 Comments

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 Read More...

Posted Wednesday, September 06, 2006 11:31 AM by SQL Server Engine Team | 2 Comments

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 TempDB http://download.microsoft.com/download/4/f/8/4f8f2dc9-a9a7-4b68-98cb-163482c95e0b/WorkingWithTempDB.doc Read More...

Posted Thursday, June 22, 2006 2:35 PM by SQL Server Engine Team | 0 Comments

Performance tips...

I recently moved to the Central Performance Team in the SQL Server product group. My group is responsible for box-wide performance, benchmark and scalability. Given my new role I will be posting more of performance tips and techniques. I will be covering Read More...

Posted Tuesday, February 14, 2006 3:31 PM by SQL Server Engine Team | 15 Comments

Top 5 features you would like to see in the next version of SQL Server

Here is an opportunity to discuss about the top 5 features that you would like to see in the next version of SQL Server. It would be nice if you can include a sentence for each feature explaining why it is required. Please use features of SQL Server 2005 Read More...

Posted Friday, October 07, 2005 3:45 PM by SQL Server Engine Team | 82 Comments

Request for topics...

Please post requests for topics or features that you would like to know about. This can be any of the SQL/TSQL language features or programmability in general. There are so many things to discuss about wrt SQL Server 2005 so it will be good to gauge interest Read More...

Posted Thursday, September 22, 2005 7:07 PM by SQL Server Engine Team | 28 Comments