Just for curiosity, did you open the CSV file in notepad or some text editor? IIRC Excel won’t show the single quotes but text editors will do.

What else (except for SQL Server Database & Analysis Services) is running on the box? Please stop unnecessary services.

If you read the error message, it’s pretty much clear SSAS is...

I guess it’s for Logical Grouping of collations only.

Per BOL:

Binary collations sort data based on the sequence of coded values defined by the locale and data type. A binary collation...

Use Export - Import Wizard and select the destination with ‘ODBC providers’ (attaching screenshot). Optionally save the export task as SSIS package, edit it, schedule it and run it.

May I ask why you are passing values to the database (stored procedure) in such a horrible way? Passing table objects would make your SP much cleaner and also you...

Twisted the query a bit... same output & same execution plan... but looks nicer to me... any thoughts most welcome

Version 1:

DECLARE @test-2 TABLE

(

group_id ...

Few articles here for investigating the issue...

Error message when you execute a linked server query in SQL Server: "Timeout Expired"

http://support.microsoft.com/kb/314530

Troubleshooting: Timeout Expired

http://msdn.microsoft.com/en-us/library/ms190181.aspx

If you are a DBA, what is stopping you from running index rebuild / defragmenting it? IIRC vendors or third party licensing agreements stop us from design changes (add tables,...

May I ask how did you figure out it’s a SharePoint database?

But it’s still active...

I agree with jack. But I have few questions, answers to which might change my course of action.

•How many applications are there in total?

•Are these home (local) developed applications...

When we are splitting hairs anyway, should I add we can have only one Primary Key (simple or composite) on a table? This limitation is not applicable to Unique Keys.

It’s very well suited on OLTP design. However I would differ in opinion for OLAP / DW designs.

First of all, I would also recommend you to use ‘sa’ for admin tasks only. And it should be shared with minimum people (involved in DBA activities).

How to: Change...

<blocking-process> is the culprit and <blocked-process> is the victim.