25%

What a great script to get a quick table index list. I've saved this one. Thanks.

Thanks for doing the research. I didn't realize there were so many data mining tools out there.

Thanks for the question. Lots is good comments.

Alex Gay (10/7/2015)

---

The problem was after that many years we only had three members of staff who could program Clipper well enough to provide support, and they were the IT...

OK, I'm sure our admin can use this. I just added a sort by StatsUpdated desc.

Thanks for the great article. Much of it is beyond me but my DBM is going to love it.

xsevensinzx (10/6/2015)

---

Interesting stuff.

I have to ask though, why not just manually make this yourself with 2 tables and some triggers? All it's doing is tracking the history of the table...

Kit G (8/10/2009)

---

The link for this reference:

http://msdn.microsoft.com/sql/default.aspx?pull=/library/en-us/dnsqldev/html/sqldev_04222005.asp

pulled up that the page wasn't found.

The other link worked.

edit: nevermind. For some reason this came up as the current question of the...

Don't know anything about the temporal tables but your description reminds me of the automated change tracking tables. We built our own "history" tracking on those tables we felt needed...

Thanks for the script. I'll give this to our DB to dissect.

Thanks for the article. We do a lot of these sort of imports and have many of the same issues such as dealing with blanks. But we have already determined...

As a bit of a sidebar, I would have much preferred for Microsoft to have used the much more appropriate and correct "us" abbreviated for microseconds instead of using the...

Thanks for the script. I'll look it over a bit closer before trying it out.

billp 37934 (10/5/2015)

---

I'm with Jeff on the header saying what the SQL is supposed to do. When debugging if a header says what it's supposed to do and the...