Google: "Gaps and Islands Itzik Ben-gan"

That should get you started.

Index definitions (CREATE INDEX) and table definition please. I think I know what's going on, but need confirmation.

What's the definition of the table and index (CREATE statements please)?

Firstly why are you regularly shrinking your database?

AFAIK the error's from the log's trying to auto-grow while you have a shrink running. Solution: stop shrinking the log, if it's reaching...

Sorry, mine's broken, it's only showing clouds.

There is some external application running on the local server connecting to SQL as sa.

It is not an internal SQL background process, they do not need to log in and...

Books Online (the SQL help file) 🙂

John suggested what you should do.

Set...

No, SQL doesn't track object change history.

You can look at sys.objects in each database and look at the create_date and modify_date, but I think there are things you can do...

No, that's something external trying to connect. The system tasks don't need to log in. They're internal.

I prefer disable, as I've seen a case before where a service pack installation...

gopisrinivas.t (3/17/2015)

---

I have done sql server configuration in 4 to 5 systems and observed the differences in the execution plan of these systems. I could see the query execution faster...

Yup.

You shouldn't be touching the minimum memory for query without a really, really good reason. The max server memory however should almost always be changed from the default, as few...

jshahan (3/16/2015)

---

I haven't heard this before and I believe the query optimizer (assuming you're talking about linking at least two tables in the same query) is going to use them...

No.