Database Articles

    Articles ZONE

  • Database

 
Article Author
"Top 10 customers by salesperson" sound familiar? Yes! I would expect so, and am sure there are a number of other great business analyses with a similar principle now flowing through your mind.

So, how do you query this data in your SQL system?

No answer; no worries! This article aims to answer that question for you. As the title suggests, this comes down to knowing a customer's rank with respect to other customers for a given salesperson and then selecting just those customers with a rank no greater than 10.
...
Article Author

One of the regular tasks for a SQL Developer (or DBA) is to UPDATE data of existing rows, after they are in the table. A simple example, to update an existing row, based on the primary key, would look like this: UPDATE tbl_employee
SET last_name = 'whatever'
WHERE ssn = '123-456-789';Easy enough, and the same syntax works for all database engines the same.

But in this article, we will check to see what the syntax is, and what errors newcomers run into, when the data has to ...
Article Author
DATE and TIME ... don't be scared, just do it right

DATE,TIME,MS SQL Server,MySQL,Oracle



I presume you all have already worked with databases and queries, and found some difficulties to get the date/time stuff right. Though it's not rocket science, the purpose here is to teach you how to handle date and times, and to avoid implicit data type conversions.
NOTE: I refer to the versions MSSQL Server 7 through ...
Article Author
There are ONLY 3 ways to speed up MySQL, and everything else is simply a finer point of one of these 3 ways. Here they are, in order of importance:

1. Optimize queries
2. Tune the MySQL configuration
3. Add more hardware


============================================================
#1. Query Optimization
===============================...
 
 

Database Articles

 
 
Articles Help

Have a question about Articles or need ideas for what to write? Check out these links:

Write an Article
 
 
Motorola Droid Smartphone

Already purchased the new Motorola Droid? We want to hear from you! Tell us what you think about it and Google's Android 2.0 software.

 
 
Filter: Date
mwvisa1 commented on an article! Reporting On Data From Stored Procedures (part 2) 11/21/09 05:11 PM
mwvisa1 found an article helpful! Reporting On Data From Stored Procedures (part 2) 11/21/09 05:10 PM
mark_wills found an article helpful! Reporting On Data From Stored Procedures (part 2) 11/21/09 04:55 PM
ValentinoV article was published! Reporting On Data From Stored Procedures (part 2) 11/21/09 04:46 PM
ValentinoV article was EE Approved! Reporting On Data From Stored Procedures (part 2) 11/21/09 04:46 PM
harfang wrote a Tip/Trick! Access Fast Lookup in Finance 11/21/09 04:12 PM
ValentinoV wrote a Tutorial! Reporting On Data From Stored Procedures (part 2) 11/21/09 02:00 PM
RiteshShah wrote a Tutorial! Audit in SQL Server 2008 11/20/09 01:04 AM
Luigee found an article helpful! Chart Optimization Tips 11/17/09 06:53 AM
mwvisa1 commented on an article! Analytical SQL : Where do you rank? 11/16/09 07:37 PM
Recent Activity:
1 - 10 of 15
 

Browse All Articles