.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

when max batch requests reaches about 1000/sec, what suggestion?

Posted By:      Posted Date: October 22, 2010    Points: 0   Category :Sql Server
the cpu is high when batch request is high, whatis the solution?

View Complete Post

More Related Resource Links

Run Button Behavior: Suggestion/Bug


Note: This could be a bug or considered as suggestion. I am not looking for solution.

1: I have ImageWatermark.cshtml open and currently in focus.

2: I have Photo1.jpg selected in left Files workspace.

3: Now if I Click "Run", instead of opening ImageWatermark.cshtml it trys to open Photo1.jpg and it fails.

So ideally I would expect the "open file (ImageWatermark.cshtml) to run rather than running the selection from Workspace.

RSS implementation code - need suggestion


Please suggest what is the best approach of coding for RSS implementation,


Implementation 1:

a) Add custom handler in web.config for .rss type

b) Create a handler class (RSSHandler.cs) in APP_Code

c) Create a Sample.rss file

d) Browse Sample.rss in browser

 Technical Solution:Utility Classes:I)                   

Automatic Batch Printing in ReportViewer Remote Mode


Please help me, i have a properly working codes that is capable of the following:

1. Printing of Reports from ReportViewer without using the build-in print ICON in the actual ReportViewer. to view the working for the printing alone please click here.

2. Batch Printing by making a loop and placing a checkbox on the gridview where the needed paramerter (DataKeyNames ID) is retrieved then pass to the ReportViewer

This is my Code

foreach (GridViewRow row in GridView1.Rows)
            CheckBox chk = (CheckBox)row.FindControl("CheckBox2");
            if (chk.Checked)
                ReportViewer1.ServerReport.ReportServerUrl = new Uri("http://TestServer/ReportServer");
                ReportViewer1.ServerReport.ReportPath = @"/Tavern/StudPaymentReport";
                ReportViewer1.ProcessingMode = ProcessingMode.Remote;
                ReportParameter[] rptParams = new ReportParameter[1];

                rptParams[0] = new ReportParameter("ClientID", GridView1.DataKeys[row.RowIndex].Value.ToString());


ASP.NET: Intercept, Monitor, and Modify Web Requests with HTTP Filters in ISAPI and ASP.NET


There can be many reasons to reroute incoming Web requests. For instance, sometimes it's necessary to redirect a browser to a page based on user criteria without passing long lists of parameters in the URL. In the past, the only way to intercept such page requests and send them elsewhere was with ISAPI. Now, in ASP.NET, the IHttpModule interface provides notification of server requests, and lets you easily reroute them based on criteria other than browser type or version. Here the author demonstrates the use of IHttpModule for interception and explains the use of ISAPI filters for anyone who isn't yet using ASP.NET.

Panos Kougiouris

MSDN Magazine August 2002

ASP.NET Proxy Page - Used for Cross Domain Requests from AJAX and JavaScript

The article ASP.NET Proxy Page - Used for Cross Domain Requests from AJAX and JavaScript was added by Aamir Hasan on Thursday, August 19, 2010.

One of the pain points with developing AJAX, JavaScript, JQuery, and other client-side behaviors is that JavaScript doesn't allow for cross domain request for pulling content. For example, JavaScript code on www.johnchapman.name could not pull content

SharePoint Batch Update Auto Increment Field Value


Hello All,

I am making use of SharePoint List Batch Updating methodology in order to update the items in bulk. I build the query dynamically for each and every item using StringBuilder and process the data ultimately using 'ProcessBatchData' Method.

Now, I have a requirement where I have to increment a particular field value in the query while iterating through each item for building the query. How can I auto-increment a field value for each item in the batch query?


VSeWSS 1.3 Feedback and Feature Requests

First of all I would like to say this tool has improved quite a bit since the last version.  However, I still feel that it has a long way to go before a SharePoint developer would actually consider using it.  The functionality I am targeting today is the web part functionality.

I really like the added options to Deploy, Package, and Retract Solutions added to the context menu of your solution.  These all seemed to work really well.  I was able to create a quick Hello World web part and deploy it.  I activated it manually and was able to view it immediately.  One thing, I am very appreciative of is the ability to choose between a Full Trust or Partial Trust web part when you create the project.  You still have to specify the Code Access Security settings yourself, but at least it is possible now.  I am also a fan of the new options to quick deploy directly to the bin folder and 12 hive.

As a SharePoint developer, I put a lot of files into solution packages.  Pages, XML files, Master Pages, Site Template Definitions, you name it.   I want to be able to put these files in my wsp.  I as

How to handle this format in c # 1000/1

Hi. I have problem. If i have data in sql table in this format " 1000/1 " or "2000/2" how i can check if value exist in table + to check what is last record in the table or what is max value in the table? 1000  Connex Y NULL 2000\2   Dan NULL NULL 3000\3   Eged NULL NULL 4000\4   Veolia NULL NULL if I use This code  i get this error " Conversion failed when converting the varchar value '2000\2' to data type int" I need to convert the value only after to check it?   using (SqlCommand cmd = new SqlCommand(strSQL, cn))    {      int intCountExisting = (int)cmd.ExecuteScalar();      if (intCountExisting > 0)       MessageBox.Show("ID Already exists!");    }

