sqlnaive (11/14/2014)

---

I have few questions which might look pretty straightforward.

1. Can we start index defragmentation job for different DBs at same time ? Will it effect anything ? Is...

And, i agree with the others, just making the three columns into a clustered key, especially if it's unique will work well. But, in that case, reverse what I said...

SeanNerd (11/14/2014)

---

Well - I sure feel silly. I thought all these replies (above) were going to reference the original posters. Sadly, I am a bit new to posting here. I...

SeanNerd (11/13/2014)

---

My question is about indexing strategy for the following scenario:

I have a table where we cannot use the typical int identity primary key column. The table can have millions...

Dana Medley (11/14/2014)

---

First off, let me say thank you for submitting a question. Although (to me) the wording was a little off, it was still a good "back to basics"...

Yeah, I have to agree. The posted code fails to compile. I can edit it, but I'm guessing I won't see the error if I do.

Gotta agree. Without an edition being stated, the answers change. Just saying SQL Server, I would assume the full product, then the minimum is 1gb, but the recommended is 4gb....

You might want to post that on Connect so that Microsoft is aware of it and makes it part of the documentation.

Resender (11/14/2014)

---

OK just out of curiosity

We have a similar scenario

A query that runs an inner join on a select statement on a linked server

If the linked server is unavoidable,what...

If you have the money, you'd better off with more than one disk to stripe the access. Also, for ~600gb of data, 8gb is a shockingly small amount of memory....

Oh, and that. Thanks.

OK, that's weird. It just worked the second time? Huh... I'm stumped. That error is pretty explicit. It's not possible that someone has been mucking with the server?

GilaMonster (11/13/2014)

---

g.britton (11/13/2014)

---

SeanNerd (11/13/2014)

---

My question is about indexing strategy for the following scenario:

I have a table where we cannot use the typical int identity primary key column. The table can...

A little confused by what's going on. Red Gate (good choice) SQL Compare doesn't do backups and restores. It just compares databases to other databases, backups, scripts, source control, and...

Just make sure you carefully document what you're removing and have it stored somewhere that everyone remembers.