Rajiv Kapadia's Q&A profile

• SQL Server What are the best practices for a time dimension?

  Data is timestamped. Using smalldatetime provides minute resolution. However, different reports may need 5 minute, 10 minute, 1 hour, daily, weekly, or monthly aggregates. How should this be structured Thanks, David You may also want to check the following articles: Getting Time right in Analysis Services - by Tom Chester for SQL Junkies Web site http://www.sqljunkies.com/Article/D1E44392-592C-40DB-B80D-F20D60951395.scuk About Time - by Brian Altmann http://www.geocities.com/brianaltmann/olaptopic-time.html ==============================­==================== Mosha Pasumansky  - http://www.mo ...Show All

• Windows Forms TreeView - ContextMenu

  Hi, I have a TreeView with its ContextMenu properties assigned to a ContextMenu. When I right click on one of the TreeView node, the ContextMenu appears. Retrieving the TreeView's SelectedNode properties returned the node before I right clicked on one of the node. How do I retrieve the node that is right clicked and causes the ContectMenu to appear. Thanks Wh ...Show All

• Visual Studio Team System Applying Labels to Repository Root?

  What was the problem with applying labels to the root of the repository   Does that problem still exist in TF Beta 3        Unfortunately, that doesn't ring bell. I don't see many posts on label and scope keywords either. Feel free to ping us if you find it behaving unexpected. ...Show All

• SQL Server Maintenance plans: online rebuilding of indexes...

  I'm using SQL Server 2005 SP1 Standard. On the Rebuild Index Task there is a checkbox at the bottom that says 'Keep index online while reindexing'. Great I thought, I'll check that. Later, when I tested the job, I got this error: 'Online index operations can only be performed in Enterprise edition of SQL Server.' Why have that checkbox available to check, if I'm running a version that doesn't allow it Where's the bug Thanks Ed ...Show All

• SQL Server fix missing value

  Can SSIS detect the missing value and replace it with some reasonable value (e.g., maximum, median, average, etc.) thanks   Yanbing Hu wrote: Thanks. But if there is a way that SQL Server can automatically figure out a reasonable value used to fill in the missing value I mean I do not need to specify a value to replace the missing value, but SQL Server will figure out one Thanks Well surely that depends on your criteria for deciding what the missing value is. Can you give an example -Jamie ...Show All

• Visual Basic How can I override the "always on top" property of the Windows taskbar?

  I'm writing a windows application in VB.net that I would like to give to other users.  I've discovered that the Maximized appearance at runtime of my startup form is partially obscured at the bottom by the Windows taskbar if the user has set the property (via Control Panel) of the Windows taskbar to be "always on top" of other programs. I need the full client area of my start-up form to display various pieces of information, and an always-on-top Windows taskbar obscures some of that info.  Is there a way, programatically, that I could turn off the always-on-top property of the Windows taskbar for the duration of my applic ...Show All

• SQL Server Migrating from sql2000 MSDE database to sql2005 express - attach database errors

  I have a medical records system, SoapWare v4.90, that uses MSDE (SQL2000) databases. Due to the 2gb limitation, I am trying to migrate over to SQL 2005 (Standard or Express) which I have heard works fine. The SoapWare has a datamanager that allows me to log in to the MSDE instance, detach the SoapWare databases from msde (as well as do backups, etc) which I can confirm are detached. Then I log back into a SQL2005 database instance using the datamanager and try to attach the database. This is what their pictured instructions demonstrate. However, I get the following error: Database 'sw_charts' cannot be upgraded because it is read-only or h ...Show All

• Visual C++ Error "The filename or extension is too long" not displayed on Japanese OS

  Hello, I would appreciate your response on the following: I am using the following format of CreateDirectory() to create a new directory by passing the path(ie, path+filename), the second parameter is NULL, BOOL CreateDirectory( LPCTSTR lpPathName , LPSECURITY_ATTRIBUTES lpSecurityAttributes ); This method returns an error and displays error message "The filename or extension is too long" (error 206) as expected when the path exceeds 248 chars on English OS, however on Japanese OS machine, it does not display the error message. On English OS, when I copy and paste the pathname which exceeds 248 c ...Show All

