Engine Watch

Many people thought that lock grant in SQL Server was FIFO to avoid starvation problems. Think about it. If someone is able to get in front of you in a super market checkout queue, you may never be able to get out of the store. My friend Santtu who...

In SQL 2005 we have done quite a bit of internal improvements in tempdb scalability. These include: Caching of IAM and first data page for temp table and table variables. Improved allocation page latching protocol so that we use UP latch less...

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.

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

This is a very good white paper on this important topic http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx

Somebody asked me this question. So here it is: SQL 2005 still supports the following three ways to report data and log space usage for a database: DBCC SQLPERF ( LOGSPACE ) can tell you the log size and used size. sp_spaceused for space...

Click the following link to learn things like: TOP, RANK, ROW_NUMBER, PIVOT, Recursion... http://www.awprofessional.com/articles/article.asp?p=327394&seqNum=7&rl=1

Unless your workload changed significantly, shrink file is not going to help you because tempdb will just grow back if a query needs that amount of free space. So a better way is to identify the query and try to optimize that, maybe by adding an index...

<Rewrote from my newgroup post> Case: 4GB database with two "big" tables: 1.5 million records, table with almost 1 million records, and each month, import about 300,000 records, also delete some old records. database goes up to 5 or 6 GB and...

Found two useful things on the internet today: Planning for Consolidation guide from microsoft: http://www.microsoft.com/technet/prodtechnol/sql/2000/plan/sql2kcon.mspx A guideline from network appliance: http://www.netapp.com/tech_library...

The following KB: http://support.microsoft.com/kb/328551 talks about how many files the tempdb database should have. Is there similar suggestion for regular databases? Here is my thought: It is hard to predict how many files are needed per file group...

http://sqldev.net/articles/WaitTypes.htm

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

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

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

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

Temp table is no different from regular tables. We may choose either page or extent allocation to optimize performance and space utilization. The kinds of operation affect how we choose: select into bulk insert create index insert...

This is my first blog posting for 2006. I went to china for a almost whole month at the end of 2005. I went to several cities. I presented at the SQL 2005 Launch Event in china. I had a great time.

a must read: http://www.microsoft.com/technet/prodtechnol/sql/2005/tsprfprb.mspx

These guys works with the largest SQL Server databases: http://blogs.msdn.com/sqlcat/

This could be pretty useful: a build chart lists all of the known KB articles, hotfixes and other builds of SQL Server 2000 that have been released: http://www.aspfaq.com/sql2000Builds.asp

What an exciting five years. Areas I personally contributed: snapshot isolation and RCSI; page allocation and free space management; tempdb and a few other smaller things.

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

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.