Hi Friends,
Can anybody help in introducing the YTD Concept:
My Table[ Monthly_Highlights_tb ] schema should contain like below:
[Month] [Base_Amount] [YTD]
APR-07 1000.00 1500.00
APR-07 500.00 1500.00
MAY-07 2000.00 3500.00
jUN-07 5000.00 8500.00
WHEN I run the below query:
UPDATE t
SET t.ytd = (SELECT SUM(q.base_amount) FROM Monthly_Highlights_tb q WHERE q.[month] = t.[month] AND q.[month] <= t.[month])
FROM Monthly_Highlights_tb t
Please let me know the details of the following. 1.What is Multi-Threading? 2. How it is useful to increase the Performance of a SQL query.( How it is useful in Optimizing the query. 3. How we'll use MultiThread concept in Partitions and Using Processors.( For Eg.. If I want to use MAX threads=14 and 16 processors in this situation how we use PArtition concept and how it will improve the bufffer size of the CPU)
Before going in to details i like to understand more about concept anddesign of this database. Most books go directly in to details.Please, can a current admistrator gife me information on this?Thanks in advance,Dick vd Spek email: Join Bytes!
What is the equivalent for Oracle's nested table concept in SQL Server ? Is there anything like TABLE( ) function to select from nested table as in Oracle ?
Eg in Oracle :
SELECT t.* FROM TABLE(nested_table_datatype) t;
( like the above query used in Oracle PL/SQL and 'nested_table_datatype' is a table datatype created in Oracle using 'create type ...' syntax )
i would like to know where can i find information on the concept of SQL like Base Table , View Table and Search Table as now i am using VS.Net 2005 and SQL Server 2005 to write a addressbook program and i am just a newbie to Sql and c#... i wish to write my sql commands in c# side before passing it into sql and may i know how to do it?
The below code is ASP 1.0 to dynamically search a database and I want to use the same concept for a ASP.Net 2.0 solution. Do I do this in the code behind or on the aspx page and if on the aspx page what controls do I use for the array split? Basically where do I start. It took me a long time to get this old code working, I am hoping it is simpler in 2.0. Thank you OLD ASP 1.0 code to dynamically build a Sql Select statement for searching a database using one or more search words entered by user. If Request.Querystring("kwdSearch") <> "" ThenDim kwdString, ArrKwdString, iCountiCount = 0 kwdString = Replace(Request.Querystring("kwdSearch"), "'", "''")ArrKwdString = Trim(kwdString)ArrKwdString = Split(kwdString, " ",-1,1) For iCount = 0 to UBound(ArrKwdString) If iCount < UBound(ArrKwdString) Then Criteria = Criteria & "tblLinkInfo.L_Keywords LIKE '%" & ArrKwdString(iCount) & "%' AND " Else Criteria = Criteria & "tblLinkInfo.L_Keywords LIKE '%" & ArrKwdString(iCount) & "%' " End ifNext RS.Open "SELECT * FROM tblLinkInfo Where (" & Criteria & ") AND L_Enabled = 1 ORDER BY " & SortBy & "L_Rank", CNN, 3 If RS.EOF Then If Rs.State Then RS.Close RS.Open "SELECT * FROM tblLinkInfo WHERE L_Description LIKE '%" & Replace(Request.Querystring("kwdSearch"),"''","'") & "%' AND L_Enabled = 1 ORDER BY " & SortBy & "L_Rank", CNN, 3 End If RESULTS --- Display results with Repeater1.DataBind(); etc Exit SubEnd If
I am involved in a product development and want to understand the current best practices from the conception to product rollout. I have few questions. Appreciate your help and suggestions
Our project in a nutshell: Our team has developed the apps. using GUI-Oracle Forms & DBMS-Oracle 8i/9i with weblogic, Corba, windows 2000 server environment. It’s meant for 1000s of users with million of data. We are trying to integrate additional services/capability - messaging (wireless, chat etc.). As per the initial plan we have a central database and users will be using a local footprint database. The deltas (the changes) will be synchronized with the central database at a frequency say daily or nightly... We are concerned that having the database at the users desktop could leave the door wide-open for others to take a look at our code/design...
Questions:
1. UML case tools-- What’s the best tool available in the market as we want to revisit the design phase and identify the things that have been missed out in the prototype-(which was developed by a third-party)? So far we have used ERWIN to extract the data model...
2. How can we eliminate the need to have a local footprint database at the users desktop.?. Since there is a lots of data, retrieving the data via internet could be very slow for users? (hope this is the case!) That’s what led our team to think of having a local database at the users desktop. Someone suggested to use the data files or caching the data.. Appreciate if anyone shed some light on this.. Is there a better way to do it?
3. Client connectivity: What are the softwares needed at the users PC. Since we use Oracle Forms to develop the application, do we need to install the oracle clients at the users PCs? how to establish the connectivity from the Users PC to our server and to the database. IF we have to use the oracle client, does that require licenses for every User? What do we need to consider from the network connectivity stand point.
4. Application Rollout: how to package our finished product - application exe that is installable across wide array of environment. (we thought of install shield). how do we test it for accuracy etc.,
5. Database optimization: In addition to DBA help, is there any product or proceedures to ensure dataModel optimization, SQL query performance etc.,
Appreciate you sharing your valuable thoughts on this with us..
I tried samples of FileTable in SQL Server 2012 to store files in database. I have following questions.
1. When I right click on FileTable, and say Explore File Table Directory, I was taken to a directory. But if I search the same directory in my server/machine, the directory is not available.
2. Can I use some external server/disk as a directory for FileTable?
3. How easy is to use FileTables using .Net web applications?
In SQL Server 2000, when i install a client connection only, it also install the enterprise manager, just by adding/register new SQL server. there you can access all the tables. but in SQL Server 2005 how can I achieve that? Coz when i only install the client tool for SQL Server 2005 it only enables to connect to database, not accessing it freely and sql server management studio not included.
