Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. markmar1

    The future of Sybase

    Talking with other DBAs and tech folks who are migrating towards DB2 world, they usually tell me something like this: (granted, my explanation is at 10000ft level, but usually are off the cuff discussions) Oracle - They tend to buy into your company by providing a very discounted price, but...
  2. markmar1

    Impromptu w/Sybase Stored procs

    Hello all. I am trying to execute a procedure that utilizes temp tables to be used as a data source for my report. The procedure is a multi step process which utilizes a set of #tables throughout its execution. The impromptu report basically telling me that I can not perform a insert into...
  3. markmar1

    making physical device

    Just a quick point, which I do not think I have seen in above thread... If this is dev, I have no problem with just putting on FS. But if prod system, and you decide to use the FS route, you may want to use 'dsync=true' when creating your devices to assure the data is written to disk and not...
  4. markmar1

    Attn All GURUs: Finding user IDLE or LOGIN time

    Physical IO may be okay, but it just does not continuously grow while the end user is logged into the system. I can have a process that loops. Wihtin the loop, I can perform the update. The physical IO will proceed to increase as update is performed, but once the transaction has been...
  5. markmar1

    Clustered INdex - Strange Behavior

    It still persists on v12+ since when at data-only locking, and datarow locking, the actual leaf pages are not physically in clustered index order. WIth DOL and DRL, the clustered index acts similar to non-clustered since its not the actual data page such as with allpages locking.... So, if its...
  6. markmar1

    Help - how to create a log output, while running a SQL Script?

    If you want to see all the actual SQL executed, with the results afterwards, use the '-e' option from isql. It will echo all the sql commands, and then execute the sql. good luck...
  7. markmar1

    Output table to a csv file

    Easiest way I would do this is to put the contents of select statement into tempdb, then use the bcp utility to extract from the OS level. select address_ref, person_ref, organisation_ref, type into tempdb..address_info from address where address_ref between 20 and 30...
  8. markmar1

    views

    The problems with views that I find is if they are broadly defined, using mulitple table joins. Usually views are of most use when the pull a specific type of data from a joined tables. For instance, maybe everything for sales region X. I just ran into a major performance problem and the...
  9. markmar1

    Restored database shows odd sysusages entries

    Many times what I have seen in the field is a database is created starting to use small increments(100MB, 200MB), and then all of the sudden, the application starts to be used extensively and DBA starts to use 2GB increments. Well, you can start to run out of device fragments within a DB, and...
  10. markmar1

    Maximum size that an image field can hold?

    I never really heard of a limit for the image type. We are pushing in docs abotu size of 50K - a few hundred K, and dont seem to be having any issues....
  11. markmar1

    How to not KILL your TX log.

    Ive used this technique quite abit.... While at a large telecom (not to be mentioned, but used to start with M and end in I), we had a few tables that were in the range of 80-100million rows, and all of the sudden, a new column needed to be added, and required a default. Fun stuff but worked...
  12. markmar1

    Export to Excel As A DUMP

    If you just need a comma delimited file to upload into Excel, why not just use the bcp utility??? Done this many time using different delimiters with no problems. As long as the number of rows you are extracting does not exceed Excel limitations.
  13. markmar1

    output of isql

    I usually use the command: set nocount on It will remove the rows affected messages....
  14. markmar1

    Sybase SQL command reference manuals

    If you want to drop a few hundred for hard copies, call Sybase.... But on the website, I would got to: www.sybase.com/manuals
  15. markmar1

    Copying tables between two databases

    Well, you can bcp out of one table, to the other table if you have both created. Or on Sybase side, they have a C program(bcpxfer) you can compile that will allow you use select statement and use bcp libraries to copy data between servers, etc. It would eliminate the need to go to a flat...
  16. markmar1

    Copying Rows in Syslogin table

    I have to do something similar between a production and reporting server that is refreshed nightly. A quick and simple way that I am doind is bcping the logins out of production, and load into temp table on reporting. Then using SQL, I join using id and name, and determine what should stay and...
  17. markmar1

    Audit Database

    A side note si we are using ASE 12.0 baseline, and HP-UX 11i, and we dont have support
  18. markmar1

    Remove Column From A Table

    I think the manuals have it in there somewhere. But for some of the alters such as when changing lock structures, it will invalidate the log due to being a non-logged transaction.... Not sure off hand which are or are not logged, so thats why I thought I would toss out idea to double check...
  19. markmar1

    Audit Database

    Currently, an audit system is setup, using the round robin approach that will cycle through the audit tables automatically via config variable "current audit table" = 0. All is fine initially, but when server is recycled, no audit records are captured, but the display audit option...
  20. markmar1

    Remove Column From A Table

    Just have to be aware that some of the newer alter commands are non-logged which may invalidate dumps. Since behind the scenes its rebuilding table with select..into type of logic....

Part and Inventory Search

Back
Top