GRK's Q&A profile

• Windows Forms Clicking

  Is it possible to pass through all clicks on a form's face to the applications below it For example, if there is a Form with a button on it, even If I click the button it passes through and clicks on this web page instead.. Yea, it would take a lot of coding, but it would make my app kind of "slick" if I could do that... It's not really necessary, but it would be nice ... I was thinking about capturing the click, minimizing the form and then performing the click and restoring the form, but doing that repeatedly would look even worse than not having it... ...Show All

• SQL Server Many to Many - Performance & Aggregations

  HI, I am interested in knowledge about Many to Many and possible sideaffects on aggregations and performance - any recomandations (links, helpfile, ...) I am about to model a big cube with 10 measuregroups and 8 of this measuregorups have an many to many related dimension (the immidiate fact table for the many to many dimension has about 500.000 Records per day for 2++ Years finaly) and I want to use this for a imidiate measuregroup (the many to many is in relationship with two dimensions) It is "article" published on a website per day - the website is the many to many dimension - because the article could be publised on this day on this 7 websites and on the next day on this 11 websites and we want to report how many article ...Show All

• SQL Server Precision and Scale in a calulated column

  How do I set Precision and Scale in a calulated column I'm trying to limit the decimal points returned in a calculated column but can't find where to set the scale. What am I missing please Thanks, Scott hi Scott, SET NOCOUNT ON; USE tempdb; GO CREATE TABLE #t ( d decimal(18,4) DEFAULT 1234.123, D2 AS CONVERT(decimal(8,2), d) ); GO INSERT INTO #t DEFAULT VALUES; SELECT * FROM #t; GO DROP TABLE #t; --<--------- d D2 ------------ -------- 1234.1230 1234.12 regards ...Show All

• SQL Server Troubles with speed of queries

  Hi, we are running MS SQL 2000 with several tables. One XY containing more than 100.000 records. After about 200 to 300 individual inserts into the table, database performance dramatically decreases. Queries like "SELECT ..FROM XY .. WHERE ..." takes about 2 minutes. Before these inserts (statistics were explicitly updated by UPDATE STATISTIC XY WITH FULLSCAN) performance is OK. Such select-query takes about 5 seconds. Database settings are: Auto update statistics - ON Auto create statistics - ON Does anybody knows what gets wrong Thanks for any tips. Jakub But if lack of right indexes was the problem then why longer execution time after just 200-300 inserts when table already has 100,000 rows ...Show All

• SQL Server SQL2005 Log shipping roll change where secondary is readonly standby

  Hi, I am trying to implement a log shipping scenario in sql 2005 where the secondary server is in standby mode with the ability to roll change during failover. With the help of BOL (ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/2d7cc40a-47e8-4419-9b2b-7c69f700e806.htm) I can implement my scenario in Recovery mode, but not in standby mode. I use the following sql to put my primary in standby BACKUP LOG [database] TO DISK = @filename WITH STANDBY = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\ROLLBACK_UNDO_database.BAK' GO which works, but then my restore job fails on the last step. How can I put my primary db in standby mode in such a way that the log shipping restore will work Thanks Andy ...Show All

• Visual Studio Team System Search results with VSTS.

  Hi, I have recorded a webtest which has search field to be tested. While recording, the particular string gave some results(say 10 matches). But on playback, I couldn't see the results. I can see the empty page like no actions performed. The situation is same when recorded on the Fiddler tool and imported via VSTS. Kindly suggest what needs to be taken care of. Thanks - Vijay. There is likely a dynamic id like a session if that needs to be extracted from a previous request. For example, assume the first time you hit a page in your app, there is a session id returned to the browser. Now each request after this will return this session id. When you play back the test, you would need to add an extracti ...Show All

• SQL Server How to copy database stucture online

  Hi! I have to add a new functionnality in our Web application but i have no idea how to do it. What i have to do is to allow user to create a copy of the BD currently use and to save it on a new name. What i need is only the structure not the data. I need to copy all table, view, function and stored proc. I have no idea where to start. I found on this forum post where it says to detach then copy and the attach the BD but i can't do to this because i don't want other users on our web application to lost the connection with the DB. So was is the best way to do this Thanks !! You can easily do that by using SMO. Loop through the objects you want to duplicate and create a script for them. Afterwards ...Show All

• SQL Server Problems with Roles and sp_helpRoleMember

  I have a database role named gc_stationAdmin. I have a user x who has this role granted him when via Mgmt Studio under Logins. In fact I have 50+ users who have this role. 1) when I execute sp_helpRoleMember I see only 20 users who have this role when I'm expecting to see 50 and user X is not amongst the 20 2) when sp_helpRoleMember is executed AS user X, they only see 1 user with this role (and it's not himself) 3) when I drop user X from Role using sp_dropRoleMember OR using Mgmt Studio under Login Properties, it never drops him according to Mgmt Studio. When I pull up the login properties, that role is still always checked no matter what I do...although he doesn't appear in the sp_helpRoleMember result ever. What is goi ...Show All

