Good luck, Rod, and hope something shakes loose.

The soft skills are important, but they won't be direct asks in many interviews. However the way you answer, interact with interviewers, even...

I don't love the way you have schools and the year in there, but if you're not up for a big refactoring of the tables, then Sean's suggestion makes sense.

Please...

WayneS (9/10/2014)

---

:ermm: And then I re-read Sean's original post... for some reason, I thought we were talking about Denver. I won't be in KC, but will be in Denver. Anyone...

Extended stored procedures weren't used internally to implement functionality, but rather to extend the platform to do things that the didn't want to code.

The CLR is embedded in the internal...

Sorry, Type II Slowly Changing Dimension - http://www.1keydata.com/datawarehousing/slowly-changing-dimensions-type-2.html

It's kind of what you have, but not quite.

As Sean mentioned, you need to record time. Without time, it's not clear what happened...

WayneS (9/10/2014)

---

Sean Lange (9/9/2014)

---

I think I should be able to make it for the afternoon sessions. The last game should be done a little before noon. Cerner is about 45...

I see people using int for dates in a dimensional modeling area. Makes some sense, and then you wouldn't have the lovely "my date doesn't fit in 7 char" issue.

You are welcome and sorry I don't have anything else. If you figure it out, I'd be interested in knowing what happened.

I don't see anything for reorganize, but this piece says queries still run with rebuild, so I suspect things will be fine, albeit, potentially slower

http://blogs.msdn.com/b/sqlcat/archive/2008/11/06/best-practices-for-integrated-full-text-search-ifts-in-sql-2008.aspx

Do you have automatic updates turned...

I'd say certify on 2012. Much is the same, a few additions, but the cert will be something you can use longer.

Are these the same? Or two different databases?

Admin stuff fairly similar in most cases. Lots of T-SQL changes. The Inside SQL Server stuff, especially Itzik's Windowing book are great.

Quote on the drive? Other than that, no reason for SQL not to try. Nothing in SQL Error log?

Jeff Moden (9/10/2014)

---

Heh... yeah... just like they gave us the ability to write extended stored procedures. ;-)...

You can restore with STANDBY and it's then readable when it's not restoring, but it's still really in the restoring state because more logs can be added.