Retire? What's that word mean?

I'll be a geek til the day I die. If I'm lucky, I'll get paid for it most of the way.

danaanderson (4/26/2012)

---

I wonder about the extra table myself. I've not made many posts here, but I felt I should put in my two cents (not that that is worth...

20,000 rows is not that much. Even tripling it to 60,000 rows is still not much. Returning four columns doesn't mean much because I don't know the data types of...

If FK3 is used in queries where the other two columns are not referenced in either JOIN criteria or WHERE clauses, then yeah, it might benefit from a nonclustered index....

Larry Page(Ehsan.Akbar) (4/26/2012)

---

Mark Fitzgerald-331224 (4/26/2012)

---

Larry Page(Ehsan.Akbar) (4/26/2012)

---

Grant Fritchey (4/26/2012)

---

Larry Page(Ehsan.Akbar) (4/26/2012)

---

Grant Fritchey (4/26/2012)

---

Larry Page(Ehsan.Akbar) (4/26/2012)

---

Grant Fritchey (4/26/2012)

---

You could use merge replication to ensure that the same data goes to all...

There are a bunch of ways ot tell what version of SQL Server you have. Microsoft has them documented here. The best is to query directly:

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY...

Larry Page(Ehsan.Akbar) (4/26/2012)

---

Grant Fritchey (4/26/2012)

---

Larry Page(Ehsan.Akbar) (4/26/2012)

---

Grant Fritchey (4/26/2012)

---

You could use merge replication to ensure that the same data goes to all three servers, regardless of which one inputs the...

Thanks. I've had a little practice laying out that information though, so it's not that big an accomplishment.

I found a bug in AlwaysOn. Anyone want to vote on it?

Looks like it's a bug. I just submitted this on Connect if you want to go vote for it.

Larry Page(Ehsan.Akbar) (4/26/2012)

---

Grant Fritchey (4/26/2012)

---

You could use merge replication to ensure that the same data goes to all three servers, regardless of which one inputs the data. But that requires...

Looks like everything is retyped for us to hide things, but based on what's typed, it's saying the VALUE is the problem, not the column name.

I just did a series of tests with my AlwaysOn test environment. I failed over multiple times on an existing database, AdventureWorks2008R2. I didn't see the reseed occur. I tried...

I was going to say the same thing. Check the data on the other server. That must be where the duplicate is.

Usually that would be an indication of a full drive. There must be an error or a message or something.