.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

With CTE Limitations

Posted By:      Posted Date: September 10, 2010    Points: 0   Category :Sql Server
Hi,  Is there any limitations on how many With CTEs you can use in a Stored Procedure? I have a SP which has 3 temp tables. I am trying to use With CTE instead of temp tables. The reason is to index them and have better performance.  Thanks in advance. Best Wishes, Arbi --- Please vote if you find this posting was helpful or Mark it as answered.

View Complete Post

More Related Resource Links

Dynamic Data Use And Limitations


I have been looking at dynamic data based applications for a little while now and it looks like this technology could be deployed in many scenarios. In my case I am interested in using it to deliver relatively small database applications to small to medium sized companies, often replacing data in homespun spreadsheets with a well ordered database. The attraction to me being that dynamic data allows the application to be created (and subsequently altered) much more efficiently than with lots of hand coded web forms.

What experience have others had using this technology on live sites, have you come across any road blocks or gotchas in terms of performance, security or general functionality? Is it being used in a diverse range of scenarios?

vs 2010 Web Developer Express Limitations

What is the different between the vs 2010 Web Developer Express and the full version of 2010? With the vs 2010 Web Developer Express will I be able to use all types of databases (MSSQL, MySQL, Access, ect) and enitity frame work?

Limitations Of SSRS

Hi All, I am parikshit currently i am working BI Technology. I have to find out all the limitations of SSRS? also Why and when we use SSRS ? Thank you, Please give me answer. it is benifitial to all. please... Parikshit    

Reporting Services 2008 Limitations.

Hi All, I want to share the limitaions of SSRS 2008. 1) Blank Page issue with Dynamic Columns and Rows. 2) Global Parameters Can not be used in Body of the Report. 3) Details under the adjecent Groups will have issue with data. Nevermind if i am my assumption are wrong please correct me :) Please add the limitaions and issues which i am not listed above. Thanks, Veeren.  

Limitations of Generics

1. Can anyone explain me the basic disadvantage og generics and delegates? 2. Also i would like to know the the basic reason why generics were introduces apart from TYPE SAFETY???  3. What is the difference between Error and Exception ? 4. What is the difference between shadowing and overriding? Note: Request you to please don't send any links and  please explain with examples. Any help APPRECIATED.

using table valued parameters for stored procedures any limitations

I am thinking of using a table valued parameter for my new stored procedure, but wonder if there are any performance implications to be aware of and is the limitation of using statistics applicable with table value parameters, i.e do they keep statistics and will this affect the judgement of query plans i.e estimated number of rows, from my experience table variables do suffer from this problem but I would like to confirm if it applies to table value parameters as well.

limitations of sql express edition

hi to all,
 is it true that bcp is not supported by sql express edition ?
 can some body list the limitations of express edition in a simpler way . not like microsoft's website .
which gives comparision like  on the following links .

Solution for Writeback Limitations


Writeback is an excellent feature in Excel 2010 but it lacks the ability to get back to the original value once its been changed.  Writeback is ideal for forecasting but if someone overwrites/writebacks the forecast on an "actual" cell, the values for the actual number is lost and cannot be retieved short of deleting the writeback data.  As recommend to me by an Microsoft SSAS member at TechEd, I split the data up into a dimension called Scenario containing the "Actual" and "Forecast" memebers.  With this, one can see the actual number and forecasted number side by side and can forecast using the forecast member.  The problem now is that one cannot aggregate on these 2 cells.  The thought would be to create a calcuated member that check does essentially, ISNULL("Actual", "Forecast").  This new "Verified" member works, but now the issue becomes rolling up the data.  Since this member's condition is not scoped, the "Verified" value rolls from the lowest level to the top.  Is it possible create the member to be conditionalized so that it only uses the ISNULL condition at the lowest level, but then rolls up properly?

Let me try to illustrate the issue...

Scenario = "Actual"

Date     Store

Limitations of MeasureExpression


I have a many to many dimensional problem that I am trying to solve.

Am I right in thinking that MeasureExpression is limited to a simple expression such as [value]*[percantage] and cannot cope with [value]*[percentage1]*[percentage2]?

What I am trying to achieve is similar to the example under the heading Measure Expressions and Many-to-Many Dimensions in the article http://msdn2.microsoft.com/en-US/library/ms345139.aspx. In this example there is a many to many relationship between Organisation and Store Sales; and the weighted [Amount] is calculated in the MeasureExpression as [Amount]*[Ownership]. 

They key difference in my scenario is that instead of a single many to many relationship between Organisation and Store Sales I have several relationships so I would need to have a calculation such as [Amount]*[Ownership]*[Sales Director Percentage].

Is there a way that MeasureExpression could support more complex calculations - or is there a better way to achieve this?


Benefits And Limitations Of SOA


Hello Friends

Can anybody explain me or provide me with a links of good articles/tutorials on "Benefits And

Limitations of Service Oriented Architecture" ?

I mean Where to Use and Where not, the SOA.

Thanks In Advance



SharePoint 2010 workflow limitations?


My company is looking to use SharePoint 2010's workflow capability to set up about 100 different business processes, each of which will require a separate custom workflow. I'd like to know:

1) what, if any, limitations there are that we need to look out for with workflow

2) are there any good plug and play software packages out there that sit on top of SP 2010 and extend workflow capability

3) if anyone can suggest a specific vendor we can look to that has such a product

Example of a limitation - in SP 2007 (although we will be using 2010), workflow due date - you are only able to enter the number of days or weeks for task completion, not hours and minutes.

Upgrading - SP2010 batch query limitations?


According to technet (http://technet.microsoft.com/en-us/library/cc262787.aspx) the below applies when executing queries to lists even though the list item hard limitations are set in the millions...

My question is, are there any other changes in regards to the limitations when processing batch queries on lists in Sharepoint 2010? What was the below limit in 2007?

It is essential for me to be able to inform my partners if anything did change, so that they can prepare there applications for any extended limitations, when we are upgrading.

List view threshold



Specifies the maximum number of list or library items that a database operation, such as a query, can process at the same time outside the daily time window set by the administrator during which queries are unrestricted.


Thank you in advance/Jesper Wilfing


Limitations of SharePoint 2010 in IE9 browser


Can anyone please tell me about limitations of different SharePoint 2010 functionalities in IE9 browser. It can be related to look and feel also.

Sharepoint Consultant from NY, USA

Are there any limitations in SharePoint 2010 BCS when working with large data?



We are working on suggesting the best approach that would be suitable to support user data stored in SQL Server 2008. User data is huge (in Terabytes). I need to understand if there are any issues using MOSS 2007 BDC or SharePoint 2010 BCS to interact with SQL Server 2008 database tables? I understand that BCS offers a no-code solution for interacting with SQL tables, however when handling such large data, can we have better performance if Stored Procedures and ADO.Net is used to fetch and update the data?

All in all I need to understand the pros and cons in both these approaches. Any pointers, specifically to related real world case studies shall highly be appreciated. Thanks much!

Limitations of SQL for Excel?


I have a query that I have constructed to read data from an Excel spreadsheet:

          commandSourceData = new OleDbCommand(
            "SELECT [CatID], " +
            "'Gender' = CASE " +
            "   WHEN [Amazon Notes] IS NULL OR LEN([Amazon Notes]) = 0 THEN NULL " +
            "   WHEN [Amazon Notes] LIKE 'If Male%' THEN 'Male' " +
            "   WHEN [Amazon Notes] LIKE 'If Female%' THEN 'Female' " +
            "   ELSE NULL " +
            "END, " +
            "[Amazon Category] AS AmazonCategory, " +
            "[Buy Category] AS BuyCategory " +
            "FROM [Costumes - Decor$] " +
            "WHERE [CatID] IS NOT NULL AND " +
               "([Amazon Notes] IS NULL OR " +

Anyone know any Limitations/Disadvantage of using Windows Workflow Rules without Workflow?


I read from this forum and other google search of using the Windows Workflow Rules without Workflow. Do any one know the limitations/disadvantages for using it? Please respond.



Limitations to Model Validation in Web API

Discussion about limitations to Model validation in ASP.NET Web API using data annotation technique. | Under-Posting and Over-Posting in Model validation.
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