If this day were going any slower, it'd still be 7:30am...

I could probably take databases offline then back online them in 5 minutes and nobody would notice...

opc.three (7/5/2013)

---

It might. Or it might randomly skip databases. sp_MsForEachDb is fatally flawed and although Microsoft seems happy enough to employ it within their own Maintenance Plan code,...

steve.spenceST (7/5/2013)

---

🙂 A very special day indeed.

We hold these truths to be self-evident, that all men are created equal, that they are endowed by their Creator with certain...

Ded Bob!

Look into my eye sockets!

:w00t:

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

---

What about pre-submitting questions or scenarios to speakers a week in advance, giving them some idea of the parts of the topic you want to...

I think you might be able to get this work with SP_MSForEachDB still. I've got a script to get a list of all DBs and any orphaned users in...

Koen Verbeeck (7/5/2013)

---

jasona.work (7/5/2013)

---

You *KNOW* it's going to be a slow day when you get in at your normal time, and get front-row parking...

I could've driven a golf ball across...

While it would be rather hard to prepare for, perhaps actually having some "improv" type seminars mixed in with the pre-planned topics might be a good idea. Possibly have...

You *KNOW* it's going to be a slow day when you get in at your normal time, and get front-row parking...

I could've driven a golf ball across the parking lot...

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...