dwain.c (7/4/2012)

---

I just made the most awesome discovery while using cascading CROSS APPLYs so I thought I'd post it here.

Did you know that inside the CROSS APPLY if you refer...

Messing around with some code yesterday got me thinking. DS8K throws away all the tally table rows where substring(string,n,1) isn't a delimiter. The discarded rows contain information - the distance...

Fantastic! Well done Gail.

Everyone's a winner. Thanks for the feedback, coronaride.

Lynn Pettis (7/3/2012)

---

Try the following to get the list of files:

dir *.* /a: -D /b /s /n

NOTE: No space between the a: and the -D. I had to put...

SQLKnowItAll (7/3/2012)

---

The problem is that you are thinking of them as "partial duplicates," which itself is impossible (IMHO). Why not look for the '.' in the file name, since...

Have a look at the output from this, it will point you in the direction. Come back if you have any trouble with it:

DROP TABLE #Filelist

CREATE TABLE #Filelist (DIRoutput VARCHAR(254))

INSERT...

Try this.

-- use a variable for the date

DECLARE @MinCreatedDate DATETIME

SET @MinCreatedDate = '2012-06-01'

SELECT @MinCreatedDate -- check it's correct

-- start simple, look at the whole picture

-- don't aggregate until you're sure the...

Tuning indexes is quite tricky and can be daunting if you aren't familiar with the standard tools. Glenn Berry provides one of the best toolkits around and has written numerous...

SELECT

Verified = 100.00*SUM(CASE WHEN Verified = 'Yes' THEN [Count] ELSE 0 END)/SUM([Count]),

Unverified = 100.00*SUM(CASE WHEN Verified = 'No' THEN [Count] ELSE 0 END)/SUM([Count])

FROM (

SELECT

Verified,

[Count] = COUNT(*)

FROM #CustomerOrders

CROSS...

I'm really confused by this, since most effort on this thread...

Bobby Glover (7/2/2012)

---

Hi

I just reduced logical reads in a sproc from 350,000 to 611,

but physical reads are up from 0 to 14.

The table rows = 325,000

No sure if this represents...

:blush: thanks!

Try DIR *.* /s /n /b