Rather a complex topic, so here's links to existing articles on indexes and their structure:

https://www.simple-talk.com/sql/learn-sql-server/sql-server-index-basics/%5B/url%5D

http://www.sqlservercentral.com/stairway/72399/%5B/url%5D

Part 1 and Part 3 give the explanation of the index types...

I've found the stairway article...

Steve Jones - SSC Editor (7/3/2013)

---

jasona.work (7/3/2013)

---

So, anyone else rather annoyed at MS for announcing that they're going to end the Technet Subscriptions?

For those of us who are either jack-of-all-trades...

I would suggest talking to the network admins, see if they can create DNS entries that will point to these servers and update automatically when the IPs change. The...

So, anyone else rather annoyed at MS for announcing that they're going to end the Technet Subscriptions?

For those of us who are either jack-of-all-trades or just geeks who like to...

Cool, thanks!

Funny thing is, I think I read that article back when it came out...

I'm getting old, my memory ain't what it used to be...

😀

Seriously though, sounds like if I...

Having used this script: When you first run the SQL provided by MS, it creates a Stored Procedure (or if you prefer, installs one)

As for mis-matches, what may be...

Well, this seems to back up what I found: http://www.pythian.com/blog/are-you-switching-to-bulk_logged-recovery-model-know-your-risks/%5B/url%5D although with the recommendation that you *HAVE* to take a TLog backup IMMEDIATELY after you finish the bulk operation and...

OK, where I work, it seems that when they were remodelling (before I started) they "fixed" the air conditioning...

As in, one of the old hands stated where I'm sitting used...

You know, reading the end result of this topic: http://www.sqlservercentral.com/Forums/Topic1468850-2799-1.aspx, I'm wondering why MS doesn't provide a pair of radio buttons in several different places...

Radio button 1 -> MB

Radio button...

Where I work, we're going to get double-whammied next week I think...

People have taken next week off, plus (being govm't) we've got people starting their mandatory furloughs because of sequestration...

Except...

Lynn: Stay safe!

Everyone else: Did everyone (in the US at least) start their July 4 weekend early? Sheesh...

Nothing in here since ~5:30am and that from someone I...

I believe that yes, you would need to run a full backup of the recently restored DB in order to "re-start" the log chain for it.

If you're going to restore...

Stefan Krzywicki (6/26/2013)

---

Fal (6/25/2013)

---

I put mine in the oven.

And sometimes I accidentally do one when I put it through the wash...

Brandie Tarvin (6/25/2013)

---

Blasphemy. Sheer Blasphemy.

Someone take away his golden SysAdmin key. Expel him from the ranks of the...

Uhh, with this:

DBCC SHRINKFILE('WBT', 150000)

😉

(Yes, I know everyone is kidding around, and it's not something I intend to do regularly...):-D