Viewing 15 posts - 38,071 through 38,085 (of 49,571 total)
ddicecca (6/29/2009)
GilaMonster (6/29/2009)
Take a look in Books Online for the UPDATE ... FROM syntax.Seriously...? That's your help?
I'm sorry, I thought you might like a hint where to...
June 29, 2009 at 2:45 pm
jcrawf02 (6/29/2009)
GSquared (6/29/2009)
June 29, 2009 at 2:41 pm
Alvin Ramard (6/29/2009)
Lynn and Gail, what would you say to creating a new table in a user database for holding the new data, along with the key fields from sys.sql_logins?
It'd...
June 29, 2009 at 2:28 pm
Take a look in Books Online for the UPDATE ... FROM syntax.
June 29, 2009 at 2:19 pm
Write an SSIS package, maybe using the transfer database task, or maybe broken down with transfer objects and data flows, then schedule that package daily (using SQL agent)
June 29, 2009 at 2:18 pm
Besides, sys.sql_logins, sys.server_principals and syslogins aren't tables. They're views. The underlying tables are hidden and aren't even queryable.
June 29, 2009 at 1:55 pm
Peso (6/29/2009)
So there's nothing...
June 29, 2009 at 1:47 pm
Absolutely it's necessary. In full recovery the transaction log does not get truncated except by a log backup. No log backups, no reuse of the log file, the log file...
June 29, 2009 at 10:27 am
Lynn Pettis (6/29/2009)
If I remember the Modeling class at the TDWI conference a couple of years ago, 6NF is used to eliminate nulls being stored in a database.
There's actually...
June 29, 2009 at 10:23 am
websites2 (6/29/2009)
June 29, 2009 at 10:18 am
On 64-bit you need to set max memory. Otherwise SQL will allocate until the OS is memory starged, and then it will get paged out (if the SQL service account...
June 29, 2009 at 10:04 am
GSquared (6/29/2009)
GilaMonster (6/29/2009)
Isn't that pretty much 6th normal form? Not one I'd use in anything other than the most extreme cases.
6NF is either Domain/Key NF or Temporal NF, per what...
June 29, 2009 at 9:51 am
Paul White (6/29/2009)
😀 Don't tell me about it - I didn't post the daftness!
I didn't say it was daft, I just said I don't know why anyone would do it....
June 29, 2009 at 9:26 am
Gaby Abed (6/29/2009)
Regarding the Nth Normal Form, and I guess on a more philosophical level, is it true that the more normalized a database is, the less fragmentation occurs
I'd say...
June 29, 2009 at 9:13 am
June 29, 2009 at 8:49 am
Viewing 15 posts - 38,071 through 38,085 (of 49,571 total)