All-Access
A licensing scheme from Embarcadero catches Steve Jones' eye. He comments on a great way for the company to work with customers.
2009-04-27
92 reads
Embarcadero
All-Access
A licensing scheme from Embarcadero catches Steve Jones' eye. He comments on a great way for the company to work with customers.
2009-04-26
644 reads
All-Access
A licensing scheme from Embarcadero catches Steve Jones' eye. He comments on a great way for the company to work with customers.
2009-04-26
877 reads
All-Access
A licensing scheme from Embarcadero catches Steve Jones' eye. He comments on a great way for the company to work with customers.
2009-04-26
604 reads
RE: Handling "optional fields"
quote: When one customer is modifying their extended table, would we see locking issues on the primary table for customers other than the one modifying the extended table? No, SQL Server implements row-level lock. Looking at your keys, I don't believe this would be an issue. quote: Also, this would mean that all my select […]
2003-06-17
RE: DTS and INSERT Triggers
Thanks Everett! I will give it a try later in the week when they get data back into the Oracle database and let you know if that did the trick. Jason
2003-06-16
RE: Handling "optional fields"
Personally, I think 2 is actually your best option. The cons that you outlined I don't see as drawbacks, actually. You can easily add powerful join indexing simply by adding a mandatory index on each extended table on its foreign key: --Main Table Sample: CREATE TABLE MainTable ( accountID INT NOT NULL , recordID INT […]
2003-06-16
RE: HELP!!
Hi, You could use the REPLACE function to replace the carriage returns with a blank space... SELECT REPLACE(REPLACE(FieldName,Char(13),''),Char(10),'') from TableName The Char(10) and Char(13) should take care of the new line and carriage return values in the field... If the field in question is of "text" type then you will have to use the UPDATETEXT […]
2003-06-16
Blogs
Simple Talks Episode 7
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
A New Word: the McFly effect
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
Key mappings in Visual Studio Code
At a recent conference I was asked how I executed code during my presentation....
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