By Johnny Papa – In this month’s column I’ll demonstrate four techniques that can be used to either improve your SQL Server™-based application’s performance or improve its scalability. I’ll examine the use of LEFT JOINs, CROSS JOINs, and retrieving an IDENTITY value. Keep in mind that there is no ma

by Brad M. McGehee – The previous weekend, I had spent most of it working, upgrading a SQL Server 7.0 cluster to a SQL Server 2000 cluster. Fortunately, the rather complex upgrade went without a hitch. What made the upgrade complex was that the cluster held a 31GB ERP database that was used on a 24/

by Anil Desai – Queries work well if the databases are designed correctly. Here’s what you need to know to build the foundations for your SQL Server databases.

SQL Server Views don’t support the ORDER BY clause, but that shouldn’t stop you from bringing order to your data. This article teaches you how to sort the results of a View, despite this small limitation.

In this tutorial you are going to learn everything in detail step by step you’ll ever want to know about inserting binary data ( images, zip files etc ) into database. This is actually first of the three articles I am going to write on manipulating binary data in the database. After this article you

Welcome to SQL Server Magazine’s monthly, Web-only series of SQL Server tips brought to you by the Microsoft SQL Server Most Valuable Professionals (MVPs). Here are a few of the questions being answered: How do you copy permissions from a user to a database role or vice versa?How do y

Web-based SQL Server 2000 Enterprise Manager. Create, add, edit, delete, and administer all aspects of your SQL Server databases online. Creates completes ASP Insert and Update codes for your tables. Builds Stored Procedure Search Engine automatically.

By Brian Moran – Microsoft is relaunching a controversial licensing model called Licensing 6.0 that will change the way you buy and license SQL Server. The company is offering deeply discounted promotional prices during the transition period, which ends July 31, so you have about 7 weeks to decide w

by Andrzej Kozlowski – Like a lot of database administrators who manage many SQL Server databases, I have problems with maintenance and administration tasks. Some of these are massive jobs, which have to be created and maintained to be sure that databases are robust and reliable. One of the tools I

This article by SSWUG columnist Don Hite will describe the SQL server 2000 enterprise editions log shipping process and provide you with a quick background on it. Log shipping is particularly useful when a primary SQL server’s database or the server itself fails. Such failures can greatl