vipix's Q&A profile

• SQL Server MCTS Exam 70-431 Database Administration Study Documementation and Samples ?

  Hi, I am looking for good documentation and examples to use to 'study' for Microsoft exam 70-431. This has everything to do with nuts-and-bolts Database Administration of SQL Server 2005. The December BOL examples, do not cover enough topics. The topics that are covered are not in enough detail. The 70-431 exam requirements are very detailed. This seems to be a nuts-and-bolts test. I am looking for nuts-and-bolts study material. No books are published yet. Does anyone have any good ideas on where to find 'good' samples and tutorials meant for a person who is studying for the new Microsoft SQL Server 2005 Database Administrator Exam MCTS 70-431 All answers and ideas in 'any form' are appreciated. Thank you very much. ...Show All

• SQL Server How can i cluster sql 2005 for load balancing?

  i have a table with 10,000,000,000 records and i need Select and Insert many records from or into this table in less than one second. i can't buy a very expensive hardware(Server) for this SQL Server 2005 but i can buy many medium price hardwares(Servers) for this SQL Server 2005. how can i distribute or cluster this table between many hardwares(Servers) note: i have few users (maximum 5 users) for my database but i have a very large table and Sql server 2005 server need to respond to this users in less than 1 second. i want to distribute this huge table in seperated hardwares. becuase i can't buy a very expensive hardware from my server but i can buy many medium price hardware for my server. note: i need this: when a user ru ...Show All

• Windows Forms Executing another setup through my application setup

  Dear all I have my application that has some depandencies that need to be installed before my application gets intalled on computer. So how can I install these thired party tools before my application gets installed on the computer. How can we do this through customs actions. Regards You often can't do this with custom actions because they might be MSI setups, and you can't run two simultaneous MSI setups (yours and the one fired up from your custom action). A common solotion is to write a launcher program that installs those others then yours, or whatever the order needs to be. ...Show All

• Visual Studio Team System Strange Problem --- SQL Server 2005 and TFS and Team System

  We are implementing TFS and have imported legacy work items from Excel spreadsheets. I want to connect two groups of these workitems as related work items by going into the dbo.LocalRelatedEdges table in the TFSWorkItemTracking database. I wrote a vb .net routine which inserts into this table the related ID's which should then show a related work item under the links tab of the Team System GUI. I used ADO.net (sqlclient.sqldataadapter) to accomplish this. The insert works correctly and the row is populated correctly in the table, but the related work item does not appear in the Team System GUI. But, if I manually go into the SQL database using Microsoft SQL Server Manag ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Can SOMEONE PLEASE HELP ME? I need help learning XNA-C#

  Can somone help me PLEASE I need some help learning how to make games and that type of stuff using the C# XNA program. If anyone can help me, let me know. I would like a site that can lead me threw one step at a time and is easy to understand if posible. Thank you =) -Ryan It means you did something wrong - what code are you using Does the space war sample work Does the empty project run If so then try the tutorials from the help file. Then compare them to your program. ...Show All

• Visual C++ C2955 Error in Visual Studio 2005 V8 - No Errors in Visual Studio 7

  Any idea why the below stand-alone code has compile errors in 8 but not in 7 Yes, it's strange code pushing the envelope. Never-the-less why does 8 not compile it ------------------------------CUT----------------------------------------------- #pragma once #include <iostream> #include <tchar.h> typedef int TMember; template<typename _Member> class Data { public: typedef _Member _Mbr; int padding; _Member member; }; template<typename _TMember, _TMember *_memberP> class Access { public: _TMember *memberP; Access() { memberP = _memberP; } ~Access() { } }; template<class _Data> class Test : public Access<_Data::_Mbr,&((_Data*)0)->member> { public: }; int _tmain(int argc, ...Show All

