I just noticed that we have not installed SP1, this could probably solve the issue. But I'm on holiday for the next 2 weeks, so it will have to wait...
On my normal table I don't need the index hint because the execution plan will automatically take this index, but in this example, since there is not...
I put the index hint in to make sure that he uses this index, the production table will automatically use this index, but in my example with only 1...
I definitly have WHERE, not AND in the query, maybe it is only in SQL2008. I'll wait and see if someone here on the forum can replicate it on SQL...
Hi All, We just migrated from SQL 2000 to SQL 2008, and on a specific query I'm getting a strange result, I've already work out the it is related to...
Hi All, A question, will more RAM memory reduce I/O activity on the harddisk? probably relative to the amount of RAM memory. But for instance if I...
3 years later, still the same issues [:'(], data has increased to 220GB, CPU to 40%, I/O's: 700 In the mean time we added another array of disks 5x...
There is a job the daily runs the REINDEX & REBUILD (DBCC) actions. But the interesting thing is that the log grows bigger slowly. So now it contains...
Hi all, I have a problem with one of my databases. We have set this database to "simple" recovery mode. However the log is still growing, in a week...
I'm the DBA but I'm not responsible for the server hardware/software setup at our company, and it was decided (against my advice) to use VMWare since...
I've created a maintenance jobs that manually runs DBREINDEX against all the tables. This has helped a bit. To further speed up the process I broke...
SQL Enterprise is a bit to expensive. For that price I can buy a new server and SQL server 2005 standard.
We are running SQL Server 2000 Standard SP4 (8.00.2039) VMWare Infrastructure 3 has some limitation, I can only add 4 cpu's. Since 2xquad cores are...
Optimization jobs run every sunday, but do they rebuild indexes? (standard SQL server maintenance jobs, which fail from time to time due to lack of...
Current performance issues is the increased time it takes to run queries. The problem is that it is a mixed production system with lots of user...
Hi All, You probably see this question alot, but I need some advise about new hardware for our SQL Server which is getting slower and slower. Our...
I am investigating the x64 option, however we are running on an VMWare ESX3 environment and we still need to check if x64 will work on it. The cache...
Hi All, I have about 20 database running on SQL Server 2000 standard and they have a combined size of 150GB, and do about 300t/s. Currently SQL can...
After some searching it seems that SQL Server 2005 Standard edtion enable more the 2GB of RAM, it says OS limit and also says that it is variable AWE...
I have fix RAM settings from 0 to 3600MB, but still he only uses 2GB. Does SQL Server 2005 have the same limitations?
Separate names with a comma.
