to get a meaningful answer, you need to provide the CREATE TABLE definitions for Invoices and Payments, and the INSERT INTO statements for your data;

i see that you pasted some...

my outside of the box comment:

wouldn't it be better to tune the process that seems slow so that it performs better?

what is that process doing, and does it involve a...

dense_rank, like all the windowing functions like row_number,ntile and rank all start with one, so just add your some number to it to get your starting number

select

dense_rank() over...

there's a codeproject which adds a CDC equivalent to a standard edition SQL server installation you could look at as well:

it creates a utility schema instead of a cdc schema.

http://standardeditioncdc.codeplex.com/

i also remember that if you apply column level permissions to a table for user or group, and leave one of the columns /deny one of them, then select *...

i think there's a couple of factors here:

queries and indexes need to be optimized, and people having permissions to do ad hoc queries when they are not supposed...

if you are getting "client not authenticated" , that means you already have connectivity to the mail server, because it's returning errors.

i think "client not authenticated" could mean one of...

i would go with one app=one database.

it sounds like they have four suites of tables related to a given functionality.

with the current planned design, at some point, you can be...

grant has a great point about owning the code;

if i give you the code, your next questions are going to be "I have images in the database , how...

don't arbitrarily remove an application or code from doing the work for you; that is what they are designed to do.

the code to upload the images/blobs in a programming language(the...

nice effort!

just as a more streamlined form, you don't need a cursor to generate the same results:

you can do it as a single set based operation instead:

SELECT

object_schema_name(OBJECT_ID) as SchemaName,

object_name(OBJECT_ID)...

also, because of differences in the SQL engine's optimizer between versions, if you upgrade from 2005 to 2008R2 like you said, at a minimum you need to updating statistics,...

we'd need to see the actual execution plan to see if you can make it faster;

I think what Sean Lange referred to, you want to try and convert the ...

can you show us all the indexes on w_entity_document_test_new and the actual execution plan?

did your covering index include all teh columns in the query?

ie

CREATE INDEX IX_tezt

ON w_entity_document_test_new ...

Greg Snidow (1/4/2013)

---

Lowell (1/4/2013)

---

you need a Calendar table of some sort which gives you the arraay of all possible months;

from that you change your query to select from that table,...