Hi,
For the symptoms described, can be a bad cardinality issue or parameter sniffing issue.
Basically, you ended with a wrong execution plan that causes the unexpected delays in your...

Hi Sue,
Thank you for your input. That was a really cool story. I don´t know if the design of the page was on intention or it really comes from...

Hi,
Yes, with that percentage, your choice is to REBUILD that index.
By the other hand, No. You can't have two indexes with the same name.
I suggest to check...

Hi Sue,
No, I did not. Thank you for the advice!
I will try to reproduce the issue on my development environment.

Regards.

Interesting topic.
I allways believed that the DBA´s are adicted to the peril, the adrenaline, the caffeine shot. Because if not, I don´t find another reazon why we can cut...

Hello all,
This was very interesting ideas exchange about how often, defrag or not defrag indexes... having in mind that this was generated by a performance issue, I am sharing...

Hi,
The most common  factor for slow querys are:
1.- Low space on tmbdb. This is solved by increasing the space. Or allocating them in a high speed disk drives...

Hi,
The exection plan for each stored procedure or querys, resides on the master DB. That´s why when you restored your DB in another server, this execution plans have to...

Hi,
In my career, I have participate in several ERP implementations with different roles: user, key user, developer, BPM and DBA. Those implementations have different level of customizations. In fact,...

Hi,
Like you, I have evaluated APEX and REDGATE tools to manage, monitoring and develop, in our SQL servers. After several weeks of trials, finally we choosed APEX full suite....

Hi Ben,
I´m convinced that a good suit will never replace you skills at work. But  also, I´m convinced that you must feel comfortable, and powerfull,  with you attire. Because...

Hi Dave,
You are right! It was my mistake. I mean, we changed our RAID 5 to RAID 1.
thanks for the correction.
Miguel.

Hi Steve,
In my case, I started to work with db servers using Informix. It was used by our erp system in a hp autoraid. It worked very fine and...