Perhaps you may want to run Profiler and capture the SQL it is generating to see.  You should be able to filter in Profiler by something (workstation? application? database? to...

Must be a slow day for DBA's.  All backups have run successfully and no server errors.

You are not filling in the needed single quotes around the parameters, like:

...RMPM_groupItems.itemType = ''' + @paramCON + ''' UNION ALL SELECT ...

I don't think there is a limit on the IN clause, but might you be hitting the 8000 char limit on SQL statement?

Why not just eliminate the temporary table, and export from a query?

Private Sub exportExcelButton_Click()

Dim selectSQL As String
selectSQL = "SELECT "
Dim tempString As String
For Index = 0 To Me.ExportList.ListCount - 1
   ...

I haven't tested, but I would suspect that using this WHERE clause should be faster:

WHERE DateDiff(day, GetDate(), sDate) =1

A simple example would be:

UPDATE MyTable
SET FldA=t2.FldA, FldB = t2.FldB
FROM MyTable t1 INNER JOIN WorkTable t2 on t1.PKey = t2.PKey
GO 

INSERT MyTable (PKey, FldA, FldB)
SELECT t2.PKey, t2.FldA, t2.FldB
FROM WorkTable t2...

An (faster, more efficient) alternative is to import the text file into a working table, then use an update query with an inner join to update records that match, and...

Steve;

Why would guids by themselves cause page splits?  I can see that if the table is physically ordered by the guid column, and you basically have random insert order.  But...

Stephen;

I believe we are saying the same thing.  The clustered index should not be the guid column / primary key.  I suspect that the author did have that for his...

I have to disagree with the answer on the question, and the reference article.  The given problem with using Guids (increased number of page splits) is occurs only if the...

How about this MSKB article?

HOW TO: Copy a Picture from a Database Directly to a PictureBox Control with Visual Basic .NET

You probably do not want "...ServerGroups.Item(1).RegisteredServers...", since you do not know that "TAMPA" will be the first item in the collection.  You can use the string value to reference the...

First, I assume since you said "MemoryStream" you are talking .Net.  Yes, you can get a dataset in ADO.Net to get an image datatype and load it into a MemoryStream.

But...

How are you loading the data into your tables?  You probably should be using BCP utility or Bulk Insert. 

Additional bulk insert performance enhancements are:

• set the batch sizes small to...