SQL Server Articles


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

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

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

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

Start Preparing Today for the SQL Server 2000 Enterprise Certification Exam

If you plan to take the upcoming “Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition” (Exam 70-228) exam, which is scheduled to be released in January 2001, you will want to start preparing now.I has fortunate enough to be invited to take the beta test for this exam last November, and while I […]

An Exclusive Interview with Author Fernando Guerrero On How to Get the Most of ADO.NET and SQL Server

Fernando Guerrero, SQL Server MVP (Most Valuable Professional), is the author of the Que book, Microsoft SQL Server 2000 Programming, and is currently writing a book on ADO.NET and SQL Server for Apress. He is the Principal Technologist and SQL Server Product Consultant for QA, which is the leading IT training company in the U.K. […]

SQL Server 6.5 Useful Undocumented Stored Procedures

In this article, I want to tell you about some useful undocumented stored procedures shipped with SQL Server 6.5. sp_fixindex This stored procedure can be used to fix a corruption in a system table by recreating the indexes on the system table. This is an example: EXEC sp_fixindex pubs, sysindexes, 2 sp_lock2 As a SQL […]

Compare SQL Server Databases with sp_CompareDB

Editor’s Note: Not only has this author produced a very useful stored procedure to compare SQL Server database structure and data, his code provides valuable insights in to how to write advanced Transact-SQL code. This article include much of the thought process used when the author created the sp_CompareDB stored procedure. Even if you don’t […]

Useful Undocumented SQL Server Extended Stored Procedures

An extended stored procedure (xp) is a dynamic link library that runs directly in the address space of SQL Server and is programmed using the SQL Server Open Data Services API. You can run extended stored procedures from the Query Analyzer, for example, just as you would normal stored procedures. Extended stored procedures are used […]

Useful Undocumented SQL Server Extended Stored Procedures

An extended stored procedure (xp) is a dynamic link library that runs directly in the address space of SQL Server and is programmed using the SQL Server Open Data Services API. You can run extended stored procedures from the Query Analyzer, for example, just as you would normal stored procedures. Extended stored procedures are used […]
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 |