My 2 cents on this issue, If you get an mdf, ldf of a read only database and attach it to your server it will retain the read only properties....

I am getting the same error message, I have an OLE DB source that gets a set of columns from a variable that executes a given stored proc.

The data...

Thanks OPCThree, it worked. Something trivial, but important to learn from this.

Interesting.

Like

Correction:

Select count(*) from Test

will result into 50,

10

here the dataitemids...

yes, ORDER BY Clause will ensure a sorted list.

use group by clause.

http://msdn.microsoft.com/en-us/library/ms177673(v=SQL.90).aspx

select Compnayid,Count( vid) from tablename

group by companyID

My 2cents,

Enable Full text search functionality, Create a Full Text Index, which will organize your data according to your liking Asc or Desc on your choice of columns. Then...

My 2 Cents,

Before you defragment (rebuild or reorganize) those indexes make sure to look at the number of pages. Rebuilding a small index would not give you great performance...

Thank you David & Gail

Interesting article Kendal, I have been using the same dmv as you have mentioned here but with a slight modification and here it is

Select Object_Name(ddps.object_id) TableName

, ddps.row_count #Rows

From sys.dm_db_partition_stats...

Queries run longer due to various factors, as steve mentioned above , it could be due to update blocking by another process.

To find out what query is causing it, you...