SQL Server Articles


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

SQL Server 7.0 Undocumented Stored Procedures

In this article, I want to tell you about some useful undocumented stored procedures shipped with SQL Server 7.0. sp_columns_rowsetThis stored procedure returns the complete column description, including the length, type, name, and so on. Syntax sp_columns_rowset table_name [, table_schema ] [, column_name] where table_name - is the table name, table_name is sysname. table_schema – is […]

Not All SQL Server Indexes Are Created Equal

If you have much experience with indexes at all, you are probably already familiar with the difference between clustered and non-clustered indexes. But this article is not about them. This article is about whether or not the SQL Server Query Optimizer will use your carefully crafted indexes. You may not be aware of this, but […]

An Introduction to SQL Server Clustering

If your mission-critical SQL Server should experience a motherboard failure, how long will it be down? One hour, four hours, a day, or longer? How much will this cost your business in lost sales or productivity? And perhaps even more important to you, what will it do to your stress level?Being a SQL Server DBA […]

How to Perform SQL Server Log Shipping

The Need for Standby Servers In a perfect world we wouldn’t need standby servers for our SQL Servers. Our hardware would never fail, NT Server 4.0 or Windows 2000 would never blue screen, SQL Server would never stop running, and our applications would never balk. In a partially perfect work, we could afford very expensive […]

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 […]

Data Page Structures in SQL Server 6.5

In this article, I want to tell you about data page structure in MS SQL Server 6.5, which are substantially different that what you currently find in SQL Server 7.0 and SQL Server 2000.There are five kinds of pages in MS SQL 6.5: Data pages Index pages Allocation pages Text/Image pages Distribution pages The size […]

How to Troubleshoot SQL Server 7.0 Installation Issues

Should you have problems installing SQL Server 7.0, review this troubleshooting checklist to find potential solutions. 1. Check the Hardware RequirementsYou should have: Alpha AXP, Intel or compatible platform Pentium 166 MHz or higher (Pentium Pro, Pentium II and compatible) 32MB RAM (minimum), 64MB RAM and more (recommended) 180MB (full installation), 170MB (typical), 65MB (minimum) […]

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 […]

Creating Logins for Databases Restored to a Replacement SQL Server

In planning to migrate our production server from SQL Server 7.0 to SQL Server 2000, we decided to repartition the hard drives, reinstall Windows 2000 Advanced Server, and install SQL Server 2000. To handle the web traffic with minimal interruption, we planned to backup all ten production databases and restore them to a temporary replacement […]

Using One-Way Functions to Protect Sensitive Information in SQL Server Databases

Many DBAs know that their job is no longer simply a matter of delivering the right answers in the shortest amount of time. If the databases hold sensitive information like Social Security numbers, prescription records, medical files, or banking records, new laws can make it a crime to deliver the right answer to the wrong […]
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 |