Excellent. Include some screenshots so people know where to find it and know they don't need a command window. find 2-3 useful things that SQLCMD allows that you can show.

The thing is, with Twitter and Facebook, you control who you watch. You might care what some people are doing, might not. However it's the same as people you meet...

It would almost seem to be some persmissions/security issue, but I would hesitate to "play" with the cluster. I'd call MS, let them work through it.

We would like to surface more statistics and data. I'm working on that. It's a resource thing, and this is relatively low priority, but thanks for the suggestions.

note that DUMP is an old keyword and likely to be removed at some point. BACKUP TRANSACTION is preferred

http://msdn.microsoft.com/en-us/library/ms186865%28v=SQL.100%29.aspx

Koen (da-zero) (1/17/2011)

GilaMonster (1/17/2011)

Was one of the things that contributed to me leaving the bank. The over-paid consultants from Big Named Consulting Company were considered (by upper management) to know...

I would call MS on this. It almost looks like something might be misconfigured on the cluster. Does this happen on both nodes?

Tend to agree with Gail. You'll have to test.

Depending on how many unique vales and the size of the table, you may or may not get better performance with the...

The worst case is that it could require more space due to a collation that forces everything to a Unicode comparison based on the data types, but it should not...

Jeffrey has the solution that will probably work best, but you might want to test a couple scenarios out. Ultimately the way your system responds best is what you want...

Wow, that's interesting. I'll ask some people at MS.

Does that 28 days matter if the old primary node then becomes the inactive one? Isn't it OK as long as you always have one node inactive?

I wasn't thinking it was easy for many people. Also, restores are critical.

Shared components are client tools and non-instance aware services. Not all SQL Server services are multi-instance.

My reading of this: http://www.google.com/url?sa=t&source=web&cd=3&ved=0CCwQFjAC&url=http%3A%2F%2Fdownload.microsoft.com%2Fdownload%2F1%2Fe%2F6%2F1e68f92c-f334-4517-b610-e4dee946ef91%2F2008%2520SQL%2520Licensing%2520overview%2520final.docx&rct=j&q=sql%20server%20licensing&ei=g-QxTY3cJcbpgAf0uc3ACw&usg=AFQjCNG-uwJLVzdsMDmXMjfsjof5SGObzA&sig2=apGsuUhzdrjJMzFTMwPWtA&cad=rja

says that passive nodes don't need licensing. this assumes the passive node has <= number of CPU sockets as the active node.

When you say you...