The real question is: why are you saying that there is write performance problems ?

ps (12/22/2008)

---

This part of the query is culprit.

You just need to omit this condition. I guess u...

This is kind of a very open question. We can provide you with solutions to any problem you may encounter but replication is a very vast subject to be explained...

mshah23 (12/16/2008)

---

We have recently upgraded to SQL Server 2005 and now we are facing a very High Context Switches/sec on SQL Server 2005.

It is touching 8000 all the...

Also UPDATE STATISTICS on very large tables could be a double-egde sword if there is data skewness ... You may want do a FULLSCAN for those cases.

If you alter a view while users are connected you should also run sp_refreshview @viewname = 'viewname' 😉

This is a shot in the dark but the First think I believe you should do is to make sure you have "windows" patched at the same level in both....

timothyawiseman (12/13/2008)

---

I am trying to find the best way to speed up certain counts from a table. Is there a good way to index a table to assist with...

Seems to me that your real problem is a design issue.

Supposed you have a table of "scheduled" appointments table with (begin_datetime, end_date, salesman_id, appointment_id)

Whatever is not on that table means...

The_SQL_DBA (12/15/2008)

---

Well, we have decided not to put the actual video into the database, as we want to have control over the amount of data that actually goes into the...

Excellent war story.

I think Rbarryyoung is right on the money. I believe that the lack of explicit transaction demarcation is the real problem.

Do you mind specifying explicit "begin tran"/"commit...

Rob X Miller (12/9/2008)

---

😀

I have a question about the DBReINDEX.

We have a really nice MS Access DB that uses linked tables to SQL Server 2005. Having just started, I ran...

Linked servers do not require the use of "openrowset/openquery/opendatasource".

You may want to try that instead.

Can you post examples of destination table and source xml file?

With Operowset you can do the parsing on SQL Server itself:

INSERT Table

SELECT CONVERT(xml, BulkColumn, 2)

FROM...

rshafer (12/9/2008)

---

I'm trying to insert multiple rows using the T-SQL below. Is there a more efficient way to do this? I've read a couple posts on here about...