SQL Server Articles


Categories : Performance | Audit | Business Intelligence | Clustering | Developer | Reporting | Windows Server | SQL Azure | Powershell | ASP.NET | Other .NET

A Script to Find SQL Server Stored Procedure Dependencies

$0You’ve searched through MSDN, Google Groups, and all along the yellow brick road of developer web sites looking for a way to generate a sql script for your stored procedures in order of dependency, but to no avail. Why? You, like myself, prefer not to see a bunch of error messages in Query Analyzer when […]

SQL Server Upgrade Recommendations and Best Practices Part 2: SQL Server 6.5 to 2000 Critical Upgrade Decisions and Redundant Upgrade Architecture

Introduction – SQL Server Upgrades The first article of the series, Part 1 – Upgrade Overview and Project Planning, detailed the business justification for upgrades to SQL Server 2000 related to TCO (Total Cost of Ownership), automation capabilities and new features from both the Business and DBA perspectives. The next portion of the article outlined […]

SQL Server Replication from 6.5 to 2000

These are the steps needed to successfully establish transactional replication from SQL Server 6.5 to 2000. They has been tested and are known to successfully work. This article assumes you have some previous experience with SQL Server replication. Prepare publishing server/database Set subscribing servers Update sp_articleview in master (6.5) Publish tables Configure security on 2000 […]

SQL Server Join Nastiness Tamed: Finding Joy In The INNER LOOP

Microsoft SQL Server sometimes uses hash and merge joins when querying large tables when uncomplicated nested loop joins would result in better performance and less server impact. In many such cases, query times go from many milliseconds to many seconds because hash table joins require that large amounts of data be processed and temporarily stored, […]

Making the Move from Sybase to SQL Server

I was involved in a recent project to migrate a Sybase database to Microsoft SQL Server 2000. So the experience I gained by working on this project has led me to write this article to show Sybase database administrators (DBAs) and managers the steps that should be followed to migrate from Sybase databases to SQL Server 2000. Differences […]

How to Connect to SQL Server from Visual FoxPro

In Microsoft public newsgroups, I’ve noticed a recent increase in the number of questions that deal with how to connect from Visual Foxpro to SQL Server, and the problems related to making this connection. So I’ve decided to write this article  to cover such an important topic.There are two functions that can be used to […]

How Updates are Performed in SQL Server 6.5

SQL Server 6.5 can use two different methods to update records, depending on the circumstances. They include: Direct Update Deferred Update Each method affects performance in a different way, as we shall see in this article.A Direct Update includes three different methods of modification: In-place update On-page delete/insert Full delete/insert Think of these above three […]

Best SQL Server Performance Tuning Tips

This website offers hundreds of different ways to tune SQL Server for optimum performance. But as you read over the many tips, you might be asking yourself, which tips offer the most performance gains for the effort expended. As you can imagine, it is not always easy to know which tips might help boost your […]

How to Identify and Delete Duplicate SQL Server Records

Recently, I was asked to help someone clean up their database after they had double loaded an import file. The problem they were having in identifying and deleting the duplicate information was the fact that a timestamp is applied to each row of data as it is inserted into the table. While the rest of […]

Create Your Own SQL Server Job Management System

Having had the honor of working for quite a few companies that did not have the resources to buy any of the nice SQL Server toys that exist out there, or were willing to put an email  client on the servers, I have found myself spending a good deal of time each morning checking the […]
Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |