Viewing 12 posts - 1 through 12 (of 12 total)
My web based SQL documentation tool - LiveDoco addresses (to an extent) some of the concerns raised here:
1) It allows easy access (adding/editing/searching) to any extended properties, including the default...
April 25, 2012 at 10:25 am
PaulB-TheOneAndOnly (3/31/2012)
Z1024 (3/31/2012)
As you can see, this is a very common problem on at least SQL Server, Oracle and MySQL and the usually recommended solution worked fine.
mmmhh... not really, are...
April 1, 2012 at 4:22 pm
opc.three (3/30/2012)
March 31, 2012 at 2:23 am
capn.hector (3/30/2012)
and how does that have any bearing on the OP's question of Foreign keys and loading data?? a history table should rarely have deletes.
Fair enough, but that is...
March 31, 2012 at 2:08 am
capn.hector (3/30/2012)
Also since your table is going to be a history table why delete any thing from it? wouldn't that defeat the purpose of having a history table?
But it...
March 30, 2012 at 5:57 pm
opc.three (3/30/2012)
Z1024 (3/29/2012)
March 30, 2012 at 5:40 pm
@anthony.green
Wow, nice tool indeed 🙂
March 30, 2012 at 1:24 am
I used this code to find the columns that are present in the OtherDB, but missing in the current DB.
You could use this to add more checks in the inner...
March 29, 2012 at 5:39 pm
For tables with millions of rows you should really be careful with indexes, It can take literally hours (on commodity hardware) to delete say 10k rows from a heavily indexed...
March 29, 2012 at 5:23 pm
A very easy way to document you SQL Server DB while exploring its structure is to use my tool - LiveDoco. See my signature for the link.
March 29, 2012 at 5:14 pm
You could try LiveDoco - it's not a traditional documentation generator but rather a browser based tool one could use for example to explore a SQL Server DB and document...
March 7, 2012 at 10:55 am
Viewing 12 posts - 1 through 12 (of 12 total)