Thanks. yes we already checked that from the Regional and Language settings in the control panel and it is exactly the same on both nodes. Should we check any other...

Thanks David!

excel query sounds like a feasible solution and something we can defn look into.

If we used excel query, we would have to do it for each spreadsheet correct?

We need...

To answer the other question:

Yes, the cube is partitioned.

Not sure how many records or how to find out how many records there are in it, but we know that...

We are running an SSIS package that first refreshes a SQL database, processes the data and the data is then fed to the cubes from SQL View. The Job/Package is...

Thank you

Does the VM reserved by SQL have an impact on memory available to other processes?

How does SQL reserve the virtual memory? Can that be controlled in anyway?

Thanks. That helps ..

I know.. the <> !!! 🙁

and it would be okay to add the clustered key to a NC index?

also is there an easy and sure way to...

Okay, but don't the 0 values for seeks indicate that the index is not being used? Thanks.

Here is the table structure-

[testPlanName] [nvarchar](90) NOT...

Thanks!

That clears my confusion. I was also looking at the sysindexes output which put the size for data + NC indexes against the clustered key .. but now the numbers...

Here are the page_count values:

CLUSTERED INDEX 1487953

NONCLUSTERED INDEX1187790

NONCLUSTERED INDEX1545382

NONCLUSTERED INDEX1042577

NONCLUSTERED INDEX1031366

NONCLUSTERED INDEX1037250

NONCLUSTERED INDEX1217052

This does not indicate the clustered...

Okay, I understand and agree completely.

(It was the application team that did it !:w00t:)

What is the next best alternative in our situation now?

or Is there any other way to speed...

That was certainly helpful .. Thanks !

Another qn - Is there a way to tune or force the UPDATE to use row/key locks instead of page/table locks? .. and if...

I am the DBA working with the application team on this, but from my understanding .. the intent is to update the status on a bunch of test results ,...

We are using SQL 2000 (SP3).

The errors started appearing not too long back.

The table actually has a clustered index on ArchiveRowId column

The table has 56 million rows.

Yes, there are error messages logged in the event viewer

SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan 'User DB Transaction Log Backup'' (0x92F67FF98761814EB05AC31CA1A4A562) - Status:...

The interval for Log Shipping is every 15 mins..

The funny thing is the local transaction log backup jobs for other Databases on the destination server are failing randomly , like...