[SQL] Some of my favorite INFORMATION_SCHEMA utility queries

re: [SQL] Some of my favorite INFORMATION_SCHEMA utility queries

oil portraits — Tue, 04 Dec 2007 04:34:37 GMT

Thanks for sharing this to us. It’s been a while since I was looking for scripts that can help protect my database. It’s really frustrating when you discover that after working for long agonizing hours or days to come up with the codes and the scripts it will just be ruined due to an unknown cause.

links for 2006-10-20 « tkablog

links for 2006-10-20 « tkablog — Fri, 20 Oct 2006 01:17:55 GMT

PingBack from http://timseal.wordpress.com/2006/10/19/links-for-2006-10-20/

Another Bulletproof SQL Scripts Using INFORMATION_SCHEMA Views

StevenHarman.net — Tue, 25 Jul 2006 21:20:10 GMT

re: [SQL] Some of my favorite INFORMATION_SCHEMA utility queries

Jon Galloway — Wed, 12 Jul 2006 21:48:02 GMT

@Mischa - I usually like to do the delete / reseed in two steps. One reason is that some of the deletes may fail the first time due to FK constraints, and there's no point reseeding the other tables over and over. I run the delete scripts until all tables are empty, then reseed them all at once. Either way would probably work, but this seems simpler to me.

re: [SQL] Some of my favorite INFORMATION_SCHEMA utility queries

tod hilton — Tue, 11 Jul 2006 18:06:33 GMT

Very cool. Honestly, I've been using T-SQL for years now and Phil's post was the first time I had heard of using the INFORMATION_SCHEMA view. You really do learn something new every day. :)

re: [SQL] Some of my favorite INFORMATION_SCHEMA utility queries

Mischa Kroon — Tue, 11 Jul 2006 15:05:51 GMT

Why not use truncate table XXX

For deleting and resetting the auto increment column in one swoop ??

Technical Related Notes » Blog Archive » links for 2006-07-08

Technical Related Notes » Blog Archive » links for 2006-07-08 — Mon, 10 Jul 2006 02:55:58 GMT

PingBack from http://technote.thedeveloperside.com/?p=42

Interesting Finds: July 7, 2006

Jason Haley — Sat, 08 Jul 2006 02:41:41 GMT

re: [SQL] Some of my favorite INFORMATION_SCHEMA utility queries

Merrion — Fri, 07 Jul 2006 09:03:53 GMT

There's more here: http://www.irishdev.com/blogs/merrion/archive/2006/05/04/1434.aspx

(Adding a timestamp column to every table that doesn't have one...)