Blogs about: Sql Performance

Featured Blog

SQL Server - Understanding Table Hints with Examples

Today we have a very interesting subject to look at. I tried to look for help online but have not found any other documentation besides what we have from the Book Online. Let us try to understand what… more →

Journey to SQL Authority with Pinal Dave

SQL SERVER Interview Questions

nagarajreddy321 wrote 2 weeks ago: What is the difference between clustered and a non-clustered index? A clustered index is a special t … more →

Tags: Database, SQL, SQL Authority, SQL Constraint and Keys, SQL Cursor, SQL Download, SQL Index, SQL Interview Questions and Answers, SQL Joins

SQL SERVER - Clustered Index on Separate Drive From Table Location — 3 comments

pinaldave wrote 2 weeks ago: How to improve performance of SQL Server Queries is a common topic of discussion among many of us. M … more →

Tags: Best Practices, Pinal Dave, SQL, SQL Authority, SQL Constraint and Keys, SQL Index, SQL OPTIMIZATION, SQL Query, SQL Server

SQL SERVER - Effect of Normalization on Index and Performance — 3 comments

pinaldave wrote 3 weeks ago: Of late, I have been using Twitter quite frequently, and I am gradually discovering its usefulness. … more →

Tags: Pinal Dave, SQL, SQL Authority, SQL Index, SQL OPTIMIZATION, SQL Query, SQL Server, SQL Tips and Tricks, T-SQL

SQL SERVER - Performance Counters from System Views - By Kevin Mckenna

pinaldave wrote 3 weeks ago: I just love social media and all the new concepts of Web 2.0. There are bloggers who are overwhelmed … more →

Tags: technology, SQL Server, SQL, SQL Query, SQL Tips and Tricks, SQL Authority, Pinal Dave, T-SQL, SQL Scripts

SQL SERVER - Introduction to SQL Server 2008 Profiler

pinaldave wrote 2 months ago: Introduction SQL Server Profiler is a powerful tool that is available with SQL Server since a long t … more →

Tags: Pinal Dave, SQL, SQL Add-On, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, sqlcmd, T-SQL

SQLAuthority News - Troubleshooting Performance Problems in SQL Server 2008

pinaldave wrote 2 months ago: It’s not uncommon to experience the occasional slowdown of a database running the Microsoft SQ … more →

Tags: Pinal Dave, SQL, SQL Authority, SQL Documentation, SQL Download, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News

SQL SERVER - Automated Index Defragmentation Script — 8 comments

pinaldave wrote 3 months ago: Index Defragmentation is one of the key processes to significantly improve performance of any databa … more →

Tags: Best Practices, Database, Pinal Dave, reader's contribution, SQL, SQL Authority, SQL Index, SQL OPTIMIZATION, SQL Query

Indexing for performance

matt wrote 3 months ago: Not to publicly admit obsessions with people, but I think I’m in love with Kimberly trip and Paul … more →

Tags: T-SQL, DevConnect2009, devconnections 2009, kimberly tripp

SQL SERVER - 2008 - Location of Activity Monitor - Where is SQL Serve Activity Monitor Located

pinaldave wrote 3 months ago: I received question from Aloke Sinha after reading my article SQL SERVER – 2008 – Activi … more →

Tags: Pinal Dave, Reader's question, SQL, SQL Add-On, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, sqlcmd

SQL SERVER - 2008 - Activity Monitor is Empty - Fix Activity Monitor for All Users — 3 comments

pinaldave wrote 3 months ago: This article is outcome of the technical discussion of activity monitor and its behavior with my fri … more →

Tags: technology, SQL Server, SQL, SQL Query, SQL Error Messages, SQL Tips and Tricks, SQL Authority, SQL Security, Pinal Dave

SQL SERVER - 2008 - Optimize for Ad hoc Workloads - Advance Performance Optimization — 9 comments

pinaldave wrote 3 months ago: Every batch (T-SQL, SP etc) when ran creates execution plan which is stored in system for re-use. Du … more →

Tags: Best Practices, Pinal Dave, SQL, SQL Authority, SQL OPTIMIZATION, SQL Query, SQL Scripts, SQL Server, SQL Stored Procedure

SQL SERVER - AWE (Address Windowing Extensions) Explained in Simple Words

pinaldave wrote 3 months ago: I was asked question by Jr. DBA that “What is AWE?”. For those who do know what is AWE o … more →

Tags: technology, SQL Server, SQL, SQL Query, Database, SQL Tips and Tricks, SQL Authority, SQL Add-On, Pinal Dave

SQL SERVER - Practical SQL Server XML: Part One - Query Plan Cache and Cost of Operations in the Cache — 2 comments

pinaldave wrote 3 months ago: I am very fortunate that I have friends like Michael Coles. Michael Coles is SQL Server and XML expe … more →

Tags: technology, SQL Server, SQL, SQL Query, Database, SQL Tips and Tricks, SQL Authority, Pinal Dave, T-SQL

SQL SERVER - Interesting Observation of ON Clause on LEFT JOIN - How ON Clause Effects Resultset in LEFT JOIN — 13 comments

pinaldave wrote 3 months ago: Today I received email from Yoel from Israel. He is one smart man always bringing up interesting que … more →

Tags: Pinal Dave, Reader's question, SQL, SQL Authority, SQL Puzzle, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks

SQL SERVER - Profiler - Adding Filters - Observation on CPU Load — 1 comment

pinaldave wrote 3 months ago: Today I am blog about something which I found recently while working with SQL Server Profiler. Profi … more →

Tags: technology, SQL Server, SQL, SQL Query, SQL Tips and Tricks, SQL Authority, SQL Add-On, T-SQL, sqlcmd

SQL SERVER - Difference Between Union vs. Union All - Optimal Performance Comparison — 7 comments

pinaldave wrote 3 months ago: More than a year ago I had written article SQL SERVER – Union vs. Union All – Which is b … more →

Tags: Pinal Dave, SQL, SQL Authority, SQL OPTIMIZATION, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T-SQL

SQLAuthority News - Ahmedabad User Group Meeting February 21 2009 — 2 comments

pinaldave wrote 4 months ago: We had Ahmedabad SQL Server User Group meeting on February 21, 2009 and it was wonderful to see so m … more →

Tags: MVP, SQL, SQL Authority, SQL Index, SQL OPTIMIZATION, SQL Query, SQL Server, SQL Tips and Tricks, SQL User Group

SQL SERVER - Observation - Effect of Clustered Index over Nonclustered Index — 8 comments

pinaldave wrote 4 months ago: Note: This article is re-write of my previous article SQL SERVER – Observation – Effect … more →

Tags: Pinal Dave, SQL, SQL Authority, SQL Constraint and Keys, SQL Index, SQL OPTIMIZATION, SQL Query, SQL Scripts, SQL Server

SQL SERVER - Technical Articles - Performance Optimizations for the XML Data Type in SQL Server 2005

pinaldave wrote 4 months ago: I always wanted to learn XML and its usage. My friend and fellow MVP Jacob Sebastian is expert in XM … more →

Tags: technology, SQL Server, SQL, SQL Query, SQL Tips and Tricks, SQL Index, SQL Authority, T-SQL, SQL Documentation


Have your say. Start a blog.

See our free features →

Related Tags
All →

Follow this tag via RSS

Find other items tagged with “sql-performance”:
Technorati Del.icio.us IceRocket