From SQLServerCentral – In this article Randy Dyness shows you how to avoid temp tables whenever to maximize the performance of your queries.Free registration is required.

One of the most overlooked areas in optimizing SQL Server and Transact-SQL is the recompilations of stored procedures. Recently started looking at this issue where I worked and stored procedures gathered from other clients and I noticed that there is an issue with SQL developers not taking recompile

This article describes how to configure SQL Server to use more than 2 GB of physical memory. Microsoft SQL Server 7.0 and Microsoft SQL Server 2000 dynamically acquire and free memory as needed. When you run multiple instances of SQL Server on a computer, each instance dynamically acquires an

By Joe Wilcox – Microsoft will launch Commerce Server 2002, new software for building e-commerce Web sites and one of the first products supporting the company’s .Net strategy.Commerce Server 2002 will allow Web site operators to manage catalogs of products and services and to tailor the con

by Randy Dyess – This article will describe the use of the table-level locking hints and general table hints that are available to Transact-SQL developers and SQL Server database administrators, and attempt to provide scenarios on when you should use a particular hint. You should note that SQL Serve

SQLCache is an OLE DB data provider with an in-built and fully tunable data cache. This means SQLCache can be used with traditional database queries made within web pages without the need for any code changes or the learning of a new Application Programming Interface (API). When SQLCache is used to

By Brian Moran – I discussed the recent update to SQL Server Books Online (BOL) in “Check Out the Updated SQL Server BOL”, and I encouraged you to download the new version ASAP. Have you ever wondered how Microsoft finds out what changes the company needs to make to BOL? Many requests for changing o

By Drew Georgopulos – With this 10-Minute Solution, you will meet the challenges of providing a manageable development environment. You will develop an extract of the production environment that is just like production in every way but size, enabling developers to work with a representation of the d

by Randy Dyess – Learn the the pros and cons of using SQL Server temp tables. Also find out how to optimize temp tables, assuming you can’t find a way to avoid using them.

From SQLTeam – This article comes to us from Tim Young. Tim writes “One of the (few) very handy things about Access is the cascade delete function. If you delete a record from a parent table, all relating records in the child tables are also deleted. I couldn’t find any way of doing this in SQL Serv