SQL Server Performance Tuning

Obtaining Index Usage Information

When building an application there are a number of things that are important.  The first is having a good database design; a database structure that is easy to use and query.  Performance is another, a measure of performance it is how quickly your applications are able to retrieve and update required data.  A key component […]

Max Degree of Parallelism

When SQL Server runs on a computer with more than one microprocessor/CPU or on SMP (a computer-architecture where two or more identical processors can connect to a single shared main memory and I/O and can perform the same functions. In case of multi-core processors, the SMP architecture applies to the cores, treating them as separate […]

How to Create a Comma Separated Delimited Text File Using SQL Server 2008

Database Administrators and SSIS Developers have always come across scenarios where you need to create a comma separated delimited text file for very large tables in SQL Server 2008. Once the delimited text file is generated the files can be compressed and they can be easily FTP to client locations. This is one among the […]

Creating Your Own Custom Data Collections

In my last couple of articles (http://sql-server-performance.com/articles/per/Management_Data_Warehouse_p1.aspx and http://www.sql-server-performance.com/articles/per/System_Data_Collection_Reports_p1.aspx) I discussed the Management Data Warehouse (MDW) a new feature that collects and manages statistics that came out with SQL Server 2008.  In those articles I described how to install the components that make up the MDW, the system data collections, and the history reports that […]

Analyze and Fix Index Fragmentation in SQL Server 2008

It is very common that over time SQL Server tables and indexes tend to become fragmented. The fragmentation generally happens when data within the underlying tables on which an index exists is modified. The data modification basically can be an insert, update or a delete operation. The indexes over time become ineffective because they get […]

Entity Framework Tutorial

aaa

Monitoring Index Fragmentation

A few years ago I started a new job as a DBA with a new group.  This application served the needs of hourly employees across the globe as they clocked in and out of work.  Reports were generated and payroll issued based on the data gathered and collected in this database.  It was a 24/7 […]

SQL Server High-Availability with Virtualisation

SQL Server associated applications and data are often mission-critical to the operation of a business. While protecting SQL Server and its databases is a top priority for IT departments, it’s often not enough. If the applications residing on SQL are not also protected, there is a risk that business operations will be disrupted. The complexity […]

Are Your Indexes Being Used Effectively?

In this fast moving world, data is the heart and soul of any enterprise. As the data is growing very rapidly day by day, the biggest challenge which enterprises face today is to store the data in such a way that it can be retrieved quickly whenever required. The most common thought which comes in […]

Speeding up the Performance of Table Counts in SQL Server 2005

Introduction When we want to get the row count of a table, we use the transact-SQL function count (*).  In the case of large table which may contain millions of rows, it can take a long time to return the row count of the whole table, and that leads to slow performance for the query. Count () function Every DBA know […]
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 |