Is Oracle 10g Really Oriented For Grid Computing?
May 8, 2007
Hello all, I known this is a SQL Server forum, but some people maybe have worked with oracle and can help me.
Microsoft's article "http://www.microsoft.com/sql/prodinfo/compare/oracle/mythandreality.mspx :"
reads as follows:
"Oracle's purported Grid enablement in 10g is based on its Oracle Real Application Clusters (RAC) technology that is no more than a local cluster. RAC is a local cluster of computers with no geographic distribution capabilities. This marketing campaign relabeled existing features to exploit current industry trends. "
My question is how can I support the above paragraph? I would like to known more reasons about why oracle grid is a local cluster instead of grid computring oriented.
Thanks in advance.
Hernán.
View 1 Replies
ADVERTISEMENT
Jul 20, 2005
Has anyone here heard or come across an article or write up about GridComputing in SQL Server 2000?Bharathihttp://www.vkinfotek.com
View 2 Replies
View Related
Oct 30, 2007
Hello!
I'm having some trouble with transforming a cursor based (not performing) user function into a dataset-oriented user function.
Actually, I don't even know where to start.
Here is my cursor based function. If anyone has patience to read it and try to understand what I'm trying to achieve, I'd greatly appreciate it.
Data Example:
T_TABLE1
col1 DT_RIF col4
1 12/12/1999 100
1 15/12/1999 110
1 01/04/2004 200
1 01/12/2004 210
1 01/11/2006 220
2 01/01/2005 300
2 01/01/2007 310
Let's say I pass 12/10/2007 to my function. My @NewTable needs to look sth like this
NT_Col1 NT_Col2 NT_Col3
1 1999 110
1 2000 110
1 2001 110
1 2002 110
1 2003 110
1 2004 210
1 2005 210
1 2006 220
1 2005 300
1 2006 300
1 2007 310
ALTER FUNCTION [dbo].[fx_SomeFunction]
(@ParamDateTime datetime
)
RETURNS @NewTable TABLE
(
NT_Col1 NVARCHAR(8),
NT_Col2 int,
NT_Col3 numeric (18, 5)
)
AS
begin
DECLARE @var1 nvarchar(5)
DECLARE @var2 nvarchar(8)
DECLARE @var3 nvarchar(8)
DECLARE @year int
DECLARE @dt_rif_max datetime
DECLARE Curs1 cursor for
select T2.Col1, T2.Col2, T2.Col3, Min(Year(T1.DT_RIF) ) as MinYear
from T_TABLE1 T1, T_TABLE2 T2
where T1.Col1 = T2.Col1
GROUP by T2.Col1, T2.Col2, T2.Col3
open Curs1
Fetch next from Curs1 into @var1, @var2, @var3, @year
WHILE (@@FETCH_STATUS = 0)
begin
while year(@ParamDateTime) >= @year
begin
select @dt_rif_max = max(dt_rif)
from T_TABLE1
where year(dt_rif) = @year
and T_TABLE1.Col1 = @var1
IF @dt_rif_max is not null
select @dt_rif = dt_rif, @var4 = col4
from t_TABLE1
where col1 = @var1
and dt_rif = @dt_rif_max
INSERT @NewTable select @var2, @year, @var4
set @year = @year + 1
end
FETCH NEXT FROM Curs1 into @var1, @var2, @var3, @year;
end
CLOSE Curs1;
DEALLOCATE Curs1;
return
END
View 6 Replies
View Related
Sep 5, 2007
Hi,
I'm having a DB designed for me, and I'm inspecting it and wondering what in general is the better way to do this.
We have a product, which we are counting "product views". The DB designer has created columns called "view_today" and "views_alltime".
I specified I wanted a normalized database, I'm thinking this is technically not normalized ? Am I correct ?
Wouldn't it be better to have a query that counted the views off the logging table ? I can't see any advantage to doing it the way its been designed except to save time.
Thanks for any input !
Mike123
View 3 Replies
View Related
Mar 11, 2008
hi please help me,i have a table queried using this sql, select name,(select count(*) from myTable a where a.name = r.name ) as Total, (select count(*) from myTable b where b.name = r.name and dnum > '1') as Used, (select count(*) from myTable c where c.name = r.name and dnum < '1') as remainingfrom myTable r group by namebut i need one more thing in this table that should look like this,nameTotalUsedRemainingPercentageA126650%B2021810%C150150% this is to add the BOLD field from the above table, but my problem is that the computation is "Used / Total = Percentage%"so how can i do this, please help methanks
View 4 Replies
View Related
Jan 5, 2006
hi everybody,
i'm trying to calculate the 'SUM' of time spent in hrs. n min. How can i do this using SQL Server?
What i mean is, i've a column 'TIME_SPENT' that has 'datetime' datatype. This column saves time spent for an activity in format 'hh:mm'. Suppose a user spends 45min for activity 'A' and say 1hr 25 min for activity 'B' then i want to calculate the 'SUM' of 'TIME_SPENT' for the user which should appear as 'Total time spent =2:10'
Can somebody pls help me with this?
Thnx in advance.
View 5 Replies
View Related
Mar 16, 2004
I am attempting to compute Service Levels for an interaction based upon business hours. For example, an email arrives at 4pm and is handled the following day at 10am. Call Center Hours are 8-5.
Essentially I have a number of different alternatives, and have found some potential solutions, including:
www.dbforums.com/arch/7/2003/9/914261
However, my situation has a couple of additional twists to the standard 8hrs of business M-F. The call center is open different hours depending upon the day of the week. For example, 8-5 M, 10-7 T, 8-5 W Th F, 10-2 Sat, 10-12 Sun
Additionally, I would like to remove Holiday's from the calculation for service level as well.
I have explored a number of different table DTD's, but none seem to be a perfect fit for determining the number of "open" hours between when an interaction arrived, and when it was handled.
The DTD I have for the Holiday table is as follows:
CREATE Table Holidays (HolidayDate DateTime)
GO
Insert Into Holidays (HolidayDate) Values ('12-25-2004')
Please let me know what you feel would be the DTD for storing the business hours and also the query for extracting the number of Open hours between two dates
Thank you in advance
View 13 Replies
View Related
Jul 6, 2013
I encountered a tricky problem. The original data, say, table_o, is shown below:
IdsStatusDate
ID1402-May-13
ID1310-May-13
ID1216-May-13
ID1120-May-13
ID2308-May-13
ID2210-May-13
ID2119-May-13
The final resulting table, e.g., table_f, is:
Ids4->3 3->2 2->1
ID18 6 4
ID2NULL 2 9
The values in the final table are the days used by each ID transferring from status i to status i-1. E.g., ID uses 8 days (10-May-13 - 2-May-13) to go to status 3 from status 4.
It is hard for me to come up with a table like the final table, although I know that the difference between two adjacent rows can be computed by using self-join and timediff().
View 3 Replies
View Related
Sep 6, 2007
Dear All.
I'm a fairly new SQL programmer so apologies if this is a silly question.
I'm trying to create a new column/variable from 3 other variables where the new column = column 1 unless column 1 is blank, then = column 2, unless column 2 is blank, then = column 3.
But I don't know where in my query to begin building this. Should I build it in a subquery? Thanks in advance for any replies.
View 2 Replies
View Related
May 17, 2008
Hi,
I want to create a view where I can calculate the sum of a couple of bit value columns,
aswell as keeping track of the total number of bits set to true.
Here is an example:
dbo.Band
BandID int
Name nvarchar(50)
Country nvarchar(50)
dbo.Record
ID int
Name nvarchar(50)
BandID int
Label nvarchar(50)
InProduction bit
InSkodne bit
From these tables I created this view:
dbo.TestView
SELECT dbo.Band.Name, dbo.Band.Country, dbo.Record.Name AS Recordname, dbo.Record.Label, CONVERT(int, dbo.Record.InProduction) AS InProduction,
CONVERT(int, dbo.Record.InSkodne) AS InSkodne, CONVERT(int, dbo.Record.InProduction) + CONVERT(int, dbo.Record.InSkodne) AS Total
FROM dbo.Band INNER JOIN
dbo.Record ON dbo.Band.BandID = dbo.Record.BandID
I use the convert function to be able to use SUM() across my bit columns, which works fine. Problems is I´m not sure that the way I´m creating the TOTAL column is the best way to go. Any other ideas?
I´m having some problems using this view and the TOTAL column in particular when referencing this view from applications outside SQL Server...
View 9 Replies
View Related
May 11, 2008
Hello all!
I´m currently devoloping an application where users can register errors related to recieved purchase orders.
I store these values in i table where the purchase order id i PK, and the possible errors that
can exist are stored as bit.
Now I want to be able to put a price on these errors.
I´m thinking about adding another table, containing all possible errors as columns, and then storing the cost of each error as an integer, and probably also a datetime for keeping track of when the costs was last updated.
I´m pretty sure this problem has been solved alot of times before, so I don´t wanna do something stupid here :-)
I´m also wondering about how it would be best to show the computed values?
Should I use a view for this?
For example:
SELECT (dbo.Orders.QuantityError * dbo.Costs.QuantityError )
FROM dbo.Costs CROSS JOIN
dbo.Record
assuming now that the Costs table only contains one row.
Is this the right way to go, or can you guys give me hints to a better solution?
Regards
Daniel
View 4 Replies
View Related
Dec 19, 2001
Is there a quick easy way to calculate rowsize for a record in a table that has data in each column?
View 5 Replies
View Related
Sep 13, 2006
hi !
Just started playing around with SQL 2000 and I createda sample table called 'actor' which has 4 columns
1. actorID
(formula= LEFT(NEWID(), 3)+ LEFT([actorFirst], 2) +
LEFT([actorLast], 2) + RIGHT(NEWID(), 3))
2. actorFirst
varchar(20) NOT NULL
3. actorLast
varchar(20) NOT NULL
4. actorName
(formula = [actorFirst] + ' ' + [actorLast]
Now my problem is that I want to set a primary key constraint on actorID but it doesn't let me because it the NULL check mark is automatically checked and I cannot check it off ... and I can't set a primary key on something which is allowed to be NULL....
I don't understand why 'actorName' column which is also calculated doesn't have that default NULL checked and locked ....
What am I doing wrong ? Please help ....
View 5 Replies
View Related
Oct 19, 2015
I have the following a computing column
(isnull(TotalProductSaleCost,0) * 7) / 100
I would like the output to be formatted to decimal (12, 2) not sure how to achieve this?
View 4 Replies
View Related
May 18, 2007
I am new to SSRS, so perhaps its a trivial question. I was wondering that since all controls have names in the report, is it possible to programatically access values of different textboxes, do some computation and then assign to another text box? I know how to do it using the Aggregate functions and operators, but am not sure if I can access values from textboxes within two different tables and assign the computed value to a third text box on the page (not belonging to any table or other control).
somethig like.... txtTotal.Value = FormatCurrency(txtSalesTotal.Value) - txtDiscount.Value));
Any ideas??
DNG.
View 6 Replies
View Related
Apr 22, 2008
Hello,I am in the process of making a very simple stats page that will show us how many tasks we've completed. Here is what I have so far: Here is the SQL that makes it work: SelectCommand="SELECT Count(TicketID), Category FROM Tickets GROUP BY Category ORDER BY Count(TicketID) DESC ">My problem is with how the totals seem to go on forever. Instead of being in proportion to each other as a percentage of a the total amount of tickets.. they just increase in size with each additonal entry. Can someone help me restructure this so that I can calculate the totals individually and as a whole and then apply the totals to create a proportional bar graph?Thank you greatly for your help,Mark
View 2 Replies
View Related
Oct 23, 2006
what datafield shoud i put in my database if its a checkbox option? coz in my datagrid i added a checkedbox so that i can easily manipulate it.but when i run it. it produces error. and doesnt recognize the checkbox column.it said that there none in the datasource.but i dont know what should i put in the database! pls help!thanks
View 1 Replies
View Related
Feb 9, 2007
hi, i have done some testing and its only when i put a grid view or any other type of data viewer on the page, and then connect it to the sql datasource that i get an error
Line 1: Incorrect syntax near ')'.
now i really cant figure out what it is, here is the code i am using
SQL data source code :
asp:SqlDataSource ID="SQLDS_view_one_wish" runat="server" ConnectionString="<%$ ConnectionStrings:wishbank_DBCS %>"
SelectCommand="SELECT [msg], [Date_Time] FROM [tbl_MSG] WHERE (([Activated] = @Activated) AND ([msgID = @msgID]) )ORDER BY [Date_Time] DESC">
<SelectParameters>
<asp:Parameter DefaultValue="Y" Name="Activated" Type="String" />
<asp:SessionParameter Name="msgID" SessionField="sWV" Type="String" />
</SelectParameters>
</asp:SqlDataSource>
session variable code which sends it to this page
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
GridViewRow row = GridView1.SelectedRow;
Session["sWV"] = row.Cells[1].Text;
Response.Redirect("www/viewwf.aspx");
}
if you have an idea please let me know as im stuck!
View 1 Replies
View Related
Jun 17, 2007
hi,
now theres something i want to achieve but, again dont know how :-(
In a grid of my site it needs to be able to select an item, ( not with checkboxes) but maybe when you click on the item in the FromName column then
the data in the column in my database messageTEXT needs to be able to show in a textbox.( textbox is outside of grid)
now i was thinking that maybe it is need to be done with datareaders or something?
Greetz
Roy
View 5 Replies
View Related
Nov 24, 2006
Is it possible to have a design grid in SQL server like the one you have in Access when you create a query ?
View 10 Replies
View Related
Aug 15, 2007
Can you turn on a grid in the designer to assist you with aligning tasks, etc. I've trie all kinds of things, but can't get a grid. Or even maybe rules? I'm probably missing something real simple, but can't find.
View 7 Replies
View Related
Nov 2, 2007
I have a client program that writes to sql server database 10 records per second . i want to compute the CPU usage and the memory usage for the whole program or CPU usage,memory usage for the insert statement in the program .
Can anybody help me with this?
View 6 Replies
View Related
Jan 28, 2007
Inside my gridview, the user can key in new record, delete record and update record. but dont know why my insert function cant work out and i dunno why this is happen? Can somebody help me out with this?Thanks
My Code:<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"InsertCommand="INSERT INTO [rest_info] ([resname], [menu], [price], [date]) VALUES (@resname, @menu, @date, @price)"<InsertParameters> <asp:Parameter Name="resname" Type="Char" /> <asp:Parameter Name="menu" Type="char" /> <asp:Parameter Name="price" Type="Decimal" /> <asp:Parameter Name="date" Type="datetime" /> </InsertParameters></asp:SqlDataSource>
View 3 Replies
View Related
Apr 4, 2007
I've created a Data Set with a connection string to my sql database however when i go to create queries and select 'generate update, delete and insert statements' it doesn't do it. I'm wondering why and how do i get this fixed since i don't know how to code it myself.
Thank you.
View 2 Replies
View Related
Jun 21, 2007
i seem to have problems with my grid view not displaying anything when if i test my SQLDataSource, it shows me rows of data.i seem to have this problem only with my Stored procedure, or when i change my Database structure, like add fieldsHere is my procedure: can i do this? select a row and also return a varchar?ALTER PROCEDURE dbo.SelectUpload
(
@FileName varchar(50),
@Return varchar(MAX) = NULL OUTPUT
)
AS
SELECT * FROM Uploads
WHERE FileName = @FileName
RETURN
SELECT WebPath FROM Uploads
WHERE FileName = @FileName
View 3 Replies
View Related
Aug 12, 2004
I need to display data from a sql server 2000 db on an asp web page and I need a vertical split. Does anyone have any solutions? I really can't afford to spend much/any money so freeware/shareware or coding suggestions is what I am interested in.
Thanks!
View 2 Replies
View Related
Mar 4, 2015
I have below SP that populates immunization into a grid. I need to add last_name, first_name from person table.
Each record in dB is tied to a patient by their person_id and Person table has this as well.
All I need to tie this grid and add last_name, first_name into this grid. I added 2 lines but its not working for me?
quote:
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[ngkbm_unmapped_vaccines]
[Code] ....
View 12 Replies
View Related
Aug 23, 2005
Hi
I would like to create and run a stored procedure from VB. I will pass a variable to the stored procedure and after that according to the parameter, records are selected and shown in the DB grid on the form.. I'm using VB 5 and mssql 2000. I have to show selective data in the DB Grid.
Any suggestions and help are welcomed. Thanks in advance.
View 3 Replies
View Related
Nov 15, 2006
In SQL Query Analyzer, there is a Query drop down window that gives youthe option to change the output from grid to text for printing ifneeded. My question is, can this be programmed so a stored procedurewill always print in text without having to manually change the windoweach time the procedure is run? I could find nothing under the logicalsearches in books online.Thanks JAB
View 1 Replies
View Related
Mar 25, 2006
From database explorer isn't possible obtain the result of a store procedure in a grid panel ?
View 1 Replies
View Related
Nov 23, 2007
Good day all
I have a grid veiw of my data base on a windows form . As the data grows , the more I have to scroll down to add new data in a row . Does anyone know if there is an option or propertie I can set so as the latest data row is on top?
Thanks
Rob
View 3 Replies
View Related
Jul 9, 2006
Hi,
I want to be able to select data from a database without using grid
view etc. I can set up a connection and bind it to a grid view but I
would like to do some data processing without showing it. Something like
select id from table where name = "x"
store id in idvar
store the row count to a variable rowcount
if rowcount > 0
select name from table2 where id = idvar
endif
etc
I can see how to set the sqldatasource select command but not how to run it and get results out of it. Please help
View 1 Replies
View Related
Sep 25, 2006
Hi all,I asked a similar question a few weeks ago but I didn't explain myself to well so I was hoping for some more input.I have created a webpage in Visual web developer that contains a gridview that points to an SQL table.All works well as far as searching the table and sorting. The SQL table itself is Droped ( deleted ) and then re-created every 1 minute from a query to a linked DB2 database so that we have a "live" table of our DB2 system but in SQL.....However,There is now a requirement to be able to ADD data to this SQL table. eg: a comments field.. from the website.My procedure for re-creating the SQL DB is now useless as any data added through the website would be lost when the table gets re-created.What is the best way for me to achieve a permanent table in SQL that gets updated from the Linked server DB2 but that I can also add comments from the front end (Website Gridview)..I'm assuming some sort of update query and a join to a seperate, permanent table that contains the comments?.Please help. Ray..
View 1 Replies
View Related
