Most likely, it's locking issues. How long does your synchronization take to finish?

You're welcome.

Database optimization would include performance tuning, and also things like backup schemes (backup size), data-scalability and normalization, storage planning (disk use), etc.

Are you asking about a way to programmatically determine that, or to determine it after it's already done and over with and the code is no longer running?

By default, it will use all of them. You can change that by setting CPU affinity, so yes, you could use 2 out of 43 (that's quite a server!),...

In that particular case, it might use the index, but if so it will probably be an index scan instead of an index seek.

Would StartDate be selective enough...

Jeff Moden (7/30/2008)

---

usman.tanveer (7/30/2008)

---

One of my query is using 4-5 tables using Inner or Left Outer joins.

These tables are the main tables of the Db and contains alot of data....

It sounds like it might work to centralize the database, like you're talking about. How they query the data and how much data will be transmitted at a time...

I just ran this test:

set statistics time on

go

declare @A char(1)

select @A = left(col4, 1)

from dbo.sometable

select @A = substring(col4, 1, 1)

from dbo.sometable

go 100

Execution time was identical for both commands.

Mostly yes.

The order of tests in the Where clause doesn't matter. SQL will ignore that if it wants to.

The order of columns in the index matters, because of the...

How are the clients going to get their data out of your database, assuming you go ahead with that?

Will they have some local application at their site, and connect to...

Yeah, because nobody ever has custom work done on a server, or adds a CPU...

I just found something quite interesting on this question.

I hadn't realized that BOL says, "EXCEPT returns any distinct values from the left query that are not also found on the...

Yes.

Maybe it's a game! If...