Kuma, that is an AWFUL lot of free help you are seeking. Those are very complex queries, the table and indexing structure is unknown, data volumes and distribution is...

I'd love to do the forensics - sounds like interesting stuff. However, I am completely backed up for the forseeable future. Sorry!

If you are lucky and have a...

First thing I would do is compare the original database's structure to the upgraded one. Look for missing indexes.

Also, try updating statistics and also possibly doing a reindex/rebuild of...

kaykay005 (5/14/2008)

---

Hi ,

Our company had an Reporting Server which runs very slow. I have put some counters and run System Monitor. And the results are below.

...

GOD how I LOVE packaged app vendors!!! They make me soooo much money dealing with their horrid performance! 😀 Part of the problem is that they will build...

julia.nicholas (5/21/2008)

---

I'm still having issues however with my trans log filling rapidly on occasion and would like to enlist the services of a professional SQL guru who can help me...

[rant on]

Just a general rant here, but it continually amazes me how companies can assign untrained, inexperienced staff to manage their corporation's data in SQL Server. No wonder we...

I am not sure anyone here is espousing NOT using multiple files to spread the IO load and capacity. By all means do it since you seem to be...

As a consultant, I am continually...

HanShi (5/21/2008)

---

The discussion becomes very interesting. I didn't know that NOLOCK can cause so much issues.

But when I read the BOL I read the following "NOLOCK: Does not issue any...

Fixing poorly written queries and finding indexing opportunities will almost certainly provide WAY more benefit than worrying about how many files to use in a file group. 🙂

Grant Fritchey (5/19/2008)

---

Itzik Ben-Gan gave a presentation last year at the PASS summit that showed the same query getting different results with very small data sets, all because of NOLOCK....

Assuming you are copying the 900M rows to a different physical device, compare the IOStalls between the files during access for this query. It could be simply that. ...

1) Did you show the xml query plan or all text plan and verify that the query was doing partition elimination and only reading the march partition?

2) Does the fragmentation...

A LOT of stuff happens when you issue a simple SELECT statement! While the select is running, you certainly wouldn't want someone to alter the table underneath you and...