hi i am running Oracle and SQL SERVER 2oo5 on the same server. Plstform win 2003 Enterprise. i have created a System file DSN. Make the entry in listener.ora and tnsnames.ora. but when i m tring to ping my dsn system dont responds. and when i m trying to create a database link using my dsn, it gives error. What to do ? thanks for hel...
I need to create a trigger in every database on my sql 2005 instance. I'm setting up some auditing ddl triggers. I create a cursor with all database names and try to execute a USE statement. This doesn't seem to change the database - the CREATE TRIGGER statement just fires in adventureworks repeatedly. The other option would be to pr...
What are your set of best practices when working with PostgreSQL? I'm interested in every aspect of postgres-management/development. Configurations, rules, functions, users, ... There are a lot of documentation about PostgreSQL, but I haven't found any clear best-practice/cookbook source yet. Just to clarify: I know about views, transa...
I recall hearing that the connection process in mysql was designed to be very fast compared to other RDBMSes, and that therefore using a library that provides connection pooling (SQLAlchemy) won't actually help you that much if you enable the connection pool. Does anyone have any experience with this? I'm leery of enabling it because o...
I'm running into Db performance issues with an OTLP project I'm working on. Another developer and I have reached the end of our accumulated performance knowledge and seek out an individual to join the team to help us speed up our application. For some background we've done schema changes to denormalize pieces of the data, optimized eve...
How to decide whether to choose a Replication or Mirroring in SQL Server 2005 to provide data availabilty and performance at the same time. ...
Question for you DBA's and such. How do you go about learning the skills to become a DBA without having the 'on hands' or OJT? My experience in DB work has been messing with MySQL via MyPHPAdmin or something similar. Not doing a ton of in-depth work. Classes? SQL books? ~V ...
How can I predict the future size / growth of an Oracle table? Assuming: linear growth of the number of rows known columns of basic datatypes (char, number, and date) ignore the variability of varchar2 basic understanding of the space required to store them (e.g. number) basic understanding of blocks, extents, segments, and block ov...
I want to write a SQL 2005 script to create a new login that uses Windows authentication. The Windows user is a local account (not a domain one). A local account with the same name exists on many SQL Server machines and I want to run the same script on all of them. It seemed simple enough: CREATE LOGIN [MyUser] FROM WINDOWS However, ...
I have a table in my database in which records conceptually can be children of other rcords. The table has a non-null name field. I need to ensure that each name in a set of children is unique, but not across the entire database. I'd like to enforce this using a constraint inside the Database. What's the best way to accomplish this? I kn...
We maintain a set of change scripts that must be run on the DB when our web application is released. We waste a lot of time and experience some difficultly keeping these updated however, our DBA likes to (rightly) tweak stored procedures and schemas on the live system to maintain system performance. Every so often we have to rebase our...
We have oracle 10g running on windows server 2003. A machine which runs an application using that database has as of a few weeks ago suddenly started having connectivity problems. Today we ran the automatic updates for windows server and the problem has only gotten worse. I realize this isn't enough information for anyone to diagnose ...
Bit of a newbie to oracle 10g. I have been load testing an application and when I logged into the enterprise console I noticed that my UNDOTBS table space is full. I know that the UNDOTBS table space is used to keep a copy of data that exists before a transaction starts. I thought that this data would be transient and expire once a tran...
We are developing an application to do a "hearbeat" test of all our SQL servers (2000, 2005 and 2008), and we're trying to figure out the minimum permissions necessary on the SQL server to do that. (Platform involved is TBD, but should use a standard connection string). We are considering using a "SELECT @@VERSION" query, which should b...
This seems to be a common pattern in nearly any large organization with lots of IT infrastructure: DBAs and developers are more or less at each other's throats. The DBAs see the developers as incompetent whippersnappers with no understanding of data integrity and DB performance, who must be prevented from compromising the "database fort...
What are the benefits of using the "xml" datatype versus storing the xml content inside a "text" datatype? Am I able to query by some specific xml attribute or element? What about indexing and query performance? Besides the postgresql manual what other online sources can you point me to? ...
I've recently enabled CLR on my 64 bit SQL Server 2005 machine for usage of about 3 procs. When I run the following query to gather some info on memory usage... select single_pages_kb+ multi_pages_kb + virtual_memory_committed_kb as TotalMemoryUsage, virtual_memory_reserved_kb from sys.dm_os_memory_clerks where type = 'MEMORYCLERK_...
I'm part of a software development company where we do custom developed applications for our clients. Our software uses MS SQL Server and we have encountered some customers which do not have a DBA on staff to manage the databases or if they do, they lack the necessary knowledge to perform their job adequately. We are in the process o...
I am using SQL Server 2000. I have a corrupted backup file. How can I restore the database from that corrupted backup file? Any help or suggestions really appreciated. ...
Can anyone tell me when an index is a bad index? ...