Author Archives: wsfaso

Hello world!

Welcome to WordPress.com. This is your first post. Edit or delete it and start blogging!

Posted in Uncategorized | 1 Comment

Parallel Processing

Parallel Processing By Satish More, 2009/10/12 Total article views: 3454 | Views in the last 30 days: 3454  Rate this |   Join the discussion |  Briefcase |   Print Introduction Imagine you’ve got at hand a huge task. You’d … Continue reading

Posted in Computers and Internet | Leave a comment

Copy Row from one DataGridView to another

First, copy the schema of the table you want to copy, to the new table Dim dtTable As DataTable Dim dtTableNew As DataTable Dim oDataRow As DataRow   dtTable = Me.dgPayPalPayments.DataSource dtTableNew = dtTable.Clone dtTableNew.Clear() oDataRow = dtTable.Rows( Me.dgPayPalPayments.CurrentRow.Index) dtTableNew.ImportRow(oDataRow) … Continue reading

Posted in Computers and Internet | Leave a comment

Finding Duplicates with SQL

Here’s a handy query for finding duplicates in a table. Suppose you want to find all email addresses in a table that exist more than once: SELECT email, COUNT(email) AS NumOccurrencesFROM usersGROUP BY emailHAVING ( COUNT(email) > 1 ) You … Continue reading

Posted in Computers and Internet | Leave a comment

Increase Available RAM memory Access in Visual Studio 2008

The problem is with Visual Studio. Being a 32-bit application its limited to just 2GB of virtual memory, even if its running in a 64-bit OS. At least, its limited to 2GB by default… but we can hack around change … Continue reading

Posted in Computers and Internet | Leave a comment

SQL How to search all columns of all tables in a database for a keyword?

How to search all columns of all tables in a database for a keyword?excerpt from http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm While browsing the SQL Server newsgroups, every once in a while, I see a request for a script that can search all the columns … Continue reading

Posted in Computers and Internet | Leave a comment

vb c# nullable types by Muhammad Mosa

Introduction: Have you ever needed to add a null value to your integer, date & time,decimal or Boolean etc… data types?! I’m sure you may faced this desire before and you had to work around it to submit null value … Continue reading

Posted in Computers and Internet | Leave a comment