Engine Watch

database engine technology and SQL Server

  • Engine Watch

    Is lock grant in SQL Server First-In-First-Out (FIFO)?

    • 8 Comments
    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...
  • Engine Watch

    [SQL Server 2005] TEMPDB optimization

    • 3 Comments
    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...
  • Engine Watch

    SQL Server admin books

    • 3 Comments
    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.
  • Engine Watch

    Q & A: what to do with third party tables in master db

    • 3 Comments
    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...
  • Engine Watch

    SQL 2000 DBA resource

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

    Microsoft SQL Server 2000 Index Defragmentation Best Practices

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

    [SQL 2005] Q: How to find out how much space is used in database ?

    • 2 Comments
    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...
  • Engine Watch

    SQL 2005: TSQL enhancements

    • 1 Comments
    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
  • Engine Watch

    SQL 2000: what to do if tempdb grows to be very big

    • 1 Comments
    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...
  • Engine Watch

    Beginner: Manage database file size

    • 1 Comments
    <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...
  • Engine Watch

    SQL Server 2000 Sizing and Capacity Planning

    • 1 Comments
    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...
  • Engine Watch

    SQL 2000 and 2005: how many files to create in a database

    • 1 Comments
    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...
  • Engine Watch

    SQL Server 2000 Wait Types

    • 1 Comments
    http://sqldev.net/articles/WaitTypes.htm
  • Engine Watch

    most often used dbcc commands

    • 1 Comments
    Do you know them? http://www.joesack.com/iprepindexdbcc.html
  • Engine Watch

    data partitioning in 2005

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

    More about FIX: Concurrency enhancements for the tempdb database

    • 1 Comments
    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...
  • Engine Watch

    SQL Server 2000 I/O Basics

    • 1 Comments
    Very good article on technet: http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlIObasics.mspx
  • Engine Watch

    temp table allocation in SQL 2005

    • 1 Comments
    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...
  • Engine Watch

    2006 greetings

    • 0 Comments
    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.
  • Engine Watch

    White paper Link: trouble shooting SQL Server 2005 performance problems

    • 0 Comments
    a must read: http://www.microsoft.com/technet/prodtechnol/sql/2005/tsprfprb.mspx
  • Engine Watch

    introducing the SQLCAT team blog

    • 0 Comments
    These guys works with the largest SQL Server databases: http://blogs.msdn.com/sqlcat/
  • Engine Watch

    Link: SQL Server 2000 Build Chart

    • 0 Comments
    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
  • Engine Watch

    SQL 2005 shipped (11/7/2005)

    • 0 Comments
    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.
  • Engine Watch

    shrinking database files ?

    • 0 Comments
    Good reading http://www.karaszi.com/sqlserver/info_dont_shrink.asp
  • Engine Watch

    isolation level

    • 0 Comments
    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.
Page 1 of 2 (46 items) 12