While you can use type 2 SCDs (and any other implementation of an SCD) in SSAS, it is not the thing that implements them.
You need to implement them in a Datamart/Datawarehouse and SSAS will then read them from there. What might be of interest to you is the Slowly Changing Dimension task in SSIS. It's not the quickest of components, but it does allow you to use a GUI to define the columns that you want to tracking history on.
Is this true?
I know I didn't need an account when I've set it up before...but I
might have been using a POP3 server.
I have Outlook 2003 installed on the server. Windows 2003 Enterprise.
Thanks.Hi
If you are using SQL Mail you will need a MAPI profile, and if you are
connectng to an exchange server you will need an account on that server. You
could connect to a POP3 server or alternatively you could check out
http://www.sqldev.net/xp/xpsmtp.htm.
For more information check out
http://msdn.microsoft.com/library/d...erverE-mail.asp
http://support.microsoft.com/kb/281293
http://support.microsoft.com/kb/263556/
You may want to use an older version of Outlook, if you are POP3.
John
<mchi55@.yahoo.comwrote in message
news:1157150726.360290.48890@.i42g2000cwa.googlegro ups.com...
Quote:
Originally Posted by
>I just read that if you use an exchange server...the account that you
start SQL with needs a mail on the exchange box.
>
Is this true?
>
I know I didn't need an account when I've set it up before...but I
might have been using a POP3 server.
>
I have Outlook 2003 installed on the server. Windows 2003 Enterprise.
>
Thanks.
>
Hello there,
i have a great doubt: does MSDE run on XP Tablet Edition? I bought a beautiful notebook but didn't notice that it runs XP tablet...
Thanks in advance
Yes it doesI've got a 32-bit server with 16GB memory. In SQL Server, AWE is enabled. Does SQL use AWE memory for everything possible? I've also got SSAS installed on that same box, and SSAS can't use AWE memory. So I want SQL to use AWE memory as much as possible to leave as much free for SSAS as possible.
As I understand it, when you set the max server memory setting for SQL Server, it prevents the sum of normal and AWE memory from going over that limit you've set. Is there any way to tell SQL server to use as much AWE memory as it wants, but be use as little normal memory as it can?
SQL Server uses AWEonly for data cache pages in the buffer pool. As far as I know this can't be changed (in any supported fashion).Also, I could be wrong here, but I believe the 3 GB limit is per process, meaning you could have two individual processes that don't support AWE each using 3 GB on a 16 GB system - they wouldn't be limited to a grand total of 3 GB between them. Where AWE comes in is allowing a single process to use more than 3 GB by itself. I'm sure the OS guys can correct me if my assumptions about AWE are incorrect.
|||
We're on the right track to answering my question. Do all pages that it caches use AWE memory exclusively? (Does it use AWE whenever possible?) Will it ever cache pages using normal memory if AWE is on and there is still AWE memory available?
I've put a 1GB limit on SQL so as to leave plenty of room for SSAS. I'm wondering if removing that limit on SQL will cause it to use more normal memory, or just more AWE memory.
I'm pretty sure it's 3GB total across all processes, not per process.
|||Well, there's the buffer cache and the procedure cache. The buffer cache, which holds actual data, will use AWE if it's enabled. The procedure cache doesn't use that, but I don't believe it'll end up nearly as large as the buffer cache under normal circumstances.As for whether or not non-AWE applications are limited to 3 GB each, or 3 GB total, I think we'll need a more authoritative answer from someone on that, since it has a significant effect on how to handle the situation. This KB article makes me think it's 3 GB each, but I'm not 100% certain: http://support.microsoft.com/default.aspx/kb/283037
To get an idea of how memory is being allocated, compare the Performance Monitor counter SQLServer:Memory Manager\Total Server Memory (KB) to the amount of memory that Task Manager reports (which doesn't include AWE allocations).
|||
If you set max server memory, it limits how much memory, total that the database engine can use, whether it is AWE or not. I have not heard of any way to try to force SQL Server to use AWE memory first.
If you are concerned about memory, and have 16GB of RAM, you should seriously consider running 64-bit, with the "Lock Pages in Memory" right granted to the SQL Server service account. That is assuming your processors are 64-bit capable (which they should be if they are less than about two years old). I have some good DMV queries here:
http://glennberrysqlperformance.spaces.live.com/blog/cns!45041418ECCAA960!526.entry
sqlI have two optional fields on my form (RangeFrom and RangeTo). If the user chooses not to enter data into these textboxes(textbox = ""), an entry on the db is created with null values. It works.
But sometimes the user wants to enter 0 as either an upper or lower end of a range. This is where my problem comes in. My program saves 0 as null too.
In my program I do a test on the textboxes and populate two float values in a business object (objQuestion) accordingly, like this:
if (txtrangefrom.Text != "") {
objQuestion.RangeFrom=float.Parse(txtrangefrom.Text);
objQuestion.RangeTo=float.Parse(txtrangeto.Text);
}
else {
objQuestion.RangeFrom=Convert.ToSingle(null);
objQuestion.RangeTo=Convert.ToSingle(null);
}
And this is what my Business object look like. It sets up the parameters and calls the Data Access Application Block to create an entry in my table:
// fieldslist
float cvintRangeFrom;
float cvintRangeTo;//properties
public float RangeFrom {
get {
return cvintRangeFrom;
}
set {
cvintRangeFrom = value;
}
}public float RangeTo {
get {
return cvintRangeTo;
}
set {
cvintRangeTo = value;
}
}// some code deleted for readability...
public int AddOption() {
string cvstrSpName = "addOption";
SqlParameter [] cvstrStoredParams = SqlHelperParameterCache.GetSpParameterSet(gcstrConnectionString, cvstrSpName, true);
//lines deleted for readability...
//check if the optional fields have a value associated with them. if not, assign dbnull.value.
cvstrStoredParams[4].Value=(cvintRangeFrom != Convert.ToSingle(null) ? cvintRangeFrom : (object)DBNull.Value);
cvstrStoredParams[5].Value=(cvintRangeTo != Convert.ToSingle(null) ? cvintRangeTo : (object)DBNull.Value);
//lines deleted for readability...
SqlHelper.ExecuteNonQuery(gcstrConnectionString, CommandType.StoredProcedure, cvstrSpName, cvstrStoredParams);
return(cvintOptionID = Convert.ToInt32(cvstrStoredParams[0].Value));
}
I use Convert.ToSingle when working with nulls (or possible nulls) because I get an error when I use float.parse for this.
The thing is, after this method AddOption has been executed, I test the value if the business object's rangefrom (that is where I entered 0) and display it on my form. I still shows a 0, but on my database table it is null!
objQuestion.AddOption();
//txtrangefrom.Text=""; on the next line I test the value in the business object...
txtrangefrom.Text=objQuestion.RangeFrom.ToString(); // and this displays 0!!!
//txtrangeto.Text="";
txtrangeto.Text=objQuestion.RangeTo.ToString();
So to me it seems the problem seems to be either the DAAB or on the SQL side, but hopefully somebody can prove me wrong! I was thinking that it could also be float.parse/Convert.ToSingle methods and have done various tests, but I am none the wiser...
Any help or ideas will be greatly appreciated...I had this same problem with a VB project.
Just change the value of the floats to something that is not within the valid range (-1 or something) instead of null. It's not pretty or elegant, but it's better than fiddling with nulls ;)
SQLServer (I think) does implicitly convert 0 to null in some occasions, but I don't know the full details.
HTH|||You're right, it's not pretty, but I'll give it a go.
Thanks.
Does Sql server 2005 standard edition support Sql server integration services and SSRS. i saw two conflicting information.
And what is the difference between Integration services with basic transforms and integration services advanced transforms.
Please recommend.
Yes.
The following advanced transformations are available only in Enterprise edition related on SSIS:
Analysis Services Partition Processing Destination - with it you can perform incremental, full, or update processing of a AS partition.
Analysis Services Dimension Processing Destination for loading and processing a dimension.
Data Mining Training and Data Mining Query Component
Fuzzy Grouping, Fuzzy Lookup
Term Extraction and Term Lookup -used for "Text Mining"(Text Data Mining that work good for english texts)
So if you want to use SSIS package to process a cube, data mining structure and crossroad of bad data(Fuzzy Grouping, Fuzzy Lookup) you need Enterprise Edition.
|||Can we use
SSIS
SSRS
ONLINE PROCESSING USING .NET
BATCH PROCESSING USING .NET
all in the same server. is there any performance issue related to standard 2005 vs enterprise 2005
Thanking you.
|||In terms of comparing standard and enterprise on same machine , sure no, but you have limits on Standard:
-hardware level : max 4 CPU on server
-software level :NO partitioning, indexed views, and more
An article of this comparison
|||Thankyou> Using prepared statements like Oracle does? This way in a high transaction
> system you do not have to recompile queries every time?
Yes it does have this capability.
Joe Weinstein at BEA|||"Ryan" <rgaffuri@.cox.net> wrote in message news:<ZVlPb.5755$_H5.281@.lakeread06>...
> Using prepared statements like Oracle does? This way in a high transaction
> system you do not have to recompile queries every time?
In general, query plans are cached (unless they're very simple), but
may be aged out of the cache if they're not used. Stored procedures
are generally the most efficient way to code, although they may be
recompiled in some situations. Profiler can show cache hits, misses
and recompilations for stored procs.
Simon|||Hi Ryan
Yes every database i know of including sql server will make use of
bind varaiables..bind varaiables are not the exclusive doamin of
oracle.
regards
Hrishy
"Ryan" <rgaffuri@.cox.net> wrote in message news:<ZVlPb.5755$_H5.281@.lakeread06>...
> Using prepared statements like Oracle does? This way in a high transaction
> system you do not have to recompile queries every time?
1) XMLElement
2) XMLAttributes
3) XMLForest
Thanks in Advance for your reply
Bye
Amardeep VermaAmardeep Verma (addverma@.netscape.net) writes:
> Do any versions of SQL Server support the following functions, as
> they appear in the Oracle Database:-
> 1) XMLElement
> 2) XMLAttributes
> 3) XMLForest
> Thanks in Advance for your reply
Since I don't know Oracle, I don't know what these functions do. It is
not likely that SQL Server supports these functions directly, but it
may support the same functionality. You would need to explain what these
functions do to get answer.
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Hi,
Thanks Erland for your Response. These Functions take simple
SELECT statement and return the result in a XML format. With each
Column name as a tag and the value in that column as the data.
For Example the Employee Table of NorthWind Database has 3
columns:-
1) EmpNo
2) EmpLastName
3) EmpFirstName
Then using the below mentioned functions we can get the output
<EMP>
<EMPNo>1</EMPNo>
<EMPFirstName>ABC</EMPFirstName>
<EMPLastName>XYZ</EMPLastName>
</EMP
Hope this helps
Amardeep Verma
Erland Sommarskog <esquel@.sommarskog.se> wrote in message news:<Xns9536EC50E4C4FYazorman@.127.0.0.1>...
> Since I don't know Oracle, I don't know what these functions do. It is
> not likely that SQL Server supports these functions directly, but it
> may support the same functionality. You would need to explain what these
> functions do to get answer.|||Amardeep Verma (addverma@.netscape.net) writes:
> Thanks Erland for your Response. These Functions take simple
> SELECT statement and return the result in a XML format. With each
> Column name as a tag and the value in that column as the data.
> For Example the Employee Table of NorthWind Database has 3
> columns:-
> 1) EmpNo
> 2) EmpLastName
> 3) EmpFirstName
> Then using the below mentioned functions we can get the output
><EMP>
> <EMPNo>1</EMPNo>
> <EMPFirstName>ABC</EMPFirstName>
> <EMPLastName>XYZ</EMPLastName>
></EMP
It looks like you should study the FOR XML clause in the SELECT statement.
It gives you several possibilities. Rather than typing examples here,
I refer you to Books Online myself, since I am no XML wizard myself.
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||SQL sever has a few ways to generate xml. An example below that
conforms to your spec(ie columns as elements) can be viewed in QA
select * from employees
where employeeid=1 for xml auto, elements
NOTE: it is best run when the query is set to 'Results in text' and
also
'DBCC TRACEON(257)' has been run first
Maybe there's another better way to do this... Anyway, here's what I'm trying to do:
I have two tables CarType & Cars. Table CarType has a column CarTypeId which is the primary key (int, identity). Table Cars includes a column CarTypeId (int) which is a foreign key into the CarType table.
Now I am trying to build a list of all those CarTypeId entries (from the CarType table) for which there are no Cars (i.e. there is no corresponding entry in the Cars table).
I read that there is an SQL "MINUS" keyword that you can use like this:
SELECT CarTypeId FROM CarType
MINUS
SELECT CarTypeId FROM Cars
So if CarType contains records with the keys {1, 2, 3, 4, 5} and Cars contains records with the foreign keys {2, 4} (using set notation), your result should be the set {1, 3, 5}. (Note: I have tried alternate versions of this where I selected the DISTINCT CarTypeId entries from Cars, and where I sorted them; results same in both cases).
I tried it in SQL Server 2005 Express. The result is just {1, 2, 3, 4, 5}.
My questions:
Here's a reference to the website where I initially found out about MINUS:
http://www.1keydata.com/sql/sql-minus.html
Thanks in advance for your time/comments.
I think you want EXCEPT
ms-help://MS.VSCC.v80/MS.VSIPCC.v80/MS.SQLSVR.v9.en/tsqlref9/html/b1019300-171a-4a1a-854f-e1e751de3565.htm
|||You can also use a NOT EXISTS to find records that don't exist in the other table|||Thanks Simon for your comments and pointing me in the right direction.
This is what worked for me:
SELECT CarTypeId FROM CarType
WHERE (CarTypeId NOT IN
(SELECT DISTINCT CarTypeId FROM Cars)
)
Still interested to know what became of the MINUS keyword though, because I think that syntax is slicker...
Ian
|||SQL Server has never supported MINUS.
in SQL 2005 it now has the EXCEPT clause which does the same thing
|||Caution: Microsoft talks about this issue at https://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part2/c0761.mspx?mfr=true. However, it is incomplete in that it does not address a curveball.
That is, the = operator does not address nulls.
The Microsoft example is as follow:
Oracle Microsoft SQL Server
SELECT CCODE, CNAME
FROM DEPT_ADMIN.CLASS
MINUS
SELECT C.CCODE, C.CNAME
FROM STUDENT_ADMIN.GRADE G,
DEPT_ADMIN.CLASS C
WHERE C.CCODE = G.CCODE
SELECT CCODE, CNAME
FROM DEPT_ADMIN.CLASSC
WHERE NOT EXISTS
(SELECT 'X' FROM
STUDENT_ADMIN.GRADE G
WHERE C.CCODE = G.CCODE)
This will work to identify students in one table but not in another. However, it will not work like Oracle's MINUS command to spot differences between tables. So, say you want to see this -- between the 2 tables, find where students are missing AND students whose names have changed -- either from A to B or from not null to null or from null to not null.
Try this:
SELECT CCODE, CNAME
FROM DEPT_ADMIN.CLASS C
WHERE NOT EXISTS
(SELECT 'X' FROM
STUDENT_ADMIN.GRADE G
WHERE C.CCODE = G.CCODE
and (C.CNAME = G.CNAME or (C.CNAME is null and G.NAME is null) )
That will mimic the full functionality of Oracle's MINUS command in SQL Server 2000 T-SQL.
|||Hi Ian,
I havent come across the Minus in SQL server but to do what you want I would try the following
SELECT T.cartypeid
FROM cartype as T
LEFT OUTER JOIN cars C
ON T.cartypeID = C.cartypeID
WHERE c.caretypeID is null
This joins everything in the cartype table but the where clause restricts the result set to those records with a null car.cartypeID
i.e. no matching record
Maybe there's another better way to do this... Anyway, here's what I'm trying to do:
I have two tables CarType & Cars. Table CarType has a column CarTypeId which is the primary key (int, identity). Table Cars includes a column CarTypeId (int) which is a foreign key into the CarType table.
Now I am trying to build a list of all those CarTypeId entries (from the CarType table) for which there are no Cars (i.e. there is no corresponding entry in the Cars table).
I read that there is an SQL "MINUS" keyword that you can use like this:
SELECT CarTypeId FROM CarType
MINUS
SELECT CarTypeId FROM Cars
So if CarType contains records with the keys {1, 2, 3, 4, 5} and Cars contains records with the foreign keys {2, 4} (using set notation), your result should be the set {1, 3, 5}. (Note: I have tried alternate versions of this where I selected the DISTINCT CarTypeId entries from Cars, and where I sorted them; results same in both cases).
I tried it in SQL Server 2005 Express. The result is just {1, 2, 3, 4, 5}.
My questions:
Here's a reference to the website where I initially found out about MINUS:
http://www.1keydata.com/sql/sql-minus.html
Thanks in advance for your time/comments.
I think you want EXCEPT
ms-help://MS.VSCC.v80/MS.VSIPCC.v80/MS.SQLSVR.v9.en/tsqlref9/html/b1019300-171a-4a1a-854f-e1e751de3565.htm
|||You can also use a NOT EXISTS to find records that don't exist in the other table|||Thanks Simon for your comments and pointing me in the right direction.
This is what worked for me:
SELECT CarTypeId FROM CarType
WHERE (CarTypeId NOT IN
(SELECT DISTINCT CarTypeId FROM Cars)
)
Still interested to know what became of the MINUS keyword though, because I think that syntax is slicker...
Ian
|||SQL Server has never supported MINUS.
in SQL 2005 it now has the EXCEPT clause which does the same thing
|||
Caution: Microsoft talks about this issue at https://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part2/c0761.mspx?mfr=true. However, it is incomplete in that it does not address a curveball.
That is, the = operator does not address nulls.
The Microsoft example is as follow:
Oracle Microsoft SQL Server
SELECT CCODE, CNAME
FROM DEPT_ADMIN.CLASS
MINUS
SELECT C.CCODE, C.CNAME
FROM STUDENT_ADMIN.GRADE G,
DEPT_ADMIN.CLASS C
WHERE C.CCODE = G.CCODE
SELECT CCODE, CNAME
FROM DEPT_ADMIN.CLASSC
WHERE NOT EXISTS
(SELECT 'X' FROM
STUDENT_ADMIN.GRADE G
WHERE C.CCODE = G.CCODE)
This will work to identify students in one table but not in another. However, it will not work like Oracle's MINUS command to spot differences between tables. So, say you want to see this -- between the 2 tables, find where students are missing AND students whose names have changed -- either from A to B or from not null to null or from null to not null.
Try this:
SELECT CCODE, CNAME
FROM DEPT_ADMIN.CLASS C
WHERE NOT EXISTS
(SELECT 'X' FROM
STUDENT_ADMIN.GRADE G
WHERE C.CCODE = G.CCODE
and (C.CNAME = G.CNAME or (C.CNAME is null and G.NAME is null) )
That will mimic the full functionality of Oracle's MINUS command in SQL Server 2000 T-SQL.
|||Hi Ian,
I havent come across the Minus in SQL server but to do what you want I would try the following
SELECT T.cartypeid
FROM cartype as T
LEFT OUTER JOIN cars C
ON T.cartypeID = C.cartypeID
WHERE c.caretypeID is null
This joins everything in the cartype table but the where clause restricts the result set to those records with a null car.cartypeID
i.e. no matching record
Hi, all,
I try to start SQL Server, but I got the Error in "ERRORLOG":
Starting up database 'master'.
The file "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.
Error: 5118, Severity: 16, State: 1.
That means, I have to decompress the file "mastlog.ldf", right?
How can I do this?
Thanks in advance!
it means somebody has changed the OS level setting of this folder or it parent folder... In property of the folder
in General Tab Press Advance button and see whether "Compress Contents to Save disk " option is choosed ... if it is there then remove that
Madhu
|||Thank you! Madhu,
yes, I have done, It works 
I had the software email me the data immediately before adding the data to SQL Server. It was appearing correctly with respect to the foreign language character format. The software does the database add and then returns a list of records currently in that table. The information for Japanese or Hebrew entries is always a string of question marks, e.g. ?
I have been told that the only solution is individual databases for those languages. Is this true?SQL Server supports all languages using UNICODE. You don't need a separate database for each language.
There may be some issues with collation order if you have strings from different languages in the same column. You have to choose a particular collation for the column so indexing can work correctly. The collation you choose may give some unconventional ordering for sorted data in some languages because the conventional ordering differs from region to region. Sharp s, ?, is ordered the same as s in English, but not in German Phonebook, for example. You can specify a collation based on the UI locale for your result ordering in queries to overcome this.
The "?" problem generally happens when you convert UNICODE data to multi-byte using the incorrect locale. If your application must use multi-byte characters for some reason, make sure the locale matches the data's language. If your middle-tier and UI can use UNICODE data directly, its best to avoid the wide character to multi-byte and multi-byte to wide character conversions so this problem doesn't occur.|||You don't understand the problem
1.) The Internet is global in nature.
2.)I have 1 database
3.) data is entered from the contents of a form in a program
4.) customers can come from anwhere in the world. They speak many languages. They fill out the form in their native language (Hebrew, Japanese, etc.) The form contents write to the database.
5.) The database field types are nchar, nvarchar and ntext.
6.) the table has 10 fields. There are 15 tables. If these fields have to be replicated for each unique language, and we assume about 10,000 different languages in the world, the database will not fit on any known hard drive. It will require hundreds of programming hours to determine what language the input data is in and what set of table elements they should go to or be retrieved from (once we figure out what language the viewer uses).
7.) If all of the above is true, any new languages can not be used without prior setup.
8.) Why does MySQL handle this and not SQL Server?
We're not looking to translate anything. What we want is something eminently simple. Whatever they write, in whatever language, goes into the database. When that record is retrieved, whatever is in the record, in any language, is returned as data, unaltered.
There's no sorting and no reporting. The database holds the data and it's delivered when asked for.
Surely there is a solution here that doesn't involve something almost as complex as cloning humans.|||
You don't need to replicate your data for each language. You just need to make sure your application stack is using UNICODE strings from end-to-end, including the web forms that are displaying the data. You've already got the SQL Server end covered if you are using nothing but nchar, nvarchar, and ntext.
I saw the ? problem many, many times back when I was working on international programs that used ANSI strings. The system function that does the UNICODE-to-multi-byte translation uses question-marks for the characters it can't translate into the specified multi-byte locale. In my applications, the problem was never in the server, it was always in my application. Invariably, my application was trying to convert UNICODE data from the server into multi-byte (ANSI) characters in my application, but the locale I had specified for the translation was incorrect for the data, so there was no mapping from the UNICODE data to the ANSI locale. (For example, there is no representation for Japanese characters in the ANSI Hebrew code page.) I stopped seeing this problem once the applications I was working on used nothing but UNICODE in the database, database access layer, middle-tier, and the UI.
The next things I would check are whether you've specified UNICODE strings as the data types in your data access layer (ADO automatically converts between UNICODE and ANSI strings if you tell it you want ANSI strings for example) and whether the UI is using UNICODE or ANSI display controls. Those have been the areas where I've had the most trouble with globalized applications in the past.
I hope this helps,
Steve
