I.T. Discussion Community!
-Collapse +Expand
DBA
Search DBA Group:

Advanced
-Collapse +Expand DBA Store
PRESTWOODSTORE

Prestwood eMagazine

March Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyDBA, Databases, & Data BoardMS SQL Topic   Print This     

SQL-server 2000 performance

SQL-server 2000 performance in MS SQL topic (part of our DBA, Databases, & Data group).

Quick Search: performance   SQL server   SQL server 2000  
TR
Denmark
Does anyone have any experience with using MS SQL-server 2000 (or 7) for bulky databases (1 million+ customer register). It will recieve fairly complex statistical queries (eg. for finding customer behaviours and segmenting them).
How does it stand up to the challenge compared to eg. Oracle ?
Anything thats especially (maybe even notoriously) important to keep in mind with SQL-server ?

Regards

Torben Rohde
------------
Old UBB Archived Link: [URL=http://www.des.dk]www.des.dk[/URL]
 Posted 20 years ago (Thread Starter)
Comment Quote
About TR -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #2558, 5 replies
Thread Started 6/15/2001 12:25:00 AM
View Counter=2699
Location=Denmark  
Joined=20 years ago   MB Posts=2  
brian p kim
 (Inactive)
Honolulu
Hello TR,

I run Crystal Reports 7 and 8, CRW, against a SQL 7.0 database.

Have you had experience with CRW? Or are you a developer? For me, who only needs to get stuff out, CRW is works well.

It's efficient and fast. One thing I have been unable to do, although this may be a reflection of my skill, is an outer left join. Eg. in my left table I have three items and in my right I have 7 items, but for item number 3 corresponds to any on the left. So it's a zero value in my output. I want it to show, but I don't know how to do it with CRW.

Good luck
Aku Poke
 Posted 20 years ago
Comment Quote
About brian p kim -Collapse +Expand
Visit Profile
Inactive member.
Member does not subscribe to this thread.
Email Not Verified!
Once email is verified, we will review and approve the account.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #2562 (Level 1.1)  Reply to 2558
Thread Started 6/15/2001 3:50:00 AM
View Counter=2
Location=Honolulu  
Joined=20 years ago   MB Posts=41  
TR
Denmark
Ehhhh, what is CRW ?
I understand everthing you're writing Aku, except the (crucial) CRW part.
Yes I'm a developer.
 Posted 20 years ago (Thread Starter)
Comment Quote
About TR -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #2564 (Level 1.2)  Reply to 2558
Reply Posted 6/15/2001 4:20:00 AM
Location=Denmark  
Joined=20 years ago   MB Posts=2  
brian p kim
 (Inactive)
Honolulu
CRW = Seagate Software's Crystal Reports for Windows. Now in version 8. It's a report writer.

Hopefully there's a skilled user near you who can show you it's capabilities.

Suppose you were able to set up a "report" which allowed your end user to query once, then through click-and-drag, reformat the report with a different sort order and correct subtotals?

If such a possibility has value to your work, look into Crystal Reports. I do not know of a competing product. I have heard mention of Business Objects, but don't know anything about it.

Brian Kim
 Posted 20 years ago
Comment Quote
About brian p kim -Collapse +Expand
Visit Profile
Inactive member.
Member does not subscribe to this thread.
Email Not Verified!
Once email is verified, we will review and approve the account.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #2566 (Level 1.3)  Reply to 2558
Reply Posted 6/15/2001 5:49:00 AM
Location=Honolulu  
Joined=20 years ago   MB Posts=41  
Most Recent Post
brian p kim
 (Inactive)
Honolulu
Thanks Scott.

I've read about Views. One of the books I have on SQL Server is "Inside Microsoft SQL Server 7.0" MS Press, ISBN 0-7356-0517-3 by Soukup and Delaney. It has a short section on views.

TR, look this book up. You may find it discounted. There's a lot in it that some people may never want to know, but it may help you.

Scott, again thanks. I have to try and put the pieces together - views, storage, access rights, etc.

Brian Kim
 Posted 20 years ago
Comment Quote
About brian p kim -Collapse +Expand
Visit Profile
Inactive member.
Member does not subscribe to this thread.
Email Not Verified!
Once email is verified, we will review and approve the account.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #2585 (Level 1.4)  Reply to 2558
Reply Posted 6/15/2001 12:49:00 PM
Location=Honolulu  
Joined=20 years ago   MB Posts=41  
Scott Wehrly
Prestwood IT
 (Inactive)
Las Vegas, NV USA
I have an answer for Aku's (Brian's) OUTER JOIN problem with CRW...


I always had problems with trying to craft JOINS that weren't the garden-variety QBE-like INNER JOINS that CRW seems to enforce. I never could build the relationship in Crystal, so I turned to database VIEWS.


The beauty of SQL Server is that you can define any data relationship you like in a VIEW and optimize it in the database.


And fortunately, once the VIEW is written in the database, CRW treats it just like any table.


Whenever I've had to craft CRW reports on a database with a sophisticated 4NF or 5NF relational design, every report band got its own VIEW.


For instance, if I want to produce a report of all customers with orders, and still show those customers who don't have any orders in the database, I'd create this view:


CREATE VIEW Customer_Orders
(Customer_ID, Last_Name, First_Name, Order_ID, Order_Date, Shipped_Date)
AS SELECT c.Customer_ID, c.Last_Name, c.First_Name, o.Order_ID, o.Order_Date, o.Shipped_Date
FROM Customers c LEFT OUTER JOIN Orders o
ON c.Customer_ID = o.Customer_ID
ORDER BY c.Last_Name, c.First_Name


My report band in Crystal would just use Customer_Orders as its data source! Customers with no orders would have NULL values in the Order_ID, Order_Date, and Shipped_Date columns. Customers with more than one order in the database would appear with one row per order, so if I wanted to do grouped banding to show all of a customer's orders on one page, this VIEW would provide that capability.

Now that
 Posted 20 years ago
Comment Quote
About Scott Wehrly -Collapse +Expand
Visit Profile
Inactive member.
Member does not subscribe to this thread.
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #2568 (Level 1.5)  Reply to 2558
Reply Posted 6/15/2001 7:22:00 AM
Location=Las Vegas, NV USA 
Joined=19 years ago   MB Posts=442   KB Posts=19  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P123A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #2558 Counter
2699
Since 4/2/2008

Follow PrestwoodBoards on: 


©1995-2021 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech