Nadrek (9/11/2014)

---

For use inside a database, or even cross-database, I can absolutely see the use for synonyms (once you handle cross-database permissions, of course).

For cross-instance work, such as was presented...

Yet another solution:

select distinct a.customerid

from #purchase a

inner join #purchase b on (a.customerid = b.customerid)

left join #purchase c on (a.customerid...

Thanks for the thoughts. I'm not dbo on msdb -- was mistaken.

Granting me explicit select rights on msdb fixed the problem. but that's not really an acceptable long term...

"Do It!" was what the execute button was labeled in Paradox.

You're bringing back bad memories!

I'm glad I'm not the only one to balk at this article.

I tend to use the 2 dimension approach: One for date only and another for time (when...

I'm the only database developer in my IT group and am regularly asked to do other sorts of IT work when the situation warrants: building a server, running cable,...

I had to smile when I read this post.

I've been working with databases for almost 20 years now and I was hoping to see some interesting approach to...