Recent content by markmar1

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...

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...

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...

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...

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...

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...

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...

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...

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...

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....

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...

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.

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

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

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...