Kent Waldrop Fe08's Q&A profile

• SQL Server Can I Use Non-empty Behavior for These Calculated Members?

  I still find myself extremely confused about using the non-empty behavior for calculated members. We have a series of calculated members that we refer to as "Velocity", such as "Velocity Sales". The basic definition for these velocity measures is to get the total from the previous 63 business days and then annualize that total (i.e. multiply by 4), with the 63rd business day belonging to the previous month. For example, Velocity Sales for any day in September 2006 would be totaling the sales $ for the business days in the range of 06/05/2006 through 08/31/2006, and then multiplying it by 4. Perhaps not surprisingly, these measures result in extremely poor performance. Since I'm confused on the non-empty behavior, this p ...Show All

• Windows Forms How to make verical scrollbar in gridview wider

  Hi, I need to make vertical scrollbar in gridview and combobox wider because I am building a touch screen application. Any help or links will be appreciated. Control Panel + Display, Appearance tab, Advanced button. Select "Scrollbar" in the Item combobox and increase the size. This will increase the width of the vertical scrollbar for *all* applications, rarely a problem for a PC equipped with a touch screen. ...Show All

• SQL Server This SQL Server has been optimized for 8 concurrent queries. This limit has been exceeded by 8 queries and performance may be ad

  One of the reports in my ASP.NET application needs large amount of data to pull with the help of 16 store procedures at a time. To pull 1 million rows SQL server takes more that 5 minute for one user. At the same time error log shows following error for the SQL server: “This SQL Server has been optimized for 8 concurrent queries. This limit has been exceeded by 8 queries and performance may be adversely affected.” any suggestion about that. Thanks in advance You are using MSDE or Personal Edition of SQL Server. These SKUs have workload governor that limits the number of concurrent queries that can be executed on the server. See below topic for more details: http://msdn.microsoft.com/librar ...Show All

• .NET Development .NET 2.0 breaks .NET 1.1?

  Hi! I just heard that there is a problem with something in .NET 1.1 when .NET 2.0 is installed on the same computer.. That there is some logic in .NET 1.1 that fails. Does anyone knows what this problem is And if so any workarounds I have tried to search around but did only find this thread http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=171977&SiteID=1 which didn't say that it was a problem with both 1.1 and 2.0 on the same computer. Thanks for any answer, --Rune ahmedilyas wrote: never heard of it. 2.0 does not break 1.1. I'm currently running both of them without any problems what so ever. as stated, it installs side by side, one does not care about the other really nor ...Show All

• Visual Studio Express Editions save in Excel

  Hello! How can i set the size of the textboxes in my code excel 2003 Imports Microsoft.Office.Interop Dim xlApp As Microsoft.Office.Interop.Excel.Application Dim xlBook As Microsoft.Office.Interop.Excel.Workbook Dim xlSheet As Microsoft.Office.Interop.Excel.Worksheet xlApp = CType (CreateObject( "Excel.Application" ), _ Microsoft.Office.Interop.Excel.Application) xlBook = CType (xlApp.Workbooks.Add, _ Microsoft.Office.Interop.Excel.Workbook) xlSheet = CType (xlBook.Worksheets(1), _ Microsoft.Office.Interop.Excel.Worksheet) xlSheet.Cells(1, 1) = TextBox1.Text xlSheet.Cells(2, 2) = TextBox2.Text . xlSheet.Application.Visible = True ...Show All

• SQL Server Invalid Descriptor Index error

  I'm testing db to db transactional replication on a box ( all on the same box ) and the distribution agent fails with the above error. I know it's something to do with the physical server as this test works on other servers fine. SQL2k Ent sp4 on w2k3 ent sp1. ( clustered ) Server and Agent accounts are in local admins, tried push and pull, named and anonymous. Replication also fails if I use the default snapshot location. I suspect policy restrictions ( maybe on the sql service accounts ) Any pointers would be helpful - there are no errors other than above, sadly. I am having the same issue and wondered if you had found out what was causing the problem. In my case it is a brand new publication bu ...Show All

