They physical reads did fluctuate from 0 on a fast run to 148 on the slow run. While I would not think that would produce such a large change,...

In early testing for the procedure I did find an index that was missing. That did not fix the issue completely, it only made it less recurrent. As...

Just FYI... I was able to take an outage tonight.

I did a Detach/Attach to the DB.

Preformed all the alter auth and set trustworthy steps

BOOM...its working now.

Problem remaining... what happened...

DECLARE @t TABLE (vals VARCHAR(1024))

INSERT INTO @t (vals)

VALUES ('http://domain/sub1/sub2/sub3')

INSERT INTO @t (vals)

VALUES ('https://domain2/sub1/....')

INSERT INTO @t (vals)

VALUES ('http://domain_n/')

INSERT INTO @t (vals)

VALUES ('https://anotherdomain/')

DECLARE @tImed...

It is not significant, unless you have data that came from an outside source, say migrated data.

If you...

The curious behavior to which I was referring is the subtle nuance between the following statements

SELECT DATALENGTH(t.testdata) actualLength,t.testdata...

Thanks to all

So the summarized information is here

DECLARE @tbl TABLE

(

testdata VARCHAR(1024)

)

INSERT INTO @tbl ( testdata )

VALUES ( 'a') --0 spaces

INSERT INTO @tbl...

GREAT ARTICLE.

It explains a lot, however, it seems to indicate that the LIKE operator would allow you to find the non padded a.

When I tested it

SELECT DATALENGTH(t.testdata) actualLength,t.testdata FROM @tbl...

it appears to be storing the spaces

when i change the select statement to the following

SELECT '>' +...

Why are trailing spaces considered insignificant in relation to comparison rules?

And I guess more important that that,...

My Log backups are every 10 minutes because I am doing log shipping.

The Defrag schedule is MWF 330am and appears to take around 1.5 hours.

Every MWF without fail about 420-430...

Also there seems to be at least some indication that Contig did nothing for the sytem where the db was...

Lowell (7/8/2009)

---

...but because i restore and drop a lot of databases,files and such for conversions...

I'd actually pose the opposite question: why is it a good idea NOT to do this...

That's what I was looking for, a simple but effective solution.

Thanks,

Well I figured out how I will accomplish my task.

Basically I will log ship as I had originally stated. Then (believe it or not I am going to plug...