Tags » Database Tuning

Indexing Tool : Database Engine Tuning Advisor

Related article : Indexing Tools for Microsoft SQL Server (You might want to read the article before this one to get a better picture)

The other indexing tool available in… 4,560 more words

Programming Language

Indexing Tool : Missing Index Dynamic Management Objects (DMO)

Indexing Tools

When it comes to indexing, Microsoft has two tools built into SQL Server that can be used to help identify indexes that can improve database performance. 3,027 more words

Technology

Oracle 12.2 Cool New Features

As you know, Oracle Open World is over (for me at least), and one of the major topics there was Oracle 12cR2 (or 12.2). It looks like a really cool version, the downside is that is currently available on Oracle cloud only. 1,148 more words

Database Security

The Problem with autotrace

There are few ways to see the execution plan of a SQL statement. One of these ways is the autotrace option in sqlplus. It is a very easy-to-use feature and people use it quite often. 1,312 more words

Troubleshooting

SQL Server: ranking your data

This is the kind of query that kills some servers – ranking.

It’s a bit hard to make programmers understand how important the performance of their code can have a big impact on server speed – they all seems to think that throwing more hardware will solve all world’s problems… unfortunately it does not work that way. 115 more words

SQLServer

SQL Tuning by Example

My previous post that showed a real life troubleshooting was a hit. I guess people like to hear these kind of things, so I decided to write another post, this time a real life SQL tuning. 1,438 more words

Optimizer

Analyzing Performance

People ask me quite a lot about how I analyze performance issues. While I have some guidelines, there is no complete answer to this question. The actions I take depend on the situation, and there are many many different scenarios when talking about performance problems. 1,241 more words

Troubleshooting