Search results for query: *

Unfortunately, I needed to fix that domain so I moved the DNS to another DNS server that I knew was working. With that in mind, I do have a similar domain that is not working, SEEMUG.COM. It is managed via the same DNS server that the other one was. By the way, thanks for the input.

Last night my hosting facility changed backend providers. I got a slew of new IP addresses. Well everything is working fine for those Domains that are not being managed on my internal DNS machines. The ones that I have on my DNS timeout before responding. I checked and if I directly query...

Yes it does, my question / problem is where does the behavior for error handling occur? Is it configurable? If so, how? I ave search a large number of books on this topic an not found one that addresses database mail much further than how to configure it out of the box. I have it going with...

I have setup database mail on my SQL 2005 server. It works fine. I am using it to send subscription mail. If the email addresses are good, it works fine. If there is a bad email address rather then skipping that email address, it shuts down and quits the rest of the process. Is there a way...

I am trying to install Apache / Perl / PHP and MySQL on my Windows machine. I am trying to follow the instructions I found at http://www.ricocheting.com/server/index.html but I can't get past the perl install. When I try to load the printenv.pl file, I get errors that say: The system cannot...

I totally agree with the concept of using surrogate keys (SKs). We use them exclusively but only on the dimensional side. In the facts, we combine the SKs to make up the primary key (PK). We never, ever use natural keys as primary keys on the warehouse. I guess I didn't make that clear. It...

I agree that you ought to look at your transaction log whenever performance suddenly changes. How large are the tables you are copying? Are you copying the entire table or selected rows? You may want to do a two phase process for moving the data. Many ETL products work this way. Export the...

Before you judge MySQL too harshly look at the book MySQL Enterprise Solutions. It discusses how some very large organizations are effectively using MySQL for their enterprise level servers. I am a MS SQL fan. I am a MS parner and I support many MS SQL implementations. So don't take this as...

Can you determine how the data is being queried? Look in the .ASP files a see if you can find a "SELECT" statement. If you can, is there a ORDER BY clause? If so, you can change the sort order by altering the ORDER BY clause. Otherwise, it may be that the ASP page is calling a stored...

Both Query Designer and Query Analyzer offer you opprotunites to screw up. :-) Unless you are issuing commands you do not know about you should be ok in Query Analyzer. Especially if you stick to SELECT statements. The benefit of using QA is that it forces you to write the statements and...

From a design perspective, I would recommend that you store NULLs not blanks so the data can be ignored.

We have a star schema data warehouse that has an order fact that we update nightly. We use the natural key from the source (Order Number) to locate the fact row and apply changes. The source system is preparing to purge old orders so they can reuse order numbers. They will maintain a table...

John Herman I agree with your assessment, having said that, do you see any issues with the design? Thanks again, Thom

Anand, Thanks again for your reply. I don't know that I agree with your definition of a conformed dimension. Laura Reeves, who co-authored Kimball's The Data Warehouse Lifecycle Toolkit gives the following definition in her class at TDWI: Conformed Dimension - A dimension that is shared...

Anand, Thanks for you comments, I wonder why you say the solution I outlined implies there will no longer be a conformed dimension. In fact, that was the very reason I was willing to go through the effort. In the case of, the type 1 side, the dimension conforms to the type side because they...

Views vs. multiple tables Views are slower even with indexing. If ETL complexity and space are the only costs, I can mitigate those concerns easier then the cost to performance. Space is cheap and dimensions are typically the smaller elements of the warehouse. Therefore multiplying their size...

MDXer, The uniqueness would then be lost after the third edit to the record. Or else, one version of the record would be lost.

In your example, what is the primary key to the table? It cannot be VendorID because there is no uniqueness. On the point of simplicity, I believe two tables while more difficult to manage from an ETL perspective, are actually easier from a user perspective. The reason is that the facts...

We are implementing this as two physically structures. The reasoning being that there are many facts that will only need the Type 1 dimension. A view still has to deal with the rows by excluding them and this would impact performance. Space is so cheap that we do not mind consuming it. As...

How Should We Implement A Slowly Changing Dimension? Currently, our data warehouse has only Type 1 Slowly Changing Dimensions (SCD). That is to say we overwrite the dimension record with every update. The problem with that is when data changes, it changes for all history while this is valid...