Ok, got access to the website at work and it hasn't really helped. I am using Windows 7 64-bit, and I cannot find a 64-bit MDAC for it. From I...

Can't access it at work. I'll see if I can get it unblocked, or I'll have to wait until I get home. Hopefully it helps.

Jeffrey Williams-493691 (8/9/2011)

---

Don't drop the nonclustered indexes - disable...

I am currently using a simple recovery model. I don't do tlog backups, this isn't a production server. I do full backups and differential backups. This suits the need of...

GilaMonster (8/9/2011)

---

Maybe. If you compress the table row and page, what goes into the tran log will be the row-compressed data (not the page compression), but it's not the main...

Ok thanks.

Ok thanks guys. After doing some more research and reading the responses in this thread, I misunderstood the idea of "loading a database" in memory. I thought if SQL Server...

Ha, so simple I can't believe it didn't occur to me to just change the name. Thanks a lot.

Has anyone found out how to see of openquery is already compressing data? I looked around for a while using Google, and couldn't really find anything that helped me out.

Latency is 166ms. The WAN may be public internet, I am not really sure how to confirm this.

How do I check if OLE DB Provider is set to compressed or...

Ok thank, that's what I needed to know. I will be upgrading to SS2008 on my work computer as well, but probably not right away.

Hmm, okay 2 different answers. Anyone else know?

So restarting it once a week does not help. I did a manual reboot today, and when my coworker tried to run a report later that day he got the...

Ha ok. Thanks. This server is actually a really low cost operation. Something I did on the side to help out another team. The box sits next to me, so...

PaulB-TheOneAndOnly (8/18/2010)

---

tomiboy59 (8/18/2010)

---

Ok. The query hanging hasn't happened for a while, but now I got the error in the picture attached. This gets fixed if I restart the server. It...