Best approach to handle concurrent requests in winforms

I have a windows client application which would be used many users. This application submit requests to run a workflow (note that this is not a WWF or WCF service, its a class library thats gonna do some processing). What would be the best approach to code this? Would processing each request on a separate thread be a correct way? I am a newbie at this. PLease help. Thanks!

Best approach to handle concurrent requests in winforms

I have a windows client application which would be used many users. This application submit requests to run a workflow (note that this is not a WWF or WCF service, its a class library thats gonna do some processing). What would be the best approach to code this? Would processing each request on a separate thread be a correct way? I am a newbie at this. PLease help. Thanks!   

Determining the status os the Batch job that process SSAS Cubes

Hi All, I have a cube and that is processed through a batch job. The problem I am facing is there are many packages which are calling this Batch job to process the cube. Is there a way to determine the state of the job before the packages call this batch job to process the cube. And in which database can I find all the information about the jobs on the server. Thanks for your help. Vineeshvineesh1701

How can I improve the performance of batch inserts with the JDBC driver?

In our testing, batch inserts are more than 4 times faster on Oracle with the Oracle JDBC driver than on SQL Server with either the Microsoft or jTDS JDBC drivers on the same hardware.  The issue appears to be with the JDBC driver, not the database server.  We have run tests with SQL Server 2005/2008 on a number of machines with similar results. The following code shows a simplified example of the code we are executing.  It uses a 2 column table which has an index on the id column.  In the test program we are inserting 100k rows with a batch size of 10k.  Any suggestions on improving the performance with the SQL Server JDBC driver?   private void testBatchInserts(Connection conn, int rows, int batchSize) throws SQLException {     String sql = "INSERT INTO Bench (id, name) VALUES (?, ?)";     conn.setAutoCommit(false);     PreparedStatement stmt = conn.prepareStatement(sql);     int batchCount = 0;     // For each row...     for (int i = 1; i <= rows; i++) {       // Create the record       stmt.setInt(1, i);       stmt.setString(2, "ROW #" + i);       // Add it to the batch       stmt.addBatch(); &nb

Stand alone server into Cluster Server...recomandations and Suggestion

Hi all I have Stand alone server(SQL Server 2000) on Win2k3(SP2). Now I want make as Cluster server. way I am thinking 1.I have create fresh Cluster Environment and move the Databases 2.Arrange SAN drive and move all Databases(Data files/Log files) to SAN drive and Add one more Node and Create Cluster. I am realy new cluster some body help me the Direction to move Standalone to Clusteer.   Thanks in AdvanceSNIVAS

How do I autenticate requests using header information with webHttpBinding

I'm using ASIHttpRequest API to communicate with my WCF services. The WCF services are set up as webHttpBinding so I can communicate in basic JSON without SOAP. This is the code I'm using to talk with the service and pass along user credentials (iPhone; but just figure it places the username and password in the header like Digest or Basic):   NSURL *url = [NSURL URLWithString:@"http://allseeing-i.com/top_secret/"]; ASIHTTPRequest *request = [ASIHTTPRequest requestWithURL:url]; [request setUsername:@"username"]; [request setPassword:@"password"];   I'm using a membership provider on the server side to authenticate my users. Is it possible to authenticate each request using the username and password sent in the above code? Please help I've been searching for a solution for a while.

Use 1000 separator - using US separator instead of local separator

I'm having a bit of trouble to get the proper 1000 separator to show up in my number fields. I have an SQL Server 2008 Developer Edition running on a 2008 Server Enterprise Edition, all set up in English, but the input language is set to de-CH (German (Switzerland)). For my currency fields, I've configured the following number format string: 'Fr.' #,0 According to the Number section in the TextBox properties, the 'Current regional settings' is German (Switzerland) and the preview shows Fr. 12'345 which is exactly what I want to see. However, in the report preview, even after multiple refreshes and even a machine restart, in the report preview, the above number is returned as Fr. 12,345 So, the en-US separator is being used (for de-CH the number means 12 Francs, 345 cents.. not the twelvethousand threehundredfortyfive we're looking for). The only way to get around that is to set the language de-CH on the report itself. Though that begs the question why it picks the proper locale in the textfield properties (and thus returns the proper preview when configuring the number format), but then ignores the locale when running the preview.

Need suggestion on table creation

Hi All    I want to create a DB in production server. In the DB 5 tables will consists lakhs of records.    We are using SQL Server 2005 Enterprise Edition    To produce the better performance i want to create 5 Data Files for 5 tables.Is my approach is    right or wrong.    Waiting  for valuable replies.

Resore suggestion

Hi all I have  fullbackup at 5:00PM yesterday and Transactinal log every 30min (24 hours),I took Diff backup   7:00PM yester day and Diff backup 4:00 AM today. My  Transactional backup running every 30 min, If any faulure what steps i have to take... Please correct me  if I am wrong 1.Restore Fullbackup(Yester day) with no recovery 2.Restore latest Differancial backup with no recovery 3.Restore all trasactional backups 4:30 with no recovery onwards.... and restore last trasactional backup with with rcovery it is creect scenario ??..please help me.. Thanks in Advance  SNIVAS
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend