Viewing 15 posts - 61 through 75 (of 98 total)
Thanks again Ed.
Is it worth trying when W2K3 has only got 3 GB RAM ?????
June 30, 2009 at 4:18 am
John Burke (6/26/2009)
Thanks for the input. looks Like we'll be increasing the size of C:\ drive on our builds and possibly looking at using multiple virtual Windows servers instead of...
June 26, 2009 at 9:03 am
SQL Noob (6/24/2009)
Ol'SureHand (6/24/2009)
June 24, 2009 at 9:50 am
I agree with both prev posters.
DTS will run well in the Legacy subsystem until you've had a lot of training & experience with SSIS to be able to redesign the...
June 24, 2009 at 8:52 am
Steve Jones - Editor (6/23/2009)
Wow, excellent information. Ed, you need to write this up as a short article!
I'll second that!
Some words of advice needed as well about hotfix leftovers: should...
June 24, 2009 at 8:32 am
Hugo Kornelis (6/18/2009)
For TableA, this is exactly as I calculated. For TableB, this isn't; I expected a minimum row size of 77 bytes. That's a difference of 36 bytes.
And that...
June 18, 2009 at 5:37 am
Hugo Kornelis (6/17/2009)
..Books Online (chapter "Estimating the Size of a Heap") :TableA stores 72 rows per page and TableB (based on an average length of 7 bytes for the varchar...
June 17, 2009 at 7:05 pm
Very happy to help solve the puzzle.
Of course an in-depth analysis as you have suggested lead to finding interesting things .. such as the existence of 330,000 records with more...
June 16, 2009 at 10:46 pm
Hugo Kornelis (6/16/2009)
Ol'SureHand (6/15/2009)
.. why varchar(35) seems to occupy more dataspace than char(35) when the actual data stored in both cases is only 6 bytes ...
If you post a...
June 16, 2009 at 7:51 am
joeroshan (6/13/2009)
,,the table. It gives me control over which all servers to check among my long list of linked servers.
Not sure how efficient & advisable it is to link...
June 15, 2009 at 10:52 pm
Hugo Kornelis (6/12/2009)
Tom Garth (6/12/2009)🙂Hugo - How do you store a NULL?🙂
In the storage area of every row, one or more bytes are reserved for the so-called "null bitmap". [...]
*)...
June 15, 2009 at 8:08 pm
Not sure if you even need the DTS "compatibility" package unless you wish to re-design a DTS package. Of course you'll need to (if only to change the datasource!).
Once exported...
June 9, 2009 at 5:35 pm
Is there anyone able & willing to assist with an explanation: why VARCHAR(35) seems to take more space than CHAR(35) even with trimmed blanks?
Previous post explains circumstances. Not sure...
June 8, 2009 at 7:38 pm
Was: Trying to revive this topic from the DATASPACE point of view rather than create a new one.
---- please see new topic VARCHAR vs CHAR - Table Dataspace SQL2005
June 1, 2009 at 7:52 pm
... or find all rows in all tables - code borrowed from many sources inc. James DBA!
use MyDatabase
SELECT o.name AS [TableName], i.rowcnt AS [RowCount]
-- into master..tblDBHrows_20090522 -- this...
May 21, 2009 at 6:16 pm
Viewing 15 posts - 61 through 75 (of 98 total)