Yes - Thanks Peso and others!

Thanks for all the comments and suggestions.

My approach was as such:

1. Run Server Side Tracing for 15 mins on 5 almost identical dedicated sql servers (Subscribers in Transactional replication). ...

Thanks for all the suggestions.

I was able to fix the problem without adding an index, but just re-writing the query.

It was strange how a very simple change in the query...

Go to:

- Security

- Logins

- Database Access

* Choose the databases you want

Go to Server Roles and make sure the Server role is not System Administrator

Hmm ... maybe my question is not clear enough.

I want to PREDICT how much space I can gain by rebuilding indexes.

I don't want to do REBUILD them ... I want...

I meant that I did not rebuild the index yet. I would like to know (before rebuilding) what would be the gain in space if I actually do rebuild.

The...

Zendada, and Bitbucket - Thank you for the information.

I used the following (as suggested) to fix the problem:

Method 1: Manually delete excess rows and columns

To reset the last cell by...

Have you tried anything yourself?

Have you progressed any?

Can you give us more details?

Are you looking for tables with specific or without specific data types?

If so, you can try this (and select table_name or anything else you need):

SELECT *

FROM Information_Schema.Columns

where data_type not...

Guys,

I have noticed a few things happening with the excel spreadsheet, as I am using this approach:

1. The excel file is increasing in size, even though the data inserted does...

So, your tables have no indexes? Even no clustered index?

I had a table recently with no clustered index, taking up 23GB, and growing every day by 50MB. After...

Zendada, thank you for all the suggestions.

I think I figured it out.

Here is what happened:

I had that DTS package running on my local server. Everything ran fine, data was...

Why don't you want to add an index?

The answer to your question is: depends. It depends on your query.

There are many ways to increase performance of a...

Zendada,

I don't think it is working. I tried it. Even though the DTS package executes with no errors, nothing happens - the original data remains in the excel...

Zendada,

Thank you for the reply - I am still a bit confused though.

My question was referring to the approach used by the original article. If I follow that...