MSDN Magazine May 2002
View Complete Post
This link Handling Data Integrity Issues in Analysis Services 2005 is a classic
paper on handling data integrity. The snowflaked data structure decribed in it is:
Product Class (dimension) <-- Product (dimension) <-- Sales (fact) where some Products do not have a Product Class
My situation is similar, but a bit more complex. I don't actually have referential integrity problems . . . orphans are
I have two fact tables TableA and TableB. They are related in a [0-or-1] to a [0-or-many] structure.
That is, each TableA record may have zero, one, or many TableB records associated with
I migrate my db from oracle to sql server using ssma for oracle.
after migration, i still use nextval function that created by ssma.
the problem is, the function is not consistent.
Sometimes, it produce values, but in other times it produce null.
The strange part is, the sequence between last number and after null number is still on sequence, example:
1st call >> 1
2nd call >> 2
3rd call >> NULL
4th call >> NULL
5th call >> 5
can you explain how to fix this problem?
thank you verymuch
DECLARE @techNumLoop VARCHAR(25)
DECLARE @myTemp TABLE
,Item_Count Integer NULL
,Expenses MONEY NULL
DECLARE techCursor CURSOR
SELECT DISTINCT t.Case_Number Tech
FROM tblTechnology t
FETCH NEXT FROM techCursor INTO @techNumLoop;
WHILE @@FETCH_STATUS = 0
HI, I have a aggregate function that calculates median in all cases excet if every value that is being passed in is null and I cant seem on how to fix it. I beleive it has to do with either the read or write methods below is the code that I am using and
the error. Any help on this would be greatly appreciated. Thanks in advane.
Here is the content page:
What is the proper way to check for null or empty strings on dynamic objects? This is the only solution I've found so far:
if (admin.PasswordHash.GetType() == typeof(DBNull) || admin.PasswordHash == string.Empty)
If the field is null, the object returned is DBNull.Value, but if the field is empty string, it's return as a System.String object. This makes it impossible to do regular "admin.PasswordHash == DBNull.Value" check, as that will fail whenever the field has been set to empty string. Is my example the right (and only) way to go?
I have run into a problem with optimistic concurrency in my dynamic data application (where all relevant settings are at their default values); when I try to update or delete one of my tables, I see the following error:
Exception type: ChangeConflictException Exception message: Row not found or changed.
I am the only user of my database at the moment, so I can guarantee that the data both exists and has not been changed outside the application!
Various forums have suggested that the way to deal with this is to set the column attributes so that the concurrency checking is disabled; i.e.
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_PropSurname", DbType="NVarChar(255)", UpdateCheck=UpdateCheck.Never)]
However, to do this manually through the Visual Studio designer will take me hours (I have a lot of tables) and if I then change the schema of one of the tables in the DB, won't I then have to do it all again? I've tried editing the .designer.cs file directly but my changes are subsequently overwritten (as expected).
All suggestions gratefully received!
We've been trying to fix this one for a couple years, and I'm just out of ideas, so any help is really appreciated!
We've got a fairly large, complex web application that uses Forms Authentication to authenticate users. Throughout the application we store and retrieve information about users in the Session object, and in some cases in cookies. In a couple places we check for the existence of the context, and if it's null we send the user back to the login page to re-establish the session.
Just a quick run-down of this web app: C#, .NET 3.5, IIS 6, ASP.NET State Service to manage session
As for the session timer, we use our own home-grown timer, which is basically a client-side timer, which is backed up by a check to the SQL database to see when their last activity was. This seems to work well for us. It's not perfect, but it allows us to notify the user before the session times out, and allows us to be certain we're not logging a user out before their 60 minutes of inactivity is up.
What's happening is that certain users are being logged out after just a few minutes. We've eliminated the timer as a cause and believe what's happening is the HttpContext.Current is null, so the user is logged out. We do not know why the HttpContext.Current is null, and I underst
I dont have the SQL EXPRESS installed instead I have SQL Standard Edition.
I have two SQL Server instances installed.
1- UserLT (this is sql 2000)2- UserLT\SQL2005 (this is SQL 2005 named instance)
But when i try to add a database to my VS website project I get the following error:
Connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly. please verify the installation of the component or download from the URL: go.microsoft.com/fwlink/?linkId=4925
I went in Tools>Opetions>DataBase tools>Data Connection>Sql Server Instance Name (blank for default)
and changed the "SQLEXPRESS" to "USERLT\SQL2005".
But I still get the same error message. Any ideas how i can resolve this issue?