.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

Limit SUM(col)

Posted By:      Posted Date: September 25, 2010    Points: 0   Category :Sql Server

I have an RSVP table with the columns UserID (uniqueidentifier), EventID (int), and Guests (int). How can I add a row to this table, making sure that SUM(Guests) does not exceed some value?

If there was only one thread, I'd simply test the current SUM(Guests) before adding the new row. But with many threads, I don't see a good way to do this.


Jonathan Wood • SoftCircuitsDeveloper Blog

View Complete Post

More Related Resource Links

The file reached the maximum download limit. Check that the full text of the document can be meaning



I'm facing an issue with the indexing.

I have 1 WFE+Index server+DB server.

Index server is not installed with MS FIlter pack 1.0

When crawling, the there will be document with warning in crawl log:
The file reached the maximum download limit. Check that the full text of the document can be meaningfully crawled.

Documents that with warning are such as doc, ppt, xls, docs, ppts and many others.
However, I view into the successful crawled document, there are doucments with ext doc and ppt.

For large file index, there are MaxGrowthFactor + MaxDownLoadSize required to be added into the index server.

As my understanding is, MS Filter Pack should installed into index server(already did, correct me if i'm wrong).

I looked into the Office SharePoint Seach(CA>Services in farm), if the server is appointed to "Use this server as indexing server", then MS Filter Pack is suppose to be installed into that particular server as well.

At the bottom, there also has another option is "Use all web front end for crawling".

The question here is, IF the option "Use all web front end for crawling" is selected.
Does the WED FRONT END Server required to installed the Ms Filte

'An unexpected error has occurred' on upload after changing limit



I recently changed the max upload size for attachments to TFS work items on our SharePoint site.  I did this by going to the http://tfsserver1:8080/tfs/ProductCollection/WorkItemTracking/v1.0/ConfigurationSettingsService.asmx?op=SetMaxAttachmentSize URL and entering the new size in bytes.

This worked a treat, but not I cannot upload any documents to another site on the same server.

I can open and save documents that are already there, but when I click the 'Upload' button it gives a white page with 'An unexpected error has occurred.' on it.

Is there something else I have to set when I increase the upload limit for work items?


SQLCompact 3.5 NText Limit

Hi my question is simple: How can i store more than 4k characters in a database column.  Im using compact 3.5 and NVarChar limits it to 4000 characters.  Someone suggested i use NText, but when i select that datatype the designer sets the maxlength to 16 and wont let me change it. Im looking to store around 10k-15k characters max in the field, whats the best (if any) way?Software Developer and Web Designer

limit ASP.NET User Session without blocking production

 If the Web Site is in production and there are hits from one particular place (Say London!) and the after 1000 (or x) requests, user session should not be allowed. So what to do in such situation without affecting current production site?  Please Advice. Thanks!  

How to limit SQL Performance?

I am running sql server locally as it is a developer environment. When ever i do an intensive task sql chews up all my ram and slows my machine to an almost stop. I don't  care if it uses most of my ram but the fact that it slows everything else down is extremely unproductive. When its doing the task my CPU Usage sits around 50% but the ram gets mostly used. I tried limiting the ram but this does not stop it from slowing the machine only stops it from using so much memory. I susspect its either the HDD or Ram Bas speed that is the problem.  Anyway is there anything that can be done so SQL is a little less greedy?

network BIOS command limit has been reached??

 Holy cow... my website just started throwing this error whenever I try to debug.  The full error is ...Parser Error Message: An error occurred loading a configuration file: Failed to start monitoring changes to 'path to my server' because the network BIOS command limit has been reached. For more information on this error, please refer to Microsoft knowledge base article 810886. Hosting on a UNC share is not supported for the Windows XP Platform. Checked out the article, but doesn't seem to apply, as my pc hasn't changed recently...  http://support.microsoft.com/kb/810886   Any ideas why it was working fine just a few minutes ago, and now it isn't?   The code on the site is working fine, it's just when I'm trying to debug. 

Limit MOSS users to specific domain only

Hi guys, I need to set MOSS portal so it will be available to one particular domain user only. I turned anonymous authentication off and delete all items from  Visitors group except  <my domain name>\domain users . I supposed it had to make the trick but still users from trusted domains could login on portal. Am I missing something?

Error in file upload (quota limit)

Hello, we have a Windows SharePoint Foundation 2010. The quota limit of the website is 10 GB. We get the message that no more items can be uploaded. We have change the quota limit to 25 GB. The backend is a SQL Server Standard. Despite the new limits, we will continue to receive this message. Log: 09/01/2010 11:01:31.52  w3wp.exe (0x0BE4)                        0x1E48 SharePoint Foundation          General                        8e2s Medium   Unknown SPRequest error occurred. More information: 0x80070002 73266089-af18-4755-be8c-f0637000a92c 09/01/2010 11:01:31.53  w3wp.exe (0x0BE4)                        0x1E48 SharePoint Foundation          General                        8kh7 High     Your changes could not be saved because this SharePoint Web site has exceeded the

What is the STSADM command to set a quota limit on a site collection?

I have a site collection that I need to make larger than the default size of 1GB.  I need to up it to 8GB's.  Can anyone give me the STSADM command that will do that?

Database server connection limit exceeded..

I have an SSIS package and have been adding additional DFTs to it.  Where there are dependencies between transformations I identify them.  However where things can procceed in parallel I do not constrain them form a control flow standpoint.  After adding another DFT I am now getting package failure due to "Database server connection limit exceeded" (my local source database is SQL Anywhere and it has a max connections of 10 in production it will be full blown Sybase and will probably not be so constrained).  I think I can solve the problem just my making control flow dependencies to reduce the amount of parallel activity but I am wondering if there are other things I should consider doing.  For instance are there other settings I can tweak that tell SSIS to run parallel up to X connections out of a connection pool? (or something like that). Some may comment that this relates to my post of yesterday on package strategy (master-child packages or one big package).  I still have one big package for now but may break it into master-child.  Still I think I can control the amount of parallel activities through control flow even if it remains one package. Any thoughts or comments on this would be appreciated. - Charles PS - just ran my package and this time it succeeded - sometimes I hit the limit of 10 connections sometimes not...

error code for size limit reached

What is the error code, when the DB reaches the 10GB limit. I just wasn't ready yet to check the 36.000 error codes of SQL Server 2008 R2.

Is there a limit to the length of a vb script job

This sounds stupid, but I created a ms sql server job that is activeX - language = vbscript The job is just a series of log statements. If I make the script > 300 lines long, I get errors. If I chop out some of the log statements, it works ok. Does anyone have any idea what is going on and how to get around / fix this? thanks jonathan

Dynamically Drop and Create tables, overcoming 4000 charachter limit

We have a Navision SQL-server database for 7 companies. Each table starts with the name of the company. Except for the CompanyName-part, the tables names are equal. I made a Foreach loop that dynamically transfers tables/data from the the Navision-database to a staging-database. I also want to Drop and re-Create the tables dynamically. However, if I try to do that via an expression in a SQL Task, SSIS complains about the 4000 character limit. What is a better way to do this? I want to execute SQL-commands and have SSIS replace part of the tablename with the contents of a variable (being the name of one the 7 companies). I have no access to the Management Studio or the DB so I need it to be done within the package. What is the best way to do that?

error code when DB reaches limit?

What is the error code, when the DB reaches the 10GB limit. I just wasn't ready yet to check the 36.000 error codes of SQL Server 2008 R2.

database size limit about SQL Server 2005 Express

I know that there is a size limit (4 GB) for SQL Server 2005 Express, but I am not quite sure if the limit is applied for only ONE database data file or for ALL the database data, suppose I have two databases DB1 and DB2, so which of the following statement is correct? A. The size limit for DB1 is 4GB, and the size limit for DB2 is also 4GB, so if DB1 is 3G and DB2 is 3.5G,that will be OK. B. The total size for both DB1 and DB2 can not be larger than 4GB, which means if DB1 is 3G, then DB2 can not be large than 1G.

Want to page content based off of a character limit or height of container

First of all I would like to say hello. I have created a backend that allows me to update my site content. I am using fckeditor to pull the data from my table in the database. The problem I am having is this:  I need to create paging of content so that when the height restriction is met a next btn or numbering system displays to allow the user to click to the next page of content. Can anyone point me in the right direction or possible tell me how I can do this?

How to limit an enlargement(maximaze) of UI window on all screen?

How to limit an enlargement(maximaze) of UI window on all screen?
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