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
 
 
2000th Corporate Account

2000 organizations, including eBay, Ericsson, and Lockheed Martin, now work smarter with Corporate Accounts. Save over 36%!

 
 
Filter: Date
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
aneeshattingal commented on an article! Analytical SQL : Where do you rank? 11/16/09 04:03 PM
CosmicPrune found an article helpful! Dynamic Pivot Procedure for SQL Server 11/16/09 12:28 PM
grtraders found an article helpful! Pie Chart Techniques 11/16/09 06:19 AM
DavyKnuysen found an article helpful! Pie Chart Techniques 11/16/09 04:17 AM
harfang found an article helpful! Analytical SQL : Where do you rank? 11/15/09 02:06 PM
Recent Activity:
1 - 8 of 8
  • 1
 

Browse All Articles