• Visual Studio Inherit From Base Report

  I am using Crystal Reports that comes with Visual Studio.net 2003 and I would like to know if there is a way to create a base report and have my other reports inherit from that base report. Hello, My first answer would be no, but it really depends on what you are trying to do.  For the programming definition of inheritance it is definitely no. However, at design time you can take add an existing report a number of times and make modifications to them. At runtime, the modification is very limited with Crystal Reports for Visual Studio .NET.  We do have other products that allow for more runtime c ...Show All

• Visual Studio 2008 (Pre-release) AsyncCallback threw an exception

  I have created WIndows Service & deployed it on Win 2003 Server. This service just has Add/Multiply function. My WCF client is noramal WEB App. which is consumming this service the Service returns me the Result but after proxy.End MethodName ( IAsyncReslt ) gets executed it gives me the Error saying AsyncCallback threw an exception. Can anyone please help me on the same. Following is my Web Page Code. public partial class _Default : System.Web.UI. Page { NTServiceProxy p; protected void Button1_Click( object sender, EventArgs e) { PageAsyncTask task = new PageAsyncTask (BeginInvoke, EndInvoke, EndT ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Pivot/center point in x.file

  I'm a total newbie, so appoligize if this is a stupid question. How can I set the pivot point of my 3d model (x.file). I'm loading a car model and the pivot point is set to the left side of the car. I want the pivot point to be at the center of the car for easier formulas for moving/rotating the car. How can I do this If I approaches this the wrong way pleas tell me. You can use this function: D3DXComputeBoundingSphere( (D3DXVECTOR3*)pData, numVertices, fvfSize, &center, &m_boundingRadius ); It will tell you the center of your mesh and it will tell you the radius of the smallest sphere aro ...Show All

• Windows Forms datagridview: binding textboxes

  Hi all, i've just another little trouble: I have a form with some textbox, and a datagridview which is populated by some data retrieved on a sql database. i would like to know, how can i select a row, and populate the textboxes whith the data on selected row. Thank you in advance. Just solved, and i hope in "right way": void datagridCellDoubleClick(object sender, Eventargs e) { //connection code mySqlParameter.Value = datagrid.CurrentCell.Value.ToString() //binding code } ...Show All

• Windows Forms WSE 2 and PasswordOption.SendNone

  Hi Guys, I am new to WSE2 and was trying to implement an authencation using a customer authentication manager. There are three options to send password.  PasswordOption.SendPlainText PasswordOption.SendHashed PasswordOption.SendNone Now I first use plaintext and hashsed and they both work fine with my custom AuthenticateToken(UsernameToken token). Now when I set it to SendNone, it still works fine.&nb ...Show All

• Visual Studio Express Editions Writing to Access DB

  Hi all, I need to write into an access database. I use a variable con as an connection object, da for data adapter, ds for data set and followed the code closely from my reference book. However, when the instruction da.Update(ds, "Pixel" ) is invoked, an error occur. The error msg reads "OleDbException was unhandled". What does it mean I'm at this for hours... Please help. A segment of my code is below: ------------------------------------------------------------ Dim con As New OleDb.OleDbConnection 'the variable con will now hold the Connection Object. con.ConnectionString = " ...Show All

• SQL Server Change incorrect value in a single field

  I've written a VB.NET program that reads a comma delimited text file into an SQL Server table. I have more than two hundred such files with literally hundreds of thousands of rows of data. Unfortunately, the existing time data is in the wrong format (e.g. 0350 instead of 03:50). I haven't used TSQL in a while but I am almost sure it can do that. I imagine I would have to read each records IncorrectTime field's value, assign the two left characters in temp1 variable, assign the two right characters in temp2 variable, and then assign to temp3 = temp1 & ":" & temp2. Or something along those lines. Can anyone off ...Show All