Ian,

Not a bad idea, but it might be hard to find. I'm sure that people post new questions since they don't search, or want to search, for other threads....

Because it is throwing out pages quickly to get the backup done and maintain transactional integrity, the SQL Server backup process is extremely intolerant of network hiccups. Way, way...

Lock Pages in Memory not assigned?

That is strange. I'd call PSS.

There isn't a great reference out there, and apologies for not getting a better one. The HierarchyID, from what I've seen from various sources, is a binary representation of a...

But there's a default in code as well. If you don't specify it, meaning just create an index, it's non-clustered.

I agree with you that people need to think, but how...

But would you test a .DLL outside of the main branch? Maybe that's why there have been issues with a number of the patches.

Typically the SPs go out to beta...

Late joining back in, but 14GB is too much. After 8GB, there's 1GB being used to move stuff in an out of PAE memory. Meaning you've left 1GB for the...

If you're salaried, then there isn't "unpaid overtime." That's the reason for a salary, or part of it. They might require extra time or they might not have 40 hours...

Go to your page (http://blogs.sqlservercentral.com/loner/default.aspx), log in, there should be a "write a post" on the left side.

I'd like to reduce the size. Not sure how much work I'll get done there. The developers apparently like .NET and Javascript and generated lots of it, not really paying...

Search should cover all articles. Can you elaborate on which terms you used and which article you were looking for?

Matt,

I can appreciate the difficulty in testing and worrying about the localization and variations that might exist, but

Isn't that what they do with Service Packs?

Aren't they tested as...

Never read Monk. Come to think of it, I'm not sure there are any great quotations from books that strike me.

I hope there's a committee, but my guess is that whichever developer works on it gets to decide. He/she may ask for advice or have guidance, but I would bet...

Ah, but I don't think that works. you still choose a default when you present the choice, meaning either clustered or nonclustered is selected. I guess you could select nothing...