Engine Watch

I have not posted for almost 2 weeks. I have been very busy with Yukon work. Today this paper come to my attention, I think it is very useful for anyone who are interested in performance tuning in SQL 2005. http://www.microsoft.com/technet/prodtechnol...

MVP Bill Graziano's PASS 2004 presentation on " Trace and Profiler in SQL Server 2005 " Slides for download: http://www.pinpub.com/sqlblog/ViewItem.asp?Entry=31 A little bit from here: http://www.sqlskills.com/blogs/kimberly/PermaLink.aspx?guid=f3a2451a...

Q: > "Niles" < Niles@discussions.microsoft.com > wrote in message > news:48E0BCCD-78CA-4C4D-8F32-26D4D62857A2@microsoft.com ... >>A couple of vendor installations of systems installed additional tables >> within the master database...

A list of articles for both beginners and advanced users http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/default.mspx

Do you know them? http://www.joesack.com/iprepindexdbcc.html

http://msdn.microsoft.com/library/en-us/dnsql90/html/sqlclrguidance.asp

some people asked about the features of SQL Server Express in 2005. Here is a good start http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsse/html/sseoverview.asp

I have noticed from the newsgroup that several new users of SQL does not understand the log file. There are some exellent answers from the newsgroup too: For example, here is a post that is worth mentioning: "Andrew J. Kelly" < sqlmvpnooospam@shadhawk...

Good reading: http://www.sqlskills.com/resources/Whitepapers/Partitioning%20in%20SQL%20Server%202005%20Beta%20II.htm

Good reading http://www.karaszi.com/sqlserver/info_dont_shrink.asp

Very good article on technet: http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlIObasics.mspx

These web pages are somewhat useful: http://www.sql-server-performance.com/deadlocks.asp http://www.informit.com/articles/article.asp?p=351608&seqNum=1 http://msdn.microsoft.com/library/default.asp?url=/library/en-us/optimsql/odp_tun_1a_4uav.asp http...

Jivko did a really good presentation for DBA of SQL Server. To see it, Click here . This posting is provided "AS IS" with no warranties, and confers no rights.

Recommend this web page: http://www.aspfaq.com/show.asp?id=2423 This posting is provided "AS IS" with no warranties, and confers no rights.

This article (Q243586) is probably well known among SQL Server gurus. I just want to say that it is very good ! This posting is provided "AS IS" with no warranties, and confers no rights.

Many people are wondering if they should apply this tempdb fix: http://support.microsoft.com/default.aspx/kb/328551 I recommend that you first decide if tempdb is your major concern. use DBCC SQLPERF(waitstats). Here is an article but you need to...

good article by Brad McGeHee: How to Perform a SQL Server Performance Audit He has written many other interesting articles too. This posting is provided "AS IS" with no warranties, and confers no rights.

I generally like Apress books. This might be an intersting one. I will take a look at it later. The Handbook for Reluctant Database Administrators -- This posting is provided "AS IS" with no warranties, and confers no rights.

This is a very good reference.

I am learning something about the SQL 2005 Analysis Service today. This paper seems to be the best tutorial, IMO. -- This posting is provided "AS IS" with no warranties, and confers no rights.

Isolation level is always an interesting topic to me. I read this paper " A Read-Only Transaction Anomaly Under Snapshot Isolation " yesterday. -- This posting is provided "AS IS" with no warranties, and confers no rights.