• Windows Forms Populating treeview with database?

  Hi..  How to populate the treeview control with sqlserver 2000 database Does the treeview control only work for parent-child relationships I tried to connect with the database, but the treeview is not displayed in the browser.  Below is the code that i have used public partial class _Default : System.Web.UI. Page { DataSet CategoryDS = new DataSet (); protected void Page_Load( object sender, EventArgs e) { if (!Page.IsPostBack) { LoadDataSet(); BuildEmployeeList(EmployeeList.Nodes, 0); } } void SelectEmployee( object s, EventArgs e) { // do stuff }   void LoadDataSet() { String conn = ConfigurationSettings .AppSettings[ "connStr" ]; ...Show All

• .NET Development connection string to connect to a dataset?

  hi, how do i set up a connection string to get a dataadapter to read data from a data set into another datatable SqlConnection conn = new SqlConnection (); // ** connection string ** string selectQuery = "Select distinct ' " + tagValues[2] + " ' * from " + dSet[iDset] + "'" ; SqlDataAdapter f = new SqlDataAdapter (selectQuery,conn); dt[p] = new DataTable (); f.Fill(dt[p]); Thanks. the DataAdapter is only to execute queries on the database end and fill the dataset with the results returned. you create your SqlCommand to select records, with some condition and filtering for example, and those records are then filled into the d ...Show All

• SQL Server Hoy to Deploye VB.net Application Along With Database....Please Help.

  Hi Guys, I had a little Problem With My Application Deployment. I want To Make Setup For My Application(VB.NET) Such that When it begins To Install,The Database Of the Application Will Automaticallly Get Installed..... Even I have Generated Script For That But I dont Know How to Execute It With Installation File.I have made Complete Setup Of My Application Exept Database. Now,I want Few Code Lines To Execute My Database Script. So how can i Execute My Script Through Installation.. And Also If there is another Way To Accomplish This Please Suggest Me. All Suggestions Will be Accepted... Thanx In Advance.. WOuld C# code also be ok for you :-) HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• SQL Server Aggregation Issue

  I have a cube that I designed aggregation with 12% performance in MOLAP storage mode. However, when I ran query it read from partition not from aggregation. How can I change so that the query read from aggregation Thanks in advance, A. Imamuddin Hi Ashari 1. Ensure that you have designed hierarchies on your dimensions even though they seem to be unnecessary. I found that aggregations are created when these exist 2. I find that creating aggregations manually by editing the XMLA for the measure group works better. You do this by scripting the measure group in the SQL Server Man Studio and add/edit your aggregations. Let me know if this helps Thanks John ...Show All

• Visual C++ sending an email

  i want to send emails with a c++ program, but i am using an older version of c++ (msvc++ 6 introductory edition) and cannot use system.net.mail namespace (i dont think, if there is a way please tell me) because it is part of .net 2.0 so is there any other way of sending email You can download the VS 2005 express edition (C++ or C#) to do .NET programming. For specific questions on .NET please use the related .NET forums. ...Show All

• Visual C# New Project Wizard

  Hi all I’m very new to C# and I have to make a new project form(dialog) where I create some directories and set some paths variables. Later on it should be possible to add the functionality of specifying project type and go through some kind of wizard for the selected project type. My question is - do any have some links to some good tutorials/articles doing this - I guess there must me some component which offers this kind functionality, well I hope. Have tried searching but I get various wizards for doing something else. Thanks in advance, chris Examples are some of the best way to learn... Check out the 101 Samples for Visual Studio 2005 which is a robust, initial development tasks to ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. F14 XNA Game with Full Source

  Well here it is. I finally got my first game into a releasable state. Screenshot, video, and full source available after the jump. http://aroganworld.blogspot.com/2006/09/f14-xna-game.html I couldn't have done it without the great help from this forum (and all those xna sites). Let me know what you think. Fyi, I finally finished porting my F14 XNA game to run under XNA 1.0. F14 XNA v.61 (full source) ...Show All

• Visual C# How can I detect Enter on a textbox control?

  Hello, I have a textbox and a button on my form. I want to let the user enter anything in the textbox except when he hit enter I want to raise the button event. Can you please tell me how can I do that Hi You need to set the Form properties window AcceptButton to the button control that you have created so that when the user click Enter while the cursor is on the textbox it runs the button event. Hope this helps. ...Show All

• Visual C# stdole.IPictureDisp to Bitmap/icon conversion in C#

  I am having a 3rd part DLL which contains Icons. I have to use this DLL to get icons in C# application. That DLL returns the icon wrapped as an object of stdole.IPictureDisp. Now how to convert this to get the bitmap or icon. I am trying for image option but runtime exception comes as cant cast it. any Help. Hi, An icon is not an image. You need to use the correct class in the correct context. You cannot merely cast an Icon to an Image when they are not in the same object heirarchy. You will need to construct a new Bitmap with the Icon data to convert an icon to an image. (Bitmap does in fact inherit Image). You need to understand how the object heirarchy is laid out. You are abl ...Show All