I found this link but it looks like I have to have an account to download it but I don't have one.  I'd have to reach out our GIS department.

Antares686  I appreciate this article, many years after this post I found it and I just applied that solution in our stage environment.  Working like a charm.

Thank you.

Oh I see, I knew my numbers were not correct but I wasn't sure why since I have limited knowledge on this topic.  Is there a way to convert the...

Sue_H,

I did created a format file, when I use that the file gets exported but it's empty, when I don't that's when I get a message that the file is...

Thanks for the advice, I remove the COALESCE and it improve the query by a few three seconds. Unfortunately, I do have to have all those columns.

Very interesting article and indeed very clever. I will definitely use this sometime in the near future.

Awesome work.

You can check the log increase size by running the query below. This T-SQL is part of a script that Patrick Akhamie wrote. I don't have his URL...

Definitely looking deeper before jumping to conclusions really helps. Staying calm is hard to do when you can't access your production environment. In this experience, the solution was...

Finishing up scripts in the background without any notification to the user, that's nice Microsoft.

Check the sql provider, you are using SQLINCL11 try using "SQL Server Native Clienct 10.0" and see if it works. I have ran into that message before and...

Evil Kraig,

Since my initial post we have developed an approach to those issue. We have started developing a data warehouse where we're extracting the needed transactions. We...

Lowell,

Thank you so much for the response and very quick response. I tried this and it work but I had to add the user to the public group for...

We're planning to do all sorts of aggregation and select statements. The main tables that I'm talking about are recording financial transactions (payments and invoices mostly but also reversals...

Honestly from what you described the time sounds about as good as it is going to get. Assuming roughly 50% of your rows are "ON" then you are selecting about...

The actual select statement is as follows:

Select * from tablename where columnname = 'OFF' (this value is either ON/OFF).

The only index set on the table is on the primary...