• Visual Studio 2008 (Pre-release) Hyperlink in a ToolTip

  When I put a Hyperlink inside a ToolTip, I can't click it. The hyperlink doesn't get any mouse events. Setting the ToolTip IsHitTestVisible to True doesn't seem to help. When I put a Hyperlink in a PopUp, the Hyperlink is clickable, but I'd need to make it look like a ToolTip and style it with a drop down shadow. Any ideas Kevin It is true that Focusable is false by default for ToolTip. Unfortunately, it doesn't seem to help setting Focusable to true and calling Focus() in the ToolTip.Opened event, Kevin ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. How do I load a 3d mesh (.x file)?

  How do I load a .x mesh into my scene The space game seems to use its own format (which it names .swm), and there's nothing in the help. I've been scanning through through the classes in the Framework namespace, but I can't see anything obvious! Is .x the recommended format for objects like this (If not, I change my question to be about the recommended format :D) If anyone knows anywhere that has some nice .x meshes I can play with, that'd be cool too. The only one I have lying around is a chair, and that's going to look a bit funny running around my game :D Zumwalt wrote: So basically what you are telling everyone is don't bother with the SDK at the moment because it is pre-alpha still an ...Show All

• Visual Studio Installation Error.

  Can't this company make software that just installs as it should Why am I getting the founding error when installing the trail version of Visual Studio Pro 2005 Error 1406. Could not write value to key \Software\Classes\.xsd\OpenWithList\devenv.exe. Verify that you have sufficient access to that key, or contact your support personnel. All other programs WERE closed and my anti-virus WAS disabled Mike Hi Ahmedilyas, >>which user account are you installing under I'm just trying to install the 90-day trail on DVD. >>Which OS are you running I have Windows Professional 2002 Service Pack 2 ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. LetterBoxing and/or splitscreening

  Hi all :), I was looking to 'embed' a 16:9 surface into a 4:3 window so that i can render in 16:9 on a 4:3 fullscreen display. Is there a straightforward way to do this in XNA Otherwise i was thinking of just Rendering to a Texture in 16:9 and sticking that to an appropriately sized sprite and rendering that within the original window. Obviously thats a roundabout way of doing it and has some overheads that i'd like to avoid, so its just not the most elegant solution. I was wondering if there was a better way of doing it Like is it at all possible to restrict the graphics device to a subregion of the original buffer That would be cleaner and would also be useful perhaps for splitscreening too. You shou ...Show All

• .NET Development Generic performance... benefit?

  Hi, in every article about generics is written that they improve performance because no boxing, etc. occurs. So I wrote this simple test code and was astonished that the non generic part actually performs a couple milliseconds faster than the generic part About 59.8 seconds for the generic and 59.1 seconds for the non generic (avg. of 10 runs). Am I missing something here [code] using System; using System.Collections.Generic; using System.Text; using System.Xml; using System.Collections; namespace ConsoleApplication6 { class Program { static void Main(string[] args) { string s = ""; Test<string> test = new Test<string>("hi"); DateTime start = DateTime.Now; for (int j = 0; j < 1000000; j++) { foreac ...Show All

• SQL Server Easiest and performance effective way to store blob into varchar column

  Hi, My package dumps the errors into a table. The problem is, it couldnt dump Error Output column to a varchar field. I have added an script component in between to transform to string but no success. I tried ErrorOutput.GetBlobData(0, ErrorOutput.Length) but when I query the database, it says "System.Byte[]' I will appreciate the responses to this post. Thankyou, Fahad So, what's the problem, exactly You can cast your column to an nvarchar without issue. Just use a derived column transformation (well, the only issue could be truncation). This would be your expression: (DT_WSTR,4000)[Flat File Error Column] But, more importantly why is it defined as NTEXT You must only have ONE column defined in your flat file source, or the ...Show All

• Smart Device Development Using VB program to open file on a CDMA device - PPC6700

  I'm trying to use the Shell command to run a .exe file on a mobile Pocket PC, but when I run/debug the program on the phone it keeps coming up with the FileNotFound error. I'm thinking it is the path that is wrong, but I can't find anywhere as to how to address the path on a mobile device.. i.e. Shell("c:\program files\calc.exe"). I have tried every combination i can think of, from My Device, to C: to just \... but nothing seems to work and I know I'm missing something. Any help would be appreciated. Well, thanks for the process start info, but it seems I'm back to my root (grin) problem. It gives me the File does not appear to exist in the location given .. I opened File explorer on the Pocket PC, when back ...Show All