The books online that come with MS SQL Server are priceless in my opinion. If you have the time, even if you do not :) read through some of it, or at least the idnex. I have a few books on SQL Server and nothing beats the books online for the quick and dirty explanation and example.
Mike ----- Original Message ----- From: "Tony Weeg" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, July 23, 2003 8:56 AM Subject: RE: ot: dba sql question > is there a dbcc that will show the database dump? > > is it > > dbcc showcontig (datbaseName) > > ?? thanks. > > tony weeg > uncertified advanced cold fusion developer > tony at navtrak dot net > www.navtrak.net > office 410.548.2337 > fax 410.860.2337 > > > -----Original Message----- > From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED] > Sent: Wednesday, July 23, 2003 8:56 AM > To: CF-Talk > Subject: Re: ot: dba sql question > > > If you're frequently using MS-SQL Server 2000, get Inside SQL Server > 2000 by Kalen Delany (that's close to right). You can learn all about > the data storage internals of SQL-Server (though the docs in Books > Online discuss the whole one bit taking a byte issue as well, though not > as clearly). While I wouldn't recommend it as a daily activity, learning > to read a database page dump is sort of fun! > > Regards, > > John Paul Ashenfelter > CTO/TransitionPoint > ----- Original Message ----- > From: "Tony Weeg" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Wednesday, July 23, 2003 8:39 AM > Subject: RE: ot: dba sql question > > > > and space, density of the table are things we are trying to > > consider...so that's what one of the points of my question was...as > > far as space goes... > > does adding small columns like that, or large columns for that matter > > over > > time, adversely affect the database, its use of space etc....again, we > > are trying > > to figure out if we should use a int field, keep the values in an > > ordered binary string > > of 0's and 1's, rather than multiple columns (some could be added on > > later) of either > > bit/tinyInt datatype that hold virtually the same info, on/off, > yes/no, > > 0/1 for a feature > > being....well, on or off :) > > > > thanks. > > tony > > > > tony weeg > > uncertified advanced cold fusion developer > > tony at navtrak dot net > > www.navtrak.net > > office 410.548.2337 > > fax 410.860.2337 > > > > > > -----Original Message----- > > From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, July 23, 2003 8:33 AM > > To: CF-Talk > > Subject: Re: ot: dba sql question > > > > > > ----- Original Message ----- > > From: "Jochem van Dieten" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Tuesday, July 22, 2003 3:51 PM > > Subject: Re: ot: dba sql question > > > > > > > Tony Weeg wrote: > > > > why wouldn't I use tinyInt for boolean? > > > > > > Because it is not a boolean. > > > > > > Jochem > > > > Though depending on the database, space in the table pages may be the > > equivalent for "boolean" and tinyInt. MS-SQL packs bit data types > > (closest thing SQL Server has to a boolean) into one byte structure > > for every 8 bit columns. So 1 bit column and 5 bit columns and 8 bit > > columnes take up the same space. Using a tinyint for certain kinds of > > "Oh yeah, that's a boolean column. Sure it is" saves having to convert > > > the column to tinyInt to hold those other two possible status codes > > management just came up with in addition to T/F. But then again, the > > conversion is no big deal with smaller databases. > > > > But of course a bit can have three values (0,1,NULL) which doesn't > > truly make it a boolean in the first place :) > > > > Regards, > > > > John Paul Ashenfelter > > CTO/TransitionPoint > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
