A couple good points by Jeff. First, you don't have to be the most impressive T-SQL person out there. You are taking on the other 20 people that applied for...

You periodically do maintenance to clean up the fragmentation and pack things together (remember your fillfactor here). It's just the way things are that a heavily used table might store...

bwillsie-842793 (2/23/2010)

---

Disclaimer: This is my experience as developer, not as a DBA.

I'm a fan of mirroring, but so far my experience with log shipping for any purpose other than backup/recovery...

I think so! Replication is great, but one of the issues I see with it, and others, is in terms of...

White paper link is in the article, and now here: http://download.microsoft.com/download/d/9/4/d948f981-926e-40fa-a026-5bfcf076d9b9/DBMandLogShipping.docx

It's a .DOC download. Apologies

Did it work?

The newsletter likely is caught in a filter. We recently adeded the DKIM flag to it, which Yahoo, Hotmail, GMail want, but other than that, no change.

Ahh, the Thread is quiet. Or are we waiting for Paul's answer?

Thanks, Gianluca,

I hope this isn't supposed to count as a CAN-SPAM inquiry. Just an FYI, posting in a random forum and hoping someone sees it isn't the best way to...

One other thing, if you can get him to talk, ask about once a year, or rare processes that come up after certain events, like the end of the year,

Thanks, John. Hopefully it will be done tomorrow 🙂

I'm not sure it's a SQL problem. I think it's a security problem at this point. SQL just queries AD, if I remember correctly, under the service account permissions. Is...

Want to test with 10mm rows and let us know?

I'd suggest two things.

1) set your instance to use 1434, move a default instance to another port

2) set a DNS entry with an FQDN to point clients to the server....

You are correct, the declare table should stop things. I might be curious to see where someone was going, but the declare cursor would drop someone way down my list...

C'mon, I'm sure you'd end the interview after

DECLARE curNumbers CURSOR

How long could that take?