Design A Database For Daily News Network Website
Aug 4, 2007
Hello..
I want to upgrade my website to asp.net 2.0 and I want to add a Daily news to website.
and 10 to 15 news will be added daily , so after a year we have almost 4000 entry in the database.
For designing this DB what is your advice on how to store news in database?
Is it better to create same tables for each year ? for example
tblNews_2005
tblNews_2006
Or just to make one table and have all news stored in that ? its gonna be huge after years , isnt that make any problems?
Thanks
Regards.
View 4 Replies
ADVERTISEMENT
Sep 19, 2007
simple question:
I have create a web site in visual studio with form user authentication. Thats create a mdf database in this path:
c:inetpubwwwrootwebsiteapp_dataaspnetdb.mdf
thats use Sql server
i would like to access this database with c# form application on a network with multi-user.
if i change the drive letter of the path above to f: (mapped drive) or \serverc, i got this message
System.Data.SqlClient.SqlException: The file "h:InetpubwwwrootwebsiteApp_DataASPNETDB.MDF" is on a network path that is not supported for database files.
An attempt to attach an auto-named database for file h:InetpubwwwrootwebsiteApp_DataASPNETDB.MDF failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
i read that sql server did not support database sharing with mapped drive or unc share.
So how can i share website database with c# application???
Note: of course if i develop the website and the application on the same machine its work. I want this application run on several work station accessing all the same mdf database with his web user member.
View 7 Replies
View Related
Jul 31, 2004
Hi,
I want a few tips on how to go about designing a schema for multi parent hierarchical tree structure.
Will this work in large scale, like Social Networking
how do we generally go about designing for Social Networks?
What could be the optimal architecture?
aravind
View 2 Replies
View Related
Nov 30, 2007
hi how i can make news bar related with DB ?
View 1 Replies
View Related
Mar 15, 2007
hi everyone, trying to make updates to a news area on a website through an update form.
have a table (news) with one row (news).
the record set displays correctly in my update form in a browser. after changing content and clicking update however, error displayed:
You have an error in your SQL syntax near 'WHERE news ='contents for news area'' at line 1
corresponding code:
if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "newsForm")) {
$updateSQL = sprintf("UPDATE news WHERE news =%s",
GetSQLValueString($_POST['news'], "text"));
have tried multiple variations of the sql command. my question is do i have to add a row such as news_id and reference this as a primary key in order to use the UPDATE command? I have tried to do this but perhaps I should keep trying with that rather than with a single-row database. . .
it's just unclear where i should be looking. thanks anyone for your advice.
chris
View 11 Replies
View Related
Jan 16, 2008
Hello all,
I have been reading these forums for a while but I am now a new member and relatively new to SQL (< 1 year exp).
In a project that I am currently working on I would like to include information related to current market news. An example would be news updates for certain companies that are generated from the Wall Street Journal or MarketWatch. The application would only be used internally and information would only be shared within the organization.
What I'd like to find out is:
Has anyone else worked with or developed something like this? If so, can you please share some insight.Would I need to purchase a Corproate License to use this information or would a personal account that can access the information be enough?What would be the best way to feed the database with this information? E-mails to the server, SSIS, etc.
Thank you for your help and I look forward to learning from you insight and experience.
View 3 Replies
View Related
Mar 1, 2008
Hi,
Im developing a social network, and need your opinion for the right approach.
The basic structure of the my network is:
1. Users
2. Groups
Each user can be related to other users in two ways:
1. They are "Friends"
2. They belong to the same group.
when a user details displayed in the website - through Search results, profile page, forums....etc - ,
there are some actions you can perform - Send him a message, Invite to event and more.
Users can define in their account settings, who will be allowed to perform this actions.
1. Everyone
2. Only my friends
3. My friends and my groups member
What is the best way to enforce this privacy rules with a good performance ?
Thanks for any reply.
View 2 Replies
View Related
Jul 20, 2005
Hello all,I have the following requirement (SQL 2000, SP2)1. Need to restore production database(A) to another database (B) onanother server (No direct connection)2. In the restored back-up(B) SP codes should not be visible (even tosa) or all SP's can be deleted .3. This needs to be carried out daily4. New tables may be added frequently to A5. This job should be scheduled6. I can overwrite the entire database (B)7. I can not encrypt SP in the original database (A)I thought of Snap-shot replication first. But when new tables areadded , I need to add new tables manually to publication .Can some one suggest most reliable and implementable method ?ThanksSrinivas
View 2 Replies
View Related
Jun 2, 2004
I am implementing an application that is looking into another System’s database (DBF). I need to query out new orders that have been put in daily. What is the best way to handle this situation? Should I write a service or have a trigger setup in MSDE? I just need to do a simple SELECT statement that grabs orders between a date range and update my SQL database (MSDE). I am not looking for specific code examples, just a solution.
What are my choices?
Thanks,
Jason
View 5 Replies
View Related
Jun 29, 2006
Some of our databases have many transactions (a million or more) a day. I have read that every so often I need to rebuild indexes, update statictics for all tables (however that is done), and shrink the transaction logs.
I'm confused by all this. What are the daily recommended database maintennace steps steps for database "health" and how can they be done?
TIA,
barkingdog.
View 3 Replies
View Related
Aug 17, 2015
I would like to use SQL Server's built in database snapshot feature. We have a database (e.g., ThatDatabase), and I would like to capture a snapshot of it at exactly midnight each morning. I would need the snapshot to have the same name each day (e.g., ThatDatabase12AM). My non-technical end users (statisticians with SAS) are going to use the snapshot a lot, but are not going to be able to handle it it having a different name every day.
Obviously, I could set up a job with a start time of 23:59:50 that drops the existing snapshot and then creates a new snapshot. This would have the problem that the snapshot name disappears for a few seconds every day. That would either a) kill user sessions, or b) block the snapshot drop and delay the new snapshot until after exactly 12:00 AM.
View 4 Replies
View Related
Apr 19, 2004
Hello -
I have a database server with over 300 databases. I want that MS-SQL Server should daily report me the sizes of SQL databases along with Transaction log files by sending me an email on my address.
How can I do that. Does someone have any script which can help me to do that.
Any help will be appreciated.
Kind Regards,
Rubal Jain
View 11 Replies
View Related
Jun 26, 2014
Looking for what others have done to keep a copy of a database, for read only, on another instance. Need to do this once a day early in the morning with no, or minimal, downtime at the source and target. We have applications that access this copy 24/7, so prefer not to disconnect active users, as a detach/attach or backup/restore might do. Permissions are different on each instance, so would prefer not to overlay users on destination database. Options we are looking at right now are...
Log Shipping
Snapshot Replication
Transfer SQL Objects Task (SSIS)
Our environment for this is SQL 2012 on Windows 2012, in the same AD domain located in the same server room. The database size is 1gb. Needs to be copied around 6:30am daily. Does not need to be updated thru the day.
View 5 Replies
View Related
Dec 16, 2004
Hi!
I want to show intro of the newest news on my startpage. But I only would like to show the subject and part of the message and if you klick on the subject you can se the whole news...how can I do that?
I have an mySQL database with the news.
I havn't found any thread with this topic...
Zäta
View 3 Replies
View Related
May 13, 2015
I have a scenario like below
Product1
Product2 Product3
Product4 Product5
Product1 1
1 0 0
1
Product2 1
1 0 0
1
Product3 0
0 1 1
0
Product4 0
0 1 1
0
Product5 1
1 0 0
1
How to design tables in SQL Server for the above.
View 2 Replies
View Related
Apr 28, 2015
On our particular database server, we run the Rebuild Index Task (Using classic Maintenance Plan Designer) every night. Running the  script below, I saw that about 77 tables had an avg_fragmentation_in_percentage between 80% and 99% !!
SELECT OBJECT_NAME(ind.OBJECT_ID) AS TableName,
ind.name AS IndexName, indexstats.index_type_desc AS IndexType,
indexstats.avg_fragmentation_in_percent
FROM sys.dm_db_index_physical_stats(DB_ID(), NULL, NULL, NULL, NULL) indexstats
INNER JOIN sys.indexes ind
ON ind.object_id = indexstats.object_id
AND ind.index_id = indexstats.index_id
WHERE indexstats.avg_fragmentation_in_percent > 30--You can specify the percent as you want
ORDER BY indexstats.avg_fragmentation_in_percent DESC
I dont understand why these tables are highly fragmented after a daily index rebuild! Unless the users are doing heavy inserts/updates/deletes during the day.
View 6 Replies
View Related
Mar 4, 2006
I'm developing a website, its completley 100% Database driven, ever piece of content is from the database, is this a bad idea?
View 4 Replies
View Related
Jun 2, 2006
Hi,
I'm building a straightforward-ish news site. Currently, the story details (e.g. headline, description, author, date) are stored in a SQL DB. The news is categorised and the category details are also stored in an SQL table.
However - what is the best way to store the actual news article?
At the moment, when the user enters a story, they input the details and article text. The details are saved in the DB and the text is saved as an XML file with filename corresponding to the article DB primary key. When the story is "read" the app pulls the details from the DB and loads up the appropriate XML file from disk.
For various reasons, I need to keep the article stored as XML, either in a file or in the DB. The DB provides for faster sorting and retrieval, and I don't want to store large amounts of data (i.e. the article itself) in the DB if avoidable.
I guess there are a few ways to do it -
1. Store details in DB and article as XML file.2. Store details and article in same DB table3. Store details in one DB table and articles in another
I would imagine that 3 would be the best, but would there be a performance hit? What is the maximum size of field (i.e. article size) I can have in a table?
Cheers
Graham Wilson.
View 3 Replies
View Related
Jun 19, 2006
so last week i finally downloaded and installed SQL Server 2005, and along with that, i downloaded Studio Express (i had previoulsy been using MSDE with WinSQL by Synametrics)
anyhow, today i got an alert from google (you guys use those, right?) that there's a free copy of something called SQL Prompt available from Red Gate
i tried it, and i like it!!
see http://builder.com.com/5100-6388_14-6085249.html?part=rss&subj=bldr
View 2 Replies
View Related
Dec 22, 2006
I have read an article about Reporting Services that was rather critical regarding a number of topics. But, this article was from 2005 and I assume that there have been some improvements in Reporting Services since then. Or?
If so, are there any good places where you can find the news? I haven€™t been able to find a good site for news in, in this case, Reporting Services.
View 1 Replies
View Related
Jun 5, 2006
Hi !
I almost finish my website and ready to upload it to internet. However, I have a thought of how the database will work.
Here's the scenario. My website is a data-driven dynamic website with SQL as the database manager. I have 3 database files.
After I finish with everything, I will have to deploy the application
to the webserver right? Now, let say I deploy / upload it to a hosting
company. Then, people start using my website, all traffic coming in,
and database are getting larger and larger. Then, let say I decide to
make some changes to my website. I change the website here and there.
However, I haven't uploaded / deployed it to the hosting server yet. I
just make the changes in my computer. I test the application and
changes that I make, everything works fine.
My question is: If I deploy / upload my website to the SAME hosting
company after I make some changes, what will happen to the database in
the hosting server? My website has been used my many users and database
is getting larger. If I deploy ./ upload the website that I have made
changes, will it overwrite the database in the hosting server? Or how
does this work?
Anybody has any idea or maybe has already done it?
Any articles or thoughts will be appreciated!!!
thanks you sooo much in advanced!!!
View 6 Replies
View Related
May 15, 2001
My database contains over 50 tables of information - some tables are quite large. Rather than upload the entire database (which I imagine could potentially lock out many users from browsing the website), I would like to upload changes to individual tables. My local database contains the most recent table information. What would be the best way to upload individual tables that would only lock one row at a time while the updates were taking place? A DTS package?
Thanks.
View 1 Replies
View Related
Oct 17, 2004
it must be simple, but not for me!
there's a folder called db in the ftp part of the server and the admin told me to upload my database there,i don't know how to transfer my database in that folder.can you help me?
View 1 Replies
View Related
Jul 29, 2015
I have multiple web databases for storefront orders as linked servers on SQL Server 2008 R2. I need to organize the data for these orders into a structure that can be imported into my ERP application db frequently either on demand or periodically during the day. We are essentially trying to make the manual order entry process automated. My thought was to get the data into views that resemble the schema of the order table in my application db and then schedule a stored procedure with sql jobs or a load routine from within the ERP application that would insert data from the view into the order table.
View 2 Replies
View Related
Sep 21, 2006
HiI'm using sqlexpress on development machine and on client server. I'm building a webapp using membership and role provided for asp. In web.config I have definet membership provider and role provider to point to my database.After web site deployment I get allways message : Failed to update database "c:appapp.MDF" because the database is read-only, and I'm forced to apply rights for ASPNET. More than that somethimes I must re-register users.I have tried to modify in web.config with <remove name="LocalSqlServer"/> <add name="LocalSqlServer"...> but I get errors if I try to design my dataset file:"Cannot get web application service".TIAPaul
View 4 Replies
View Related
Jan 11, 2008
Hello everybody,
I intend to used SQL Express database in my website so that I don't have to go through all the database deployment effort when deplying my website.
In this regard, can anyone please tell me what features would it require in my hosting package so that my application works fine (in database context). Would I have to purchase any additional features (like the way we purchase SQL Server database(s) in hosting package) for SQL EXpress in order to deploy my application??
I look forward to you kind replies.
Thank you.
Zulfiqar Dhuka
View 2 Replies
View Related
Feb 28, 2003
I am currently trying to complete part of my A-level coursework but am stuck.
i am creating a website for a restaurant on which customers can submit information to do with four areas:
---------------------
Bookings
Comments
Job Applications
Pre-order
----------------------
i have used access alot in the past and had no problems creating a running model of my final database.
i have built my website and created the four tables in the alloted MySQL area that came with my website package.
BIG QUESTION:
how do i create the interface for people to submit data and for it to be sent to my database?
i am a complete beginner to MySQL using it for the first time this week so im not sure what i need to do in the slightest to solve this issue
-------------
any help or advice would be VERY VERY gratefull
View 1 Replies
View Related
Aug 3, 2006
Hi all,
How can I deploy my website sql database files, which I have done using Visual web developer. (Visual Studio .net 2005)
Connection srting all these are different in this VWD.
<connectionStrings>
<add name="GoalConnectionString1" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|Database.mdf;Integrated Security=True;User Instance=True"
providerName="System.Data.SqlClient" />
</connectionStrings>
View 1 Replies
View Related
Feb 13, 2002
Ok, I'm doing a football database for fixtures and stuff. The problem I am having is that in a fixture, there is both a home, and an away team. The tables as a result are something like this:
-------
Fixture
-------
fix_id
fix_date
fix_played
----
Team
----
tem_id
tem_name
-----------
TeamFixture
-----------
fix_id
tem_id
homeorawayteam
goals
It's not exactly like that, but you get the point. The question is, can I do a fixture query which results in one record per fixture, showing both teams details. The first in a hometeam field and the second in an away team field.
Fixture contains the details about the fixture like date and fixture id and has it been played
Team contains team info like team id, name, associated graphic
TeamFixture is the table which links the fixture to it's home and away team.
TeamFixture exists to prevent a many to many type relationship.
Make sense? Sorry if this turns out to be really easy, just can't get my head around it at the mo!
View 2 Replies
View Related
Oct 23, 2006
HiI’m abut developing a website that has a 200 megabytes SQL database ,in my estimation the maximum online users are 100 users for first year , I want to make shore a SQL express 2005 database in good enough for my purpose. Another question is how much can I count on a SQL express 2005 database? I mean how much it could be grown and abut security (I mean is it as secure as SQL server?). Thanks.
View 3 Replies
View Related
Jul 15, 2007
I don't know whether this question belong here, but....
In the past I had many customers using the same website each with their own domain name and their own database. To accomplish that, I used MS Access and placed each customers database in separate directories. I steered the customer to the correct directory using their domain name. I am now trying to accomplish the same thing using aspnetdb.mdf and other .mdf database files. I am using the aspnetdb.mdf database for membership, etc. I want the aspnetdb.mdf database file to be unique for each customer. Does anyone know how to accomplish what I was doing with MS Access using aspnetdb.mdf? Is there any way to have multiple web.config files each of which would be dedicated to a particular customer?
View 1 Replies
View Related
Aug 2, 2007
hi.
I would wish to know whether it is possible for me to program the code from html or aspx ( from web hosting server ) to our office intranet database which is window server 2005?
I had tried to google for more info but there are too complicated thing for me to understand.
Actually i am doing the web form feedback form from the website for the public to fill in and submit. i am using the mysql from web server to store the records from the feedback form.
We have another database in our server, ms server 2005 to store records in the intranet office only. i need to get the records from mysql to intranet database. i don`t think there is a automated scripting which allow u to auto update the intranet database from mysql( web server )
So i thought of one thing . program html or aspx to insert records directly to our database intranet . but how ?
I appreciated that.
Regards
newbie on aspnet.
View 3 Replies
View Related
Sep 26, 2007
I am in the process of designing a web application for our application that will be available to the general public.Basically will be used to collect information for a case report. I need to know if there is a way from our internal database driven application to push certain data up to the website that the database may be behind a firewall so I cannot make a direct connection to the external database. I thought I heard about some sort of data sharing protocol. I then will be storing the users entered data in the website database and pulling it from the internal application. So basically I need a secure way of sending and receiving data between a server/client app on a LAN system to the Web site database that could be hosted outside the LAN.
I hope this made sense.
View 4 Replies
View Related
