New answers tagged

1

sp_helpdevice does list all allocated fragments on a device when you specify the device name. This includes the size of each fragment, but indeed not the free/used metrics. Those would not be difficult to write yourself however.


5

What you see in your execution plan is Sybase performing a DISTINCT operator. When you do a SELECT DISTINCT in Sybase it first builds a Worktable (as you can see in step 1 of your execution plan) and then it selects sorted data removing duplicates from that worktable (which is what you see in step 2). This is documented The sort algorithm doesn't appear to ...


0

You cannot write your own partition function. What you need to do is create an additional column, assign a value resulting from the function you want to use, and partition on that column. Unfortunately, you cannot partition on a computed column, which would be the easiest solution.


5

Without getting too involved in specific details on the language required to do this in Sybase SQL Anywhere 8, which is now more than 15 years old, I'd recommend something like the following: create a table on the laptop database that contains a column which uniquely identifies rows that have already been exported to the main database. the export function ...


2

Should be: insert into table1 select * from table2 except select * from table1; You could also use: select * from table2 where Name not in (select Name from table1) This works too (assuming Name cannot be NULL). The difference is that the except version delivers all rows that are not the same whereas the not in query delivers all rows where the name ...



Top 50 recent answers are included