Showing posts with label client. Show all posts
Showing posts with label client. Show all posts

Wednesday, March 28, 2012

Latest version of MSDE

What is the latest version of MSDE (and SQL Server)
that I can install for a client that uses Windows XP ?
SQL Server 2000 SP3 ?Originally posted by Karolyn
What is the latest version of MSDE (and SQL Server)
that I can install for a client that uses Windows XP ?

SQL Server 2000 SP3 ? http://www.microsoft.com/sql/msde/downloads/download.asp|||you're early today !
happy new year !

Is there some significant performance increase
between SQL Server 7 and SQL Server 2K ?
'Cause I've done all my tests on SQL Server 7 and MSDE 7
and I was'nt impressed by the performances
(that we're comparable with thoses I had with Sybase)|||Originally posted by Karolyn
Is there some significant performance increase
between SQL Server 7 and SQL Server 2K ?

Cant comment much on that !! have not worked much on SQL Server 7.0|||Performance increases - New datatype(table), views (ability to index and partition), index enhancements such as ability to index a computed column and index creation, how text/ntext/image are stored ...

Read this article:

link (http://msdn.microsoft.com/msdnmag/issues/0800/sql2000/default.aspx)|||You left out UDFs?|||That was referencing performance increases - udfs offer reusability,maintainability and extensibility ... Anyway, all the benefits of sql server 2000 are included in the link.|||Also ... don't mention udfs for a while after the permissions bug :-)|||yeah, brett, you almost started it again|||Originally posted by rnealejr
Also ... don't mention udfs for a while after the permissions bug :-)

hey !!! what was that ??|||well, rdjabarov and blindman got at it again when an m$ bug was being discussed. apparently neither one of them can hold their waters :-)|||?? :confused: ??|||hey, it's simple:

one is a man, and another...is also a man...does it make sense?? :-)|||I mean ... can you point me to the battleground ... i would like to see the war for myself :D|||just read from the beginning (http://www.dbforums.com/t977030.html)

Monday, March 26, 2012

lastnonempty

Hello,

How can i implement lastnonempty for a dimension that is not a time dimension?

Example: I have a Client, Type and Time dimension and a facttable FactClient; and i want to apply the lastnonempty measure to the Client dimension not to the Time dimension. How can i do that?

If you need more information, please ask.

Thank you,

Vulcano

Sorry, i forgot the example:

The fact table:

Client Type Date Value

John Type1 1 Aug 2006 5

John Type2 5 Aug 2006 3

John Type2 25 Aug 2006 7

Mary Type1 3 Aug 2006 1

Mary Type2 7 Aug 2006 9

Mary Type1 15 Aug 2006 15

Eric Type1 20 Aug 2006 3

I want to get at the end of the month:

Month Aug 2006 John Type2 10

Mary Type1 15

Eric Type 1 3

Thank you,

Vulcano

|||

Given that the last entry for John is:

John Type2 25 Aug 2006 7

why is the month-end total for John 10, rather than 7?

Month Aug 2006 John Type2 10|||

Thanks, for your reply Deepak

The entry for John at the end of month is 10, because the last 2 entries for John have TYPE2 (3+7=10).

I need to take the last entries for a client that have the same TYPE.

Thank you

sql

Friday, February 24, 2012

large query

I have query from SQL server 2000 which returns from database very large.
However I show client only 20 records per page. I need to find way which
allows to get from database only what I need (like top 100). Response from
database about 10mins which is not acceptable.
Look at this article for ideas about paging.
Paging Queries
www.aspfaq.com/2120
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Aleks Kleyn" <AleksKleyn@.OptOnline.net> wrote in message
news:DD4DE5D1-82EF-4E2A-A46A-7E8FB7407135@.microsoft.com...
>I have query from SQL server 2000 which returns from database very large.
>However I show client only 20 records per page. I need to find way which
>allows to get from database only what I need (like top 100). Response from
>database about 10mins which is not acceptable.

Monday, February 20, 2012

Large move from Access to SQL Server 200

Hi,

My client has a rather large database with some very large reports. Some of the reports have around 20 sub-reports a piece. We have decided to move the client's application to a .NET web application and would migrate them to SQL Server 2000.

The only problem is now, designing the reports. I have tried doing what Microsoft says (converting to stored procedures and views) but I keep getting syntax errors on the SQL side of things when I cut and paste.

For example, the following code is taken from Access :

SELECT tblProjects.fldCountry, tblProjects.fldDescription, tblOrganizations.fldAcronym, tblProjects.fldProjID, Max(tblProjYears.fldStartDate) AS MaxOffldStartDate, Max(tblProjYears.fldEndDate) AS MaxOffldEndDate, qryProjLocsWithFEData.fldProjPeriodID
FROM (tblProjects INNER JOIN tblOrganizations ON tblProjects.fldOrgID = tblOrganizations.fldOrgID) INNER JOIN (tblProjYears INNER JOIN qryProjLocsWithFEData ON tblProjYears.fldProjPeriodID = qryProjLocsWithFEData.fldProjPeriodID) ON tblProjects.fldProjID = tblProjYears.fldProjID
GROUP BY tblProjects.fldCountry, tblProjects.fldDescription, tblOrganizations.fldAcronym, tblProjects.fldProjID, qryProjLocsWithFEData.fldProjPeriodID
ORDER BY tblProjects.fldCountry, tblOrganizations.fldAcronym, tblProjects.fldProjID;

But when I try that in SQL Query Analyzer i get the error : The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.

I'm pretty sure it's on the tblProjects.fldDescription Group By, but if I leave it out, it still throws an error. Anybody have any ideas?

ThanksGROUP BY Description?

Another Classic Access example...

LOOK OUT! RUN AWAY TRAIN...ummmm developers...

Do you have a lot of nested Access queries as well?

Have you tried just linked the SQL Server tables?

Have you given any thought to a re-write?|||Actually we can't link to the Access db. Everything has to be stored in the SQL database.|||I meant the old access app, with no tables, linked to the sql server database...

are the table and column names still all the same?

If you link it, it should all run...

might be very slow though...

but at least you'll have all your reports...|||Without and more infomation, it looks like the Access upgrade thingy (whatever they call it now) has morphed soem of your text fields to TEXT or NTEXT. If you want to be able to join on these fields, they need to be CHAR, VARCHAR (or NCHAR, NVACHAR).

Your first step after running that thing is to go through the whole database, field by field, and see what has happened to your data in the translation.

Almost as easy to do it manually.

-bpd|||I ended up doing all of the queries as views and getting rid of the one text field, then on the final query, joined the text field, thus by-passing the Group By clause for that field. Thanks for all the help though.