The tag has no wiki summary.

learn more… | top users | synonyms

2
votes
1answer
940 views

Why does a mysql query, that requires copying to tmp table, randomly sometimes consume 100% CPU during several seconds?

I have some crazy SQL queries in my PHP scripts which badly need some optimization. However the question is NOT about how to optimize them. These queries have a lot of "join"s and some bizarre "order ...
0
votes
1answer
298 views

Issues with "There is already an object named 'xxx' in the database'

I'm fairly new to SQL so this may be an easy mistake, but I haven't been able to find a solid solution anywhere else. Problem is whenever I try to use my temp table, it tells me it cannot be used ...
1
vote
1answer
181 views

Why is SQL Server profiler not capturing Global Temporary Table creation in some cases?

I need to reverse engineer are report from a third party application into SSRS, so that I can make some changes for our users. I have captured the SQL that is used by the report, however the query ...
0
votes
1answer
615 views

Index rebuild stored procedure fails while calling temporary table

SQL Server 2008 Enterprise on Windows Server 2008 Enterprise Cluster that is used to support SharePoint 2007 and 2010. We have a weekly index rebuild job that first checks the index fragmentation, and ...
1
vote
1answer
2k views

MySQL Created_tmp_disk_tables

I'm trying to improve the performance of our primary MySQL server. It's a Dual Quadcore Intel X5450, with 8GB of RAM. It's a dedicated MySQL box. I'm only in the beginnings of configuring it, so ...