Mr WordPress on Hello world!
Author Archives: wsfaso
Welcome to WordPress.com. This is your first post. Edit or delete it and start blogging! Advertisements
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
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
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
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
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