Viewing 15 posts - 91 through 105 (of 224 total)
Here's a quick little script I use. I was trying to emulate the Oracle DESC <table> command.
SELECT case ORDINAL_POSITION
when 1 then left(TABLE_NAME, 25)
else ' '
end 'Table Name',...
January 28, 2004 at 8:43 am
Thanks..that is probably the best explanation I could get. Or could hoep for. I am seeing some odd results myself and have been hoping to figure it out.
Thanks..............
January 28, 2004 at 8:39 am
All of mine do not show up either. This is because of different domains, a DMZ, and a firewall (see DMZ).
January 27, 2004 at 10:56 am
Your first post said "leaving 100% % free." Is that accurate?
January 27, 2004 at 10:53 am
Steve..
I can do this in Oracle and have yet to find a way in SQL Server. Is there a way to activate a trigger on login, or create an alert...
January 27, 2004 at 10:51 am
Through osal try changing the sa password..you don't need to have thew old password to change it.
January 27, 2004 at 10:04 am
The selectivity on the Item+Store+Salesweek index appears to be much better than the Salesweek+Store+Item index.
A non-clustered index creates more i/o and lookups when accessing the datapage and looking for...
January 27, 2004 at 9:58 am
Bill...not sure if I am going to offer what you are looking for. This is a thread I will probably follow too. Here are a couple of ideas that come...
January 27, 2004 at 9:47 am
Do you have indexes on the Item and Store tables? How about using an index hint?
What index did you change to a clustered index when the new table was...
January 27, 2004 at 9:38 am
I have a lot of databases out in the field that come in corrupted and have more than once had a 'suspect' database. I don't have a solution for you. ...
January 21, 2004 at 3:12 pm
This was a great question!! Good useful stuff!!!
January 21, 2004 at 8:17 am
I have had the pleasure to work extensively on Oracle and SQL Server and thought this thread was great!! Yes, Oracle DBA's are more protective and I think the...
December 19, 2003 at 9:31 am
jcool has a good point regarding referential integrity, constraints, and such. This could be an issue, but not impossible. As long as Primary keys stay unique and can...
December 9, 2003 at 9:36 am
Another option...
Look at isql and osql.
December 9, 2003 at 8:57 am
I hope Yukon overcomes some of the weaknesses of SQL Server. Since I work on both Oracle and SQL Server, my initial response before reading the questions was an...
December 9, 2003 at 8:24 am
Viewing 15 posts - 91 through 105 (of 224 total)