Viewing 15 posts - 31 through 45 (of 64 total)
I create alerts for error severities 17 thru 25; we also use Quest's Big Brother for host monitoring.
July 7, 2010 at 4:28 am
damodar.kamat (6/29/2010)
insert into test@SQLTEST (name, fullname)values ('Oracle', 'Oracle server data');
- test@sqltest is a table "test" on sql server.
Does
select name, fullname from test@SQLTEST
work? (Even if it returns 0 rows.)...
June 30, 2010 at 9:31 am
I seem to remember some kind of marketing questionnaire from Microsoft a few months ago about client tools support for non-Windows platforms. So, there could be something in the pipeline...
June 18, 2010 at 6:43 am
Hi,
'The Mythical Man-Month' and 'Peopleware' are both classics about software development and developers. I also liked 'Managing Software Maniacs', though this price is WTF. (I was a developer then...
June 9, 2010 at 10:09 am
John Rowan (5/18/2010)
We had some folks that were pushing pretty hard for this type of design at a company that I used to work for . . .
That view...
May 19, 2010 at 5:07 am
PaulB-TheOneAndOnly (4/30/2010)
The Oracle term "materialized view" represents nothing but a table that is updated or refresh in an automatized way.There is a plain Oracle "table" for each "materialized view"
Yes, it...
May 5, 2010 at 8:53 am
LOL This is just like one of the certification questions. Nice one, Lynn.
April 30, 2010 at 9:31 am
I change the Display Name in the profile to the instance name. It's not ideal, but it helps.
March 11, 2010 at 8:49 am
Hi,
IMHO it is worthwhile having a calendar table (often called a time dimension in data warehousing lingo), particularly to support reporting with external tools. (Tools beyond T-SQL, I mean.)
This...
February 11, 2010 at 3:51 am
Hi Joy,
I had this happen recently on a SQL Server 2000 instance. The error log had this line shortly after the database engine was started:
2010-01-27 09:24:36.35 server ...
February 10, 2010 at 10:37 am
Hi JHD,
Oracle RAC (Real Application Clusters) corresponds to SQL Server Clustering. The main difference is that RAC allows for multiple active nodes (active/active), especially in more recent releases of Oracle...
February 8, 2010 at 10:45 am
Hi,
70-432 is the 'first level' (MCTS), and 70-450 is the 'second level' (MCITP), so 70-432 is the one to do first. If you search the forum, there are similar posts...
February 2, 2010 at 4:34 am
Hi Alan,
If you cannot change the query, then you would have to reduce the number of objects accessible to the Oracle user account you are using to connect.
It sounds...
January 28, 2010 at 7:48 am
Hi Alan,
This query is bringing back a list of all tables, views, and synonyms to which the Oracle user account has access. (In your case, that's over 200,000.) This suggests...
January 26, 2010 at 9:20 am
Viewing 15 posts - 31 through 45 (of 64 total)