Mining for Quitters
Google is trying to figure out who might quit the company, using their own custom application. Steve Jones thinks this is a great idea and wishes more companies would do it.
2009-06-09
1,066 reads
RE: Teradata Datbase Administrator--DesMoines, Iowa
This position is still available. Candidates with strong database administration or data warehousing experience in other RDBMS are now being considered. Must have a strong desire to learn Teradata.
2005-01-18
RE: Getting the most recent row for a group of products
PS this is the current query which returns the correct rows but is way too slow...takes almost 12 seconds to execute.SELECT Trans1.ITEM_NUMBER, Trans1.SELLING_UNIT_PRICE FROM SOR_ORDER_HISTORY Ord1 INNER JOIN SOR_HISTORY_TRANS Trans1 ON Ord1.THIS_RECORD = Trans1.PARENT_RECORD WHERE (Trans1.PARENT_RECORD = (SELECT TOP 1 Trans2.Parent_Record FROM Sor_Order_History Ord2 INNER JOIN Sor_History_Trans Trans2 ON Ord2.This_record = […]
2004-02-21
RE: truncate log after differential bkup
Not much other than failure error as shown below. I won't be back in my office til Monday so I'm not being rude by not replying... I really do appreciated your help on this. 2003-11-20 12:30:08.15 backup Database differential changes backed up: Database: TCPrd, creation date(time): 2003/06/24(07:38:28), pages dumped: 14395, first LSN: 16318:876:5, last LSN: […]
2003-11-20
1 reads
RE: truncate log after differential bkup
What is in the error log after you get the 3201 error? --Jonathan
2003-11-20
1 reads
2003-07-27
RE: eliminating duplicates from stored procedure joins
Thats it guys, Is there no way out that i can get unique values through query.Is there any way if i can get rid of that duplicates through ASP where I am calling this procedure?
2003-06-24
2003-06-24
RE: eliminating duplicates from stored procedure joins
You may be pleased (kind of!) to know that the reason you have had so much trouble is that what you are trying to do is logically impossible. You don't have a fan trap - but you do have a standard chain of three tables. You need to be aware of which table is at […]
2003-06-24
RE: eliminating duplicates from stored procedure joins
Data is duplicated in tblFileNames (Case_no#,reportid,type) Data is duplicated in userviewed (viewid,reportid) Data is not duplicated in Case30 and caseold
2003-06-23
Blogs
Real-World SQL Mastery: Your Hands-On, Mess-Free Sandbox
Are you ready to take your SQL skills from theoretical to tactical? If you've...
Set a Runtime Variable in an Azure DevOps Pipeline
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
A New Word: Symptomania
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers