Description:
Implementations of the SQL Server.
|
|
|
select * from master..sysprotects
|
| |
Is different the information you get if you run: select * from master..sysprotects than the one you obtain from: select * from sysprotects ? I need to ask because I don't have data base to test them, thanks,
|
|
|
sa_role and sso_role
|
| |
Hi, looking at a table of sysloginroles, found several users with sa and sso roles; besides sa and other extra account , isn't it a security problem to find 8 or 7 users with this privileges assigned? (newbie on sybase)
|
|
|
ASE 12.5.4 EBF 16823 ESD#9.1 && kernel timeslice -1501 error
|
| |
Hello, we face in one of our installations errors like this: 00:00000:00018:2009/07/07 20:35:33.76 kernel timeslice -1501, current process infected 00:00000:00018:2009/07/07 20:35:33.83 kernel Spinlocks held by kpid 437059762 00:00000:00018:2009/07/07 20:35:33.83 kernel Spinlock default data cache at... more »
|
|
|
ANN: Database Workbench 3.4.1 Pro released!
|
| |
Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular database development tool: " Database Workbench 3.4.1 Pro" Version 3.4.1 includes bugfixes in addition to the new features in version 3.4.0 Changes Highlights in 3.4 and previous versions ------------------------------ ---------------------... more »
|
|
|
Recent updates at www.sypron.nl
|
| |
25 October 2009: Recent updates at [link] ------------------------------ ------------------ This month's quiz question is about the 'elapsed_time' resource limit which I recently discovered has received an important fix... [link] My books on ASE and Replication server remain a popular resource for DBAs... more »
|
|
|
Commercial BI vs Open Source BI
|
| |
The nature of the Business Intelligence industry is changing. Major acquisitions of the past few years have seen most of the traditional players rolled into the mega vendors, and now we are staring to see the emergence of alternative solutions. One of these is Open Source. In this Q&A we talk to Yellowfin CEO Glen Rabie about the business... more »
|
|
|
Sybase ASE 15 performance issue
|
| |
I am working with ASE 15 in my application and there is performance issue related with nested joins. I have stored procedure which selects 2 columns from 2 tables and compares equalities of over 10 columns between this 2 tables. But when I run this stor. proc., the result takes 40 minutes. I added "set merge-join off" statement to top of my... more »
|
|
|
Cathc error number from raiserror statement
|
| |
Hi, I have these two procs and I'm trying to catch the error number from the proc "call_error". But I always get 0 as the value. It may be bcoz of the "return 0" stmt at the end of proc "throw_error" (as it executed successfully). I cannot change the proc throw_error. So is there a way to capture the... more »
|
|
|
Offsite backup recommendations for large database +100gB
|
| |
We have a database that when dumped with the dbbackup command is a 67gb .db file and a 28gB .log file . It's becoming somewhat difficult to manage the offsite backups, which are now done weekly via scp. Tar does not provide any compression on the .db file. The server the db runs on is windows 2003 and all backup systems are nix based.... more »
|
|
|
newbie question warning
|
| |
Hi! I'm new at Sybase, I want to make a query selecting fields from different databases, how can I make it? Thanks for your time!
|
|
|
|
