SQL Server Articles


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

Comparing the SQL Server 2000 Index Tuning Wizard and the SQL Server 2005 Database Tuning Adviser

Among the regular tasks of any DBA, there’s one thing that we all must find time for: research. In my case, I concentrate my investigation into new tools that streamline the tasks that I already do.With that idea in mind, I started taking a close look at the SQL 2005 Beta, wondering: could tools like […]

A Practical Path Towards the Ultimate Microsoft SQL Server Scalability and Availability

It has become a moot point for database vendors to compete for the highest transaction processing capability in the world. Modern database systems have become so well programmed; even the cheapest system can claim very high performance, given the hardware. The next challenge is high availability. It is interesting to observe that database vendors are […]

Operating System Performance Optimization

Performance Audit Checklist  Operating System Performance Considerations Your Configuration Which OS version are you running? Are the disk partitions formatted using NTFS 5.0? Is “NTFS data file encryption and compression” turned off? Does your server have the latest service pack? Does your server have the most current, Microsoft-certified hardware drivers? Is the Windows Server configured […]

Hardware Performance Optimization

Performance Audit Checklist  SQL Server Hardware Characteristics Describe Here  Number of CPUs  CPU MHz  CPU L2 Cache Size  Physical RAM Amount  Total Amount of Available Drive Space on Server  Total Number of Physical Drives in Each Array  RAID Level of Array Used for SQL Server Databases  Hardware vs. Software RAID  Disk Fragmentation Level  Location of […]

Comparcion Entre Index Tuning Wizard 2000 y Database Tuning Advisor 2005 Beta

Introducción A las tareas habituales de cualquier DBA, existe una que nos debe ocupar nuestro poco tiempo libre: Investigar. En mi caso, la investigación la concentro en nuevas herramientas que faciliten nuestro trabajo o, mejor aún, que los resultados obtenidos puedan ser aplicados con el objetivo de mejorar cualquiera de las actividades que involucran la […]

How to Best Implement a SQL Server Performance Audit

Return to Previous Article in the Series The Final Word on How to Perform a SQL Server Performance Audit If you have gotten this far, you have done a lot of reading. In this final article on how to perform a SQL Server Audit, we will take a look at some best practices about how […]

Scripts for Errorlog Monitoring of SQL Servers

The text for the batch file: errorlog_chk_1.bat ============ Text of the batch file ====================== @echo OFF @if not “%ECHO%”==”” echo %ECHO% rem ******************************************* rem Script : errorlog_chk_1.bat rem Author : Neeraj Nagpal rem Date : 02/01/2005 rem ******************************************* rem Set Local scope and call main proc. setlocal & pushd & Set RET= set SCRIPTNAME=%~n0 set […]

Monitor Your Database Servers with DTS, Part 2: Errorlog Monitoring of SQL Servers

In the first article in the series, I explained the setup of a report that ensures that backups are happening as per the backup policy. In this article, I will explain how to monitor SQL Server errorlog, leveraging the capabilities of DTS. Just in case you have not read the first article, in this series, […]

Ownership Chains in SQL Server 2005

When multiple database objects access each other sequentially, the sequence is known as a “chain.” Although such chains have no independent existence, when SQL Server is traversing the links in a chain, it evaluates user permissions on the constituent objects differently than it would if it were accessing them separately. These differences have important implications […]

Working With Temporary Views Using Common Table Expression in SQL Server 2005

When working with SQL 2005, there are times when you need to perform several aggregate functions, or to define a view that needs to be stored only during the execution of a particular query. A Common Table Expression (CTE) does just that; it helps in the definition and manipulation of query related results that need […]
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 |