Definitely a high level (somewhat academic) review of Data Warehouses. The clients my company interacts with don't have "steering committees" but do have business needs that we are solving. Sometimes the road to the Enterprise or large Departmental Data Warehouse is through Data Marts that conform through dimensions. I am not slamming the article but […]
2003-07-14
Hi Dale, quote: This may be what you are looking for: quote: Estimating the Size of a Table The following steps can be used to estimate the amount of space required to store the data in a table: Specify the number of rows present in the table: Number of rows in the table = Num_Rows […]
2003-07-14
1 reads
Hi, I don't know if this really helps, but I think depending on your OS you have to use CDOSYS. When I'm back in office on monday I hopefully can tell you more! Cheers, Frank
2003-07-11
Yes, and this is actually true of any app. Unless the OS was booted with the /3GB switch or the /PAE switch and the app has been configured properly to use AWE memory, all applications are limited to 2 GB. The /3GB allows an app to expand to use 3 GB (provided there's memory available). […]
2003-06-30
1 reads
Hi Dale, quote: Whatever happened to those ERDs (for Frank, Entity Relationship Diagrams) and UML (Universal Modeling Language) Class Diagrams? please, don't make me think, I'm the only one who doesn't understand. But I'm glad to see you care In fact, when it comes to slang or off-oxford english, which is tought in school here, […]
2003-06-25
If the table is going to take up more than a couple of pages, use a clustered index. Otherwise you can get a 'heap' where the query hops all over the place and end up with as many IO operations as there are rows.
2003-06-23
Lessons Learned: Never have backup of MDF on same disk as live database. Been there, done that.
2003-06-22
quote: sp_password will allow people to change their password, but they need a way of running it eg isqlw, osql or an application.
2003-06-04
1 reads
Well, he is honest quote: What a professional advertisement and first impression of your "company." Check this out http://dbforums.com/t803315.html Cheers, Frank
2003-06-03
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers