It's been a couple of days, Clint, and I'm just following up... are you all set on this?

Extent Fragmentation is unreliable... read about it in the BOL listing for DBCC SHOWCONTIG.

The best thing to go for, IMHO, is a very high scan density (95+) and a low...

krayknot (10/16/2008)

---

Use the script below

IF EXISTS (SELECT 1

FROM INFORMATION_SCHEMA.TABLES

WHERE TABLE_TYPE='BASE TABLE'

AND TABLE_NAME='tablename')

...

I just keep reloading the ol' bucket of pork chops and I replace the bands in the sling shot every 500 shots or every week... whichever comes first. Right...

oraculum (10/16/2008)

---

here are the results from the two querys...

am wondering whether to restart sql agent....umm..

have also just noticed something has changed with my tempdb config (i have been off work...

Fraggle (10/16/2008)

---

So funny story. The very next day, I was offered a position as a SQL Server 2005 Developer/Analyst/Administrator. 45/45/10% work respectively. I figured it was a...

Based on the fact that you have now...

Marios Philippopoulos (10/16/2008)

---

Thank you both for your replies.

I'm not sure I follow though. How would the non-clustered indexes get fragmented? The table population is done all at once, in a...

At this point, I agree... something is "dirty" in the data... my recommendation would be to delete the data at the subscriber and do a fresh snapshotl.

Garadin (10/15/2008)

---

While my subquery seems to fit all that criteria, I'm not sure that it's creating a triangular join in this case. The subquery method is blazingly fast, it...

I think Steve's in-house Ninja tweeked the forum code for...

Here's a working example of the BCP/XP_CmdShell method. If you don't need a header, just comment it out...

--===== These could be parameters in a stored procedure

DECLARE @Directory ...

heh... you forgot the last step, Seth...

* pensively turns beer into lager *

🙂

Thanks, Eric. The only thing I'd worry about now is the performance hit of using both a table valued function and a cross-apply to drive it home. If...

Sorry... the day's coffee is wearing off. 🙂 I didn't read all of your last...

You're correct. Since the rows are going to be added on a onesy basis,...