^ click above ^

A case is presented in this article showing that the SQL Server internal cost formulas for I/O operations are based on disk access times. The I/O cost values were fixed several years ago. They do not accurately reflect current generation disk drive performance, nor do they reflect the actual cost of in-memory operations. In addition, the SQL Server execution cost model does not properly account for I/O costs on Insert, Update, and Delete (IUD) operations. For small row count operations, the discrepancy between the internal SQL Server cost model and the actual query costs do not significantly affect the efficiency of the execution plan. On large row count operations, the default plan can be substantially slower than an execution plan that accurately accounts for the number I/O operations involved.
Read The Whole Article


Building Wiki Web Sites with ASP.NET and SQL Server
This article describes some of the advantages that Wiki Web sites provide and how you can use ASP.NET and SQL Server to create your own Wiki. You'll learn how to write powerful parsers using the .NET regular expressions class and you'll discover how to add sophisticated search functionality to your Web sites by using SQL Server's Full-Text Search service.

Imagine you visit a Web site that offers information about .NET. You start reading one of the pages about the String class and then realize that the syntax of one of the methods is incorrect. You click the Edit button, update the syntax of the method, update the example that describes how to use the method, and save your changes so that future readers benefit from your contribution. You've just used a Wiki Web site.
Read The Whole Article

Thousands of IT professionals worldwide are answering that question with a resounding “yes.” SQL Server 7.0 provides opportunities to address the four hottest application segments of the data marketplace: line-of-business, data warehousing and data marts, e-commerce, and mobile solutions. SQL Server 7.0 can be your ticket to new markets and revenues, and it can provide new ways to address corporate or organizational objectives and enhance business processes.
Read The Whole Article

1. Check that you use the latest SQL Server service pack.

Because many SQL Server Profiler bugs were fixed in SQL Server service packs, you should
install the latest SQL Server service pack.

To check what SQL Server service pack are you running, see this link:

How can I check what SQL service pack am I running?
Read The Whole Article

NSI Software, Inc. (NSI(R)) today introduced Double-Take(R) for Microsoft SQL Server(TM), a comprehensive NSI software and professional service offering that extends the benefits of data protection to one of the most widely used Microsoft applications. The NSI solution set enhances Microsoft SQL Server native copy utilities by leveraging Double-Take software's ability to replicate all data and non-data changes in real time without the need to take the server offline.
Read The Whole Article

I've used MySQL many times, and the database does live up to its reputation for being easy to use. I've also worked with many corporate databases and can tell you that MySQL is more than adequate for handling the majority of applications databases are used for.
Read The Whole Article