metalray (10/2/2008)

---

Hi Guys,

thanks a lot.

@GSquared, well I think you have to run it hourly to get some precision into it.

Because at 11:35pm it might be the 3rd of...

I get this issue quite often with the data I work with and I've found doing an update statistics helps in most cases. SQL randomly estimates the 1 row and...

GilaMonster (9/26/2008)

---

One other misconception. A clustered index scan is not better than a table scan. It's the same thing. It's called a table scan when run on a heap (table...

try this and use a case statement

SELECT DATENAME(dw, GETDATE())

edit:

you may want to have another column to precalulate the day

so like

table(reminderid int, dateadded datetime, dayofweek tiny)

then you

insert table

select , GETDATE(),...

something along the lines of

exec master.dbo.xp_cmdshell 'bcp MyDB.dbo.cust_Lookup out c:\cust_Lookup'+CAST(DATEPART(dd,GETDATE()) AS VARCHAR(4)) + RIGHT('0' + CAST(DATEPART(mm,GETDATE()) AS VARCHAR(2)),2) +

CAST(DATEPART(yy,GETDATE()) AS VARCHAR(4))+'.csv -n -c -T -S MyServer'

I'm just tossing this out as a thinking processes as I don't not know what's going on behind the scenes.

800MB of data should transfer accross a 100mbit conenction in about...

Joy.. instead of using SHA or a guid, lets re-invent the wheel...

client side validation coupled with server side validation coupled with DB validation. Roll back the transaction if anthing is found wrong with it during the insert.

dateadd(hour, -12,getdate()) is an example also

I'm not sure.. My 'answer' is based on what little info we got up top.

1,1,1234 park st,1-1-2000

2,1,1234 park st,1-2-2000

3,1,1234 park st,1-3-2000

4,1,2345 park ave,1-4-2000

5,1,1234 park st,1-5-2000

6,1,1234 park st,1-6-2000

The correct result should be 5.

originally my set based logic would return the correct result for anything like...

When i tried to solve this based on just a table with (rownumber, addressident, vchaddress, datechanged), I ran into grouping problems. I could try to find the max rownumber per...

ma'b white characters in there?

You can't compare text types to eachother, which means you can't run a distinct statement that outputs or groups on a text column. I don't think sql stores text types...

if most of that cpu time on cpu1 is kernel time, then I would have to aggree with the ideas of network/san/etc. But if it is mostly user time cpu,...