GSquared (3/13/2012)

---

Paul Stafford (3/13/2012)

---

GSquared (3/13/2012)

---

I think local, up-to-the-hour, or up-to-the-day data is probably good enough for a lot of things. Like ads on websites (to name one with a...

GSquared (3/13/2012)

---

I think local, up-to-the-hour, or up-to-the-day data is probably good enough for a lot of things. Like ads on websites (to name one with a lot of money...

I once had the misfortune to work someplace where the prior DBA was so enamored with Hungarian notation that he had developed his own system. Every object had...

The conversation was in the context of how an IT department should function as a team to help the users in a business. If we're talking independent...

Not sure I'd want the end user starting up a database server on their own.

I've made the mistake of helping a few people directly with their Word/Excel/Outlook problems rather than telling them they need to wait until our tech support team can get back...

Ah-ha! Found what was I was looking for (in my bookmarks no less). Just forgot where I had seen the reference.

For anyone else interested, here's Phil Factor's/Robyn Page's...

It's really hard to say without knowing about the volume of transactions you're dealing with. But why would you want to use the identity as your PK?...

If there's not a valid natural key in there, you really haven't designed the table correctly.

Are you using SSL? If so you need https:// for your url.

I believe trusted connections only work with default instances, are you using a named instance in this case?

JJ B (7/30/2008)

---

MentalWhiteNoise's post best represents my thoughts.

Here's my experience: For 10 years now, I've been using a mix. I use stored procedures where it makes the most sense...

Can you post the stored proc? Are you missing all the fields or only certain ones?

Thanks for the help. Now I know how to work multiple Count() expressions into a single select. Didn't think about using Case in that way...

Good point Matt. In this particular case it doesn't matter because a) I only need to know what was open at the top of each hour, and b)...