koolme_85 (11/30/2011)

---

i have 75 guids that are distinct and the records associated to that 75 records are also distinct and the rest 85 are not distinct (assuming there are...

If you only want a distinct row for each guid then you need to add some sort of aggregating logic to your selection from table1. You're getting more than...

Do the statements really need to be dynamic? Or would the statement always be the same for the same hour?

Maybe you could provide a little bit more detail on...

I don't really see any reasonable way around using dynamic sql to do what you want. You could do an absurd list of IF blocks but that would be...

Sounds like the proc definition has been scripted in a job or something. SQL Server won't overwrite unless you tell it to. You could set up a DDL...

I understand that is a pseudo staging table. Normally staging tables are used to take flat data and move it into a relational format. That's not going on...

You can do a few things ...

set statistics io on;

This option will allow you to see where the IO's are happening. It can help in many cases to troubleshoot...

TableA = TableB joined to TableC

This is, in my opinion, bad design. It's redundant. Tables B and C can always be derived from TableA and TableA can always...

I would suggest reading http://social.msdn.microsoft.com/Forums/en-US/sqlsecurity/thread/91f3ef67-6c84-4774-a7aa-c8e8be014721/ as there is specific information about troubleshooting steps when encountering this error.

You'll want to pass in the values you want to check against in a single string and use a string splitting method (usually in a user defined function) to split...

I agree with G^2. I would rather error on the side of reducing reads over picking the "fastest" time unless it is really disproportionate.

A lot of people make the mistake of thinking of CTE's in terms of performance. In the vast majority of cases (the recursive CTE being one example of an...

It depends on what you want to do. You've given no indication as to the nature of what you want to accomplish so it's impossible to give any specific...

This is a good little trick if you want all values concatenated for a related ID:

selecttd.irecordid

,td.recording_suffix

,grantors =

stuff((

select ', ' + tg.grantorfirst + ' ' + tg.Last_Name

from dbo.tempgrantor as tg

where...

So it sounds like you don't have enough RAM, so it has to be written to tempdb, and you don't have enough disk space, so the attempt to write to...