Search results for query: *

Hi Well we've, from time to time, wondered how strong Sybase is in the market and if they have the ability to fight back. Aside from thinking that the Sybase marketing and sales guys needed to get their act together I have been a BIG fan of Sybase for many years. They have had 'decent', albeit...

Hi I have a table that has a clustered index on the ID field. If I do a select *[COLOR=black], the optimizer returns all the rows, BUT, with the following 'weird' behaviour: 1- The returned list is NOT sorted. Actually 80% is sorted, the rest is not. 2- The Optimizer does a table scan EVEN if...

Hi I haven't seen a post on this here so I thought I'd correct that error. There is a website (http://www.sypron.nl/) that is run by, probably one of the most knowledgeable Sybase DBA's I've ever come across, his name is Rob Verschoor. He's written a book called "The Complete Sybase ASE...

Hi Is there any way to truncate a table OR drop it if their are constraints defined in it, or, foreign key constraints 'pointing' to it? -=-=-=-=-=-=-=-=- For ease of reading, any posted CODE should be wrapped by and tags. Ex: [COLOR=purple]SELECT 1 from sysobjects[COLOR=black]

Hi I was wondering about the internal mechanics of the CONVERT function and the LIKE condition. Here's an example: Let's say I have data in SomeTable called 'desc'of the following format. ------------------------------ | ID | Desc | ------------------------------ | 1 |...

Hi This is more of a theoretical discussion on how to handle a problem. Here's the issue: We have many tables that are being populated from multiple sources, at one point the "PK" of "TableXYZ" needed to contain alphanumeric characters. So they (original developers) created...

Hi I work in an environment where we don't always have access to the cofigurations of our DB. That being said if we find ourselves in a situation where we are runing queries on 10's of millions of records (this happens daily), we might need to add space to the log or change the size of tempdb...