I am writing a stored proc. Currently doing a "SELECT INTO" to copy data from one table to a new one. But eventually a. I want to do it most optimally as the data is gonna be huge b. Also it should be able to insert data in an existing table. What SQL stmt/function should I use? :doh: Salil Khedkar [^]
Salil Khedkar
Posts
-
Is SELECT INTO optimal to copy data? -
PerfMon: Where are my counters?The link had excellent info, thanks man. :rose: I tried out a few things and while I learnt a lot from the exercise, I could not solve the problem. As the time is short I will just go ahead and re-install XP. Salil Khedkar [^]
-
PerfMon: Where are my counters?No these were Windows performance counters (not specific to .NET) The CORPerfMonSymbols are all there. Anyways, thanks man. :rose: Salil Khedkar [^]
-
PerfMon: Where are my counters?Err, it is not a programming question. It is more like where does windows store this and this information. I am trying in the OS board too, but too little traffic there... :( Salil Khedkar [^]
-
PerfMon: Where are my counters?:rose: Salil Khedkar [^]
-
PerfMon: Where are my counters?If you visit ‘Add Counter’ window in (WinXP) perfmon and select the ‘Memory’ performance object, you see several counters in the list below. Available bytes, Cache bytes and so on. But for some reason my machine (WinXP) shows only one counter in this section. It happens to be ‘Available Mbytes’, only one entry. I have no idea where the others have gone. :( I need to restore the default counters for ‘Memory’ performance object because I am working on a project which reads values of some of the counters I mentioned above. The code always fails on machine throwing an exception ‘instance name xxx is not valid for this counter category’ Can somebody help regarding what I can do to restore default performance counters? :confused: Salil Khedkar [^]
-
PerfMon: Where are my counters?If you visit ‘Add Counter’ window in (WinXP) perfmon and select the ‘Memory’ performance object, you see several counters in the list below. Available bytes, Cache bytes and so on. But for some reason my machine (WinXP) shows only one counter in this section. It happens to be ‘Available Mbytes’, only one entry. I have no idea where the others have gone. :( I need to restore the default counters for ‘Memory’ performance object because I am working on a project which reads values of some of the counters I mentioned above. The code always fails on machine throwing an exception ‘instance name xxx is not valid for this counter category’ Can somebody help regarding what I can do to restore default performance counters? :confused: Salil Khedkar [^]
-
PerfMon: Where are my counters?If you visit ‘Add Counter’ window in (WinXP) perfmon and select the ‘Memory’ performance object, you see several counters in the list below. Available bytes, Cache bytes and so on. But for some reason my machine (WinXP) shows only one counter in this section. It happens to be ‘Available Mbytes’, only one entry. I have no idea where the others have gone. :( I need to restore the default counters for ‘Memory’ performance object because I am working on a project which reads values of some of the counters I mentioned above. The code always fails on machine throwing an exception ‘instance name xxx is not valid for this counter category’ Can somebody help regarding what I can do to restore default performance counters? :confused: Salil Khedkar [^]
-
Duh, customizing Microsoft Outlook 2003 address book display!Got it. The facility is only available on the Contacts screen and not in Address Book > Contacts. I can do the customizations there. Thanks man. :rose: Salil Khedkar [^]
-
Duh, customizing Microsoft Outlook 2003 address book display!Found it. The facility is only available on the Contacts screen and not in Address Book > Contacts. I can do the customizations there. Thanks man. Salil Khedkar [^]
-
Duh, customizing Microsoft Outlook 2003 address book display!Found it. The facility is only available on the Contacts screen and not in Address Book > Contacts. I can do the customizations there. Thanks a lot. :rose: Salil Khedkar [^]
-
Duh, customizing Microsoft Outlook 2003 address book display!You said it! The facility is only available on the Contacts screen and not in Address Book > Contacts. Thanks man. Salil Khedkar [^]
-
Duh, customizing Microsoft Outlook 2003 address book display!Thanks Francisco. Yes, that is what I want to do. But the right-click menu you described is apparently only available in Outlook Express. I can’t see that functionality in Microsoft Outlook 2003. :( Salil Khedkar [^]
-
Duh, customizing Microsoft Outlook 2003 address book display!Alright alright, Nishant and Vikram, I will be careful not to allow my 'SMS-speak' to creep in here... :) Now let's wait for an good soul to answer my question... :-D Salil Khedkar [^]
-
Duh, customizing Microsoft Outlook 2003 address book display!Err, sorry for a boring post in our enthu filled lounge... But I am bugged with this one... ;) I use Microsoft Outlook 2003 and I want to display some additional columns in Address Book > Contacts. Say Company name and phone number. How can I do this? The ‘Global Address Book’ displays all the columns I want by default, but ‘Contacts’ shows only name and email. Where is that nifty setting hidden to customize the AB display? Salil Khedkar [^]
-
Good tools to find dead C# code...I want to clean up my projects C# source code by removing things (unused functions, variables, parameters etc) which are no longer being used. ;) I could find a tool for VB [^] but not for C# yet. Can anybody recommend me a good one?
-
Making an enterprise app database independent...Hmmm... Thanks for the info... O/R mapper seems to be the keyword for this subject. I will read more... Salil Khedkar [^]
-
Making an enterprise app database independent...Hmmm... Thanks for the info man... Yup I am starting the study phase... :) Salil Khedkar [^]
-
SQLXML component lets XML bulk loading... What about Oracle?SQLXML component from microsoft can convert XML data into relational data and load it into an existing SQL Server 2000 database tables. Is such facility available for Oracle database too? Can someone give me links? Salil Khedkar [^]
-
Making an enterprise app database independent...Any pointers, suggestions, links, hints on making an enterprise app database independent... Thanks… Salil Khedkar [^]