Mr WordPress on Hello world!
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
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
As I don’t like to reference blogs…they have a tendancy to disappear…so This post (hopefully!) contains everything you need to know. Over the past few weeks, we ran a pilot of this feature and collected lots of great data … Continue reading