Good Point!

Are the publisher and subscriber the same version?

There could be issues when you use 2000 vs 7 vs 2005...

Ha! I didn't follow the link so I have a deserved "Ooops!" Cross-posting hits again!

I know I am going to get some heat because of it but hey USA is a free country.

declare @user_id int

select @user_id = 2

;with cte

AS

(

select b.id, b.parent_id, b.name as...

I guess it wants you to update the driver too.

Because OUTER joins are NOT allowed on indexed views you are probably out of luck.

Now, You could create an indexed view on each and then use a "normal" view to...

Sounds like a reindex issue, post back after you finish reindexing...

u5andy (12/23/2008)

---

Hi all!

I'm not all that well versed in SQL and I'm brand new to SQL Server. I'm trying to speed the following code up:

DECLARE @TMP_INCREMENT_DATES table(q varchar(255))

INSERT INTO @TMP_INCREMENT_DATES

...

You may want to revisit those large tables and cluster them. DML performance change significantly with table size and MS recommends to cluster them

ON UPDATE CASCADE is a property of a ForeignKey you should be able to DROP+CREATE the FK constraint.

What error are you seeing ?

dva2007 (12/23/2008)

---

I tried this.

declare @file as varchar(100)

set @file = '\\server01\wcl\Extracts\Executive\LOS-export' + convert(varchar, datepart(yyyy,getdate())) + '-' + right(('0' + convert(varchar, datepart(mm, getdate()))),2) + '-' + right(('0' + convert(varchar, datepart(dd, getdate()))),2) +...

jeffrey yao (12/16/2008)

---

Informative article.

But I am still trying to understand why the transaction isolation level plays a role here. Before a connection is established, there is no isolation level to...

The exported code is the culprit \x0D in character format won't be interpreted by SQL Server as as CR. You need actual CR exported.

Thanks for the clarification.

Here are some things to check for:

- check for "blocking" ?

- Do you have an idea for how many indexes you have on the heaviest written table...

Is the index in ColD being used ?

Is the server overloaded ?

Can you post the execution plan ?

Can you post the DDL of the table ?

.... Too many questions ......