Viewing 15 posts - 136 through 150 (of 240 total)
In other forums, the debate still isn't dead. Here's my response to the article at: http://searchdatabase.techtarget.com/originalContent/0%2C289142%2Csid13_gci953120%2C00.html
I've worked extensively with both Oracle and SQL Server and there are things to...
March 4, 2004 at 12:39 pm
quote:
Found from BOL."If an index hint referring to multiple indexes is used on the fact table in a star join, SQL Server...
December 22, 2003 at 12:57 pm
quote:
I am assuming you have a non-clustered covering index. Does it makes a difference if you change it to CLUSTERED.
December 22, 2003 at 12:16 pm
quote:
2. For business intelligence, I think SQL Server is the best product so far. Oracle cannot even export a table to a...
December 22, 2003 at 7:03 am
quote:
That's a possibility, yes.
Well, now that you mention: Julie, our other DBA here, proved...
December 18, 2003 at 2:50 pm
quote:
App is too slow starting the connections up on the fly. These take up resources.
Ahh....
December 18, 2003 at 2:20 pm
quote:
We have adopted a general rule with respect to our Lawson system: we ALWAYS look at Lawson first.
December 18, 2003 at 2:16 pm
Thanks for the response, jxflagg. I don't have control over my own destiny here in regard to the hardware, so I'll have to pass on your suggestions to our...
December 18, 2003 at 1:49 pm
quote:
i.e. the primay key is not updateable - updating a primary key is a logical delete and insert and should be implemented...
November 12, 2003 at 6:48 am
quote:
select distinct proc_idfrom <table1>
where proc_profile_id <> 13
in the case of performance issue ... its preferrable.
It's...
November 5, 2003 at 7:37 am
quote:
How about just (as Frank indirectly suggested):SELECT TOP 10 Question
FROM #Questions
ORDER BY NEWID()
Well.. sheesh!!!!! ...
November 5, 2003 at 6:23 am
quote:
I have a 'questions' table with 25 questions and I have to select 10 questions at random from this table to display...
November 4, 2003 at 3:48 pm
quote:
THANKS! Worked perfectly.
You're quite welcome!
November 3, 2003 at 1:34 pm
quote:
I have a table with the following fields:Procedure_ID int
Procedure_Profile_ID int
One Procedure_ID may have many Procedure_Profile_ID's.
What is the simplest way to SELECT those...
November 3, 2003 at 11:24 am
quote:
In the Service Manager pop-up, set the server window for your server name, set the service to SQL Server. Down at the...
October 30, 2003 at 6:36 am
Viewing 15 posts - 136 through 150 (of 240 total)