• Visual C++ Millisecond timer in C++

  Does anyone know of any timer function/class in C++ I can use that measures elapsed time (let's say before and after a function call) in milliseconds I seen some custom implementations on the Net (such as CDuration class) but that requires incorporation of custom classes written by someone else. Any other idea Thanks in advance. The easiest is the GetTickCount function. There is no precision in this because of multitasking and stuff, but it is simple to use and will give you a general idea for time elapsed. http://msdn.microsoft.com/library/default.asp url=/library/en-us/sysinfo/base/gettickcount.asp A good example is this. DWORD tstart, tend, tdif; tstart = GetTickCount(); sumf ...Show All

• Visual Studio Team System Items cannot be placed under source control.

  I have just loaded TFS Workgroup Edition on a server, and have added an existing Visual Basic 2005 solution to the TFS Source control. I tried to add it from my main development system first but everything to do with Source contol was greyed out. Then I added it from the TFS server. After that I found a post online explaining that I had to set my visual studio setting to use TF as my source control. Now when ever I open the solution I get sever errors/warnings: Source Control You attempted to add some items to a source-controlled project, and the items reside on a drive that is different from the drive where the project resides. These items cannot be placed under source control. (This appears about 18 times) Is there any way ...Show All

• .NET Development Multicasting Udp Sockets

  HI, Am working on lan messaging concept.i implemented multicasting udp sockets to register all users in a lan as a group and communicate between them.Now am struck up with the following issue. If user1(say kvbk) logs in he joins the multicastgroup and sends a message to the entire multicasting group that he is online(or just logged in).If no other users are logged in at that time then message is lost. If user2(say kumar) logs in he joins the multicastgroup and sends a message to the entire multicasting group that he is online(or just logged in).Then user1 receives the message and updates in his contacts.Now the problem is how the user1 updates that he is also online to the users who log after he logs in. i think there are two o ...Show All

• Visual Studio 2008 (Pre-release) WCF and N-Tier Web applications

  Hello, I would like to know how would WCF add value in a typical n-tier web application, where the presentation layer talks to the business logic layer in-proc for performance purposes. i.e. there's no physical seperation between all layers and hence the UI layer has access to the db server. Please note that web services are not always necessary as an additional layer as the main purpose of web services is to expose the application functionality to other consuming applications, and so decisions to make the contract coarse-grained is not valid since no network overhead is incurred. Please advice. Thank you, Well, you will need to create another layer of abstraction to abstract the will-be WCF l ...Show All

• SQL Server Ordering date ?

  SELECT LEFT(CONVERT(CHAR(11),convert(datetime,task_date),109),3) + ' ' + RIGHT(CONVERT(CHAR(11),convert(datetime,task_date),109),4) as Date, SUM(CASE a.status_id WHEN 1000 THEN b.act_point ELSE 0 END) as Programming, SUM(CASE a.status_id WHEN 1016 THEN b.act_point ELSE 0 END) as Design, SUM(CASE a.status_id WHEN 1752 THEN b.act_point ELSE 0 END) as Upload, SUM(CASE a.status_id WHEN 1032 THEN b.act_point ELSE 0 END) as Testing, SUM(CASE a.status_id WHEN 1128 THEN b.act_point ELSE 0 END) as Meeting, SUM(CASE a.status_id WHEN 1172 THEN b.act_point ELSE 0 END) as Others From task_table a,act_table b where a.status_id=b.act_id and a.user_id=(select user_id from user_table where user_name='Raghu') and a.task_date like '%/%/2006' GROUP BY LEFT(CO ...Show All

• Visual Studio 2008 (Pre-release) sending 30 MB from a WCF server to many clients

  I need to create a solution for this scenario: A lot of clients all over the world (winforms) should play media files that a server sends them. The server has a playlist of media files for each of those client. Whenever a playlist is changed on the server the client should 'know' about it and download the media files. the size of the files could be around 30 MB. Should I use WCF to send the files to the client or should I use FTP instead What is the diference between WCF and FTP in terms of speed , security and scalability >>What is the diference between WCF and FTP in terms of speed , security and scalability Speed - FTP probably is going to give you better perfomance. However, you can try Net ...Show All

• Visual Studio Formatting QuickInfo tooltips

  Is there any way of formatting an IntelliSense QuickInfo tooltip I'd like to be able to add bold, italic, etc. to the tip - but there doesn't seem to be any way of doing this. I'm currently just returning some text via the GetDataTipText method in my AuthoringScope object. Any ideas anyone Other than setting the foreground and background colours via the "Editor Tooltip" page in tools options there isn't much you can do here. You can also use the IVsFontAndColorStorage interface from the SID_SVsFontAndColorStorage service to get and set colours too. Use OpenCategory, make any changes you want by calling SetItem, SetFont etc., then call CloseCategory. Look in HKLM\SOFTWARE\Microsoft\VisualStudio ...Show All

• Visual Studio Team System Dealing with tiny C drive

  I have a server with 1 Terabyte of Disk space, 11 GB of which is allocated (7.5 GB currently available) to the C Drive. I need to install SQL 2005 and all goodies plus Team Foundation Server and other software "without filling up the c drive". I have never been successful with a configuration like this as a lot of space on C is taken regardless of the selected install locations. 1. Is allocating disk space with this little left for C a standard practice for a general use server 2. Is there a white paper somewhere that indicates how much space is required to be free on the OS drive for Team Foundation Server and SQL Server 2005 I have looked at the installation requirements and have only found general disk space requireme ...Show All

• Windows Forms Two Connected DataGrids

  I have two datagrids that show Schools, Student .. depending on selected school from dg_School , dg_Student will display the student that already in this School, each datagrid is has it's own sort Expression And Sorting Command , but if I choose a School, let's say School2 , and make as sort for Student datagrid , dg_Student then back To the first record in dg_School (let's say School1 )and views it's own Student ..!! I want to keep a record to seslcted Item in dg_School to view it's Students even though a sorting operaton has performed .. Regards ...Show All