Coming in late.

I can't win the memory contest, but my bragging server is a 32-core system handling 3000+ connections and at peak over 600k page lookups per second. No, those...

I have to blast mine in...

To answer Steve's question -- as little as possible. I manage/read email with it and, if really pressed I can even answer an email. I love my phone's form factor...

I feel like this is a very different discussion for a DBA than for a programmer, for two reasons.

First, DBAs can impact performance of a database without ever touching the...

Before I got hooked on computers I was an astronomy buff. I would've ended up in one of the observatories at the time, probably Mount Wilson. If I still had...

Hi all .. unless I'm mistaken the original question was about SP2, not about R2. I've created and tested a slipstreamed SP2 install without any problems, but I haven't yet...

Great article! Just wanted to add that in addition to (sometimes in lieu of) taking a backup of the database before "experimenting", I often shut down SQL and make a...

Hello Zack,

Just ran into your article. I'm trying to research setting up Reporting Services on a SQL cluster from the licensing perspective, and have not found any good information on...

For me it's True Lies and the Windows 3.1 computer in Arabic. Arnold plugs a little device into it that lets it be controlled remotely (serial-port WiFi?) from the van,...

This is a documented bug in SQL 2000 with SP3. We have the same problem. Fortunately it has been fixed in the forthcoming SP4 release (now in beta).

More information on...

Same here, our backups have always been done to compressed folders and we've never had any problems. We're backing up ~150GB nightly, with the largest single files over 30GB.

I've never...

I would if I could too <g> I haven't been able to get Kerebos delegation working so we're still using good old SQL connections between our linked servers.

stelze and gljjr,

Thanks for the advice. Dropping and recreating the linked server works well (takes effect immediately) so I can go that route. I was hoping to not have to...

rmattaway,

Good suggestion ... except that we also have views (over 80 of them) that would also need this logic. Not sure how a view could dynamically figure out which linked...

Just a suggestion, but you may want to alternate between two backup targets, instead of using one file over and over. Reason is, if for some reason you have a...