I am creating a e-learning application , where the students (wireless) connect to the teachers machine, the teacher hosts a tomcat server.
the teacher has a set of HTML web-pages(each of which can be thought of as a slide). and the students can view a web slide-show on his/her browser...
the problem is.... i want the pages on the students browser to be redirected according to the teachers input..
in short:
i want the server to automatically redirect all the client browsers to the next page when the teacher wants it to be so...
how do i do it??
[i am using JSP/javascript/Java/Tomcat/Eclipse]
I want to make an email for my website like "[email protected]" where people can send their feedbacks and suggestions to it. How can I do it? Can I do it with PHP or there is something else needed?
I need to include several stored procedure in a single transaction in a single database,
if any of stored procedure fail then roll back transaction of all stored procedure procesed in the scope.
I work with SQL-SERVER 2008
I would like to split a string using multiple chars to split upon. For example, consider spin text format:
This is a {long|ugly|example} string
I would want to parse this string and split it on the "{", "|", and "}" chars
myString.Split('|','{','}')
Now I have tokens to play with, but what I would like is to retain the info about which char was used to split each piece of the array that is returned.
Any existing code that can do something like this?
Hi everybody,
Magento provide translation feature, a nice one for e-commerce platform.
But it seems to me that the translation is only for the predefined magento keyword, like 'add to cart', 'add to wishlist' etc and not for the product name, info, and description that the user input to the store.
Does anybody know how to implement this??
Any help would be much appreciated
Thanks! :)
I am using ASP.NET environment.
Is it possible to track last N number of stored procedures called with parameters info?
I see in this article "Recently executed stored procedures";
http://sqlfool.com/2009/08/find-recently-executed-stored-procedures/
But I need input parameters also.
If not what can be the best way to track it?
For example, adding an insert statement to a information table for every single procedure beginning?
Or is there any better solution for this?
On my SQL Server 2008 I have a stored procedure with a large number of parameters.
The first part of them is used in every call and parameters from the second part are used rarely. And I can't move the logic to two different stored procedures.
Is there a way to encapsulate all this parameters to a class or struct and pass it as a stored procedure parameter?
Can I use SQL CLR. Are there other ways?
We have a web service which provides search over hotels. There is a problem with performance: a single request to the service takes around 5000 ms. Almost all of the time is spent in database by executing storing procedures. During the request our server (mssql2008) consumes ~90% of the processor time. When 2 requests are made in parallel the average time grows and is around 7000 ms. When number of request is increasing, the average time of response is increasing as well. We have 20-30 requests per minute.
Which kind of optimization is the best in this case having in mind that the goal is to provide stable response time for the service:
1) Try to decrease the stored procedures execution time
2) Try to find the way how to unload the server
It is interesting to hear from people who deal with booking sites.
I have a WS 2003 32-bit system running SQL Server 2005 Enterprise with 24GB of RAM. The /PAE switch is enabled. Can SQL now use the 24GB or does AWE need to be enabled?
I just checked out the licensing for SQL Server and well...i can't afford it since im funding this project myself. I have been tinkering with MySQL and PostgreSQL a bit the past few weeks and at this point I can't really decide which to go with. MySQL has a large user base and lots of people using it so finding out how to do various items will not be to hard o find.
I will be using ASP.NET with this project.
Anyone have experience going from SQL Server to either of these databases? Is one stronger than the other? Thoughts?
Hello,
I'm executing sql query on my database. I have SQL Server 2008 installed on my D harddrive which has 55 GB free space.
I have also C drive which has sth like 150 MB free (right now).
While executing that query on quite a big table (16 GB) I have an error:
An error occurred while executing
batch. Error message is: Not enough
disk space.
I would like to know if there is any possibility that I can make SQL Server to use D drive instead of C
Or maybe there is any other problem with what I'm doing ?
Thanks for help
Is there a way to get the profiler without installing Microsoft Sql Server?
If the answer is no, which edition do I need to get the profiler? Do I need the Developer Edition?
I have a trace setup for SQL Server Profiler to monitor SQL that is executed on a database. I recently discovered that trigger execution is not included in the trace. After looking through available events for a trace, I do not see any that look like they would include trigger execution. Does anyone know how to setup a trace to monitor the execution of triggers?
Situation:
Running a report on SQL Server Reporting Services
When I do a Preview of the Report all my charts look fine. No problems.
When I run a subscription for the report, the chart look different. Like completely different legends are gone etc.
Any ideas what the cause would be?
BTW the charts are Dundas Charts.
Hi
I am looking for solution which can push automatically a certain event (let's say RSS message) realtime to a desktop user. A toolbar app or a desktop (growl like) will be super for this push.
I have looked at few options but cannot find much info on these kind of apps.
I have looked at conduit - it sucks as there is lot of other fancy options which I am not interested in offering to users.
Please let me know.
Thanks.
I have searched the internet thoroughly for this type of issue, there were responses but hasn't really found a concrete solution yet.
I have an application which makes use of SQL Server 2008 R2 and thus it makes connections with a database file which I have set up. The application executes successfully, makes connections with the database and retrieves/inserts/updates data to and fro the database.
However when I come to create a deployment project i.e. a setup project, I fail to transfer my database files to other computers and make database connections. I have checked the SQL Server 2008 prerequisite in the publish settings of the application and has also included the database files.
Can anyone suggest the best way to this type of setup?
Thanks
I have a web server on a Virtual Private Server with a hosting provider. Unfortunately, they are really stingy with IP addresses and I need to run several SSL certificates on my server, so I will need a few more than I have.
I have a block of 5 static IP addresses on a business package through a different ISP and I am only using 1 of them for connectivity in the office. What I am wondering is if it is possible to use the 4 unused static IP addresses from this ISP on my VPS, which is hosted by another ISP?
The VPS (web server) is running Windows Server 2008 R2 Web Edition. If this can be done, please let me know how to configure it.
Following problem:
I need to get the position of a record in the table. Let's say I have five record in the table:
Name: john doe, ID: 1
Name: jane doe, ID: 2
Name: Frankie Boy, ID: 4
Name: Johnny, ID: 9
Now, "Frankie Boy" is in the third position in the table. But How to get this information from the SQL server? I could count IDs, but they are not reliable, Frankie has the ID 4, but is in the third position because the record with the ID '3' was deleted.
Is there a way? I am aware of ROW_RANK but it would be costly, because I need to select basically the whole set first before I can rank row_rank them.
I am using MS SQL Server 2008 R2.
I have the following table...
TABLE: Accounts
ID (int, PK, Identity)
AccountType (int, PK)
Username (varchar)
Password (varchar)
I have created a composite key out of ID and AccountType columns so that people can have the same username/password but different AccountTypes.
Does this mean that for each foreign table that I try and link to I'll have to create two columns?
I’m using SQL Server 2008