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


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

How to estimate "Minimum query plan threshold for considering queries for parallel execution(cost es

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

Hi,

We have 4 QUAD core processors and we have set max degree of parellelism to 4(as suggested by Microsoft). As of now we are using the default value for "Minimum query plan threshold for considering queries for parallel execution(cost estimate)".

Please suggest how to estimate the best value for for "Minimum query plan threshold for considering queries for parallel execution(cost estimate)"?

Thanks in advance.

 

 




View Complete Post


More Related Resource Links

Estimate weight of BLOB data in our content database

  
How can I estimate overall size of blob data?

Memory error: The operation cannot be completed because the memory quota estimate when trying to dep

  
Hi All: We have installed SQL Server 2008 Integration Services in a Windows 2003 machine. RAM capacity is 4GB We have a created a sample project with necessary data source, data view, cubes and dimension definition. When we try to build the cube, it is throwing the below exception Memory error: The operation cannot be completed because the memory quota estimate (1504MB) exceeds the available system memory (1331MB). We even tried with data view of few columns but encountering the same error. How to fix this issue? Please help Regards, Swami

how estimate stored procedure excute time

  
i have on stored procedure using that one i get back up from the data base how can i know before execution stored procedure execute time

Estimate and Job Process application development idea

  

Hello all,

I am trying to develop one application, which will serve the purpose of estimation and job process management system. For estimation, I have category, subcategory and product. Estimate has different types. Each product has different properties.

At the time of estimation, user selects the product based on subcategory. Based on criteria and input, new value generated for each time for same product. Now I have to save this all products into estimate table. One estimate has multiple products.

After estimate approved, job will be created based on estimate. Job will take input all the items/products from estimate and then process each item.

My question is what is best way to do this?

Should I keep only one table estimate-detail(like order-order details scenario) which has all selected products and use it at the time of job process? Or Should I create another table for job detail?

I am novice in asp.net and searching best practices for this kind of application? Please try to describe in detail.

Thank you for your time!!!

 

 

 

 

 


MDX For Full Year Estimate (FYE) calculated measure

  

I’m trying to come up with an MDX expression/statement that I can use at server level to create a calculated measure. In my organisation we work with totals on YTD, which is not a problem for me to get its MDX. We also work with totals on Full Year Estimate (FYE). Using the following example can someone kindly hep me with an MDX expression/statement that I can use. 

 

Dimension – Attendance Status

Attribute &n

Categories: 
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