As a c and c# programmer i think i will never learn it: in vb.net, arrays (e.g. stringarrays) start by default with the index 0 and end with the dimensionparameter. So, a ReDim a(6) creates an array from a(0) to a(6), so it contains 7 (!) elements.
Hopefully, i learned the lesson now...
5. Oktober 2006
4. Oktober 2006
is a kilometer 1024 meters?
I just received as a gift (oh lucky me) an usb memory stick labeled 2GB. I just discovered, that there are only 1,86 GB shown in the filesystem. What is wrong?
Well, a closer look to the package of the sticks showed a small star near the sizelabel. The star had to tell me, that this is a 2GB stick, when 2GB are 2.000.000.000 Bytes.
Ok, for some people the real sizes of Memory sound stupid. But there is a reason for the strange boundaries. Decimal Systems do not always work good. I fear, the only reason for the 2GB label is marketing. So, again, marketing caught technical specifications...
In some sense this reminded me to the old story, that physicists think, a kilobyte is 1000 bytes and computer programmers think, that a kilometer is 1024 meters...
Well, a closer look to the package of the sticks showed a small star near the sizelabel. The star had to tell me, that this is a 2GB stick, when 2GB are 2.000.000.000 Bytes.
Ok, for some people the real sizes of Memory sound stupid. But there is a reason for the strange boundaries. Decimal Systems do not always work good. I fear, the only reason for the 2GB label is marketing. So, again, marketing caught technical specifications...
In some sense this reminded me to the old story, that physicists think, a kilobyte is 1000 bytes and computer programmers think, that a kilometer is 1024 meters...
20. September 2006
Microsoft Analysis Sevices 2005 modeling
After having my data in the new database, it was time to create a cube. I am used to do this in analysis services 2000 and have now the ability to learn new things...
An unclear error occured, when i tried to build the cube. I started building a dataconnection, draw a dataview with my facttable and dimensions, set up the "shared" dimensions and tried to build the cube.
Building the cube failed, because the modeler was not able to find connections between my tables. But i draw the connections between the tables. Even setting the connections up by hand failed. What was wrong?
The problem was (of course) in front of the screen. When i draw the datamodel, i refused to let the integrated development environment (ide) to set up logical keys to the database. I was asked by the ide and had the opportunity not to set up the keys. This lead to the problem not be be able to set up a cube.
Lesson learned: set up logical keys in the model, even if you have the choice not to do so...
An unclear error occured, when i tried to build the cube. I started building a dataconnection, draw a dataview with my facttable and dimensions, set up the "shared" dimensions and tried to build the cube.
Building the cube failed, because the modeler was not able to find connections between my tables. But i draw the connections between the tables. Even setting the connections up by hand failed. What was wrong?
The problem was (of course) in front of the screen. When i draw the datamodel, i refused to let the integrated development environment (ide) to set up logical keys to the database. I was asked by the ide and had the opportunity not to set up the keys. This lead to the problem not be be able to set up a cube.
Lesson learned: set up logical keys in the model, even if you have the choice not to do so...
Integration Services Microsoft and Flat files
I had a strange experience yesterday: I tried to get a flatfile into a database. I used dts on sql server 2000 before and i am forced to use the new platform 2005 now. So, learning new things can be a challenge and is basically good.
But one annoying thing to learn was, that a flatfile on integration services determines now the width of the columns, even in a delimited file. If columns exceed the presetted widths, errors occor. This would be no problem, if the message would have brought me near to the problem...
But one annoying thing to learn was, that a flatfile on integration services determines now the width of the columns, even in a delimited file. If columns exceed the presetted widths, errors occor. This would be no problem, if the message would have brought me near to the problem...
Abonnieren
Posts (Atom)