The world needs more out of tune guitars. They are going the way of the Dodo.

What does AS do?

I have the same problem when printing diagrams, but only for my Brother laser printer at home. At work (Xerox laser) it is fine. I will try the margins solution,...

It just occurred to me there is an argument for upper case keywords giving better performance. Perhaps the query parser takes note of the queries that are "shouting" and puts...

Another vote for no caps (this needs a poll). I am a stickler for proper indentation, which in my opinion matters far more than keywords. When code is indented well,...

Sorry, a bit late here.

My guess is that this query is telling you how many post_2s exist for each name's latest address.

Yup, everything I need is in there. I should have re-read the books...thanks!

The issue is that SQL Server can use indexed views even when they are not referenced explicitly. I am not certain of the exact conditions under which this occurs.

I use DAEMON Tools.

An example I can give is that I turned a 27 hour legacy stored procedure (Oracle, running on some pretty big hardware) into a 5 second stored procedure, by switching...

I use a cluster brush. The authoritative text on these is available here:

http://www.vrvis.at/vis/resources/DA-NSahling/node47.html

Actually you can do plenty of development with the free download Embedded Visual Tools from Microsoft. There are lots of tutorials on DevBuzz.

http://www.microsoft.com/downloads/details.aspx?FamilyId=F663BF48-31EE-4CBE-AAC5-0AFFD5FB27DD&displaylang=en

This is a good site:

http://www.devbuzz.com/

Try this:

select t2.id, t2.resourceid, t2.date, t2.quantity

from

(

 select resourceid, max(date)

 from YourTable

 where date < cast(floor(cast(GetDate as float)) as datetime)

 group by resourceid

) t1

inner join YourTable t2 on (t1.resourceid = t2.resourceid and t1.Date =...