Grant,

Unfortunately, "ChargeType" is actually my name for a bunch of columns added together in this particular table to list a charge. The tables (dbo.Jan10, dbo.Feb10, etc) are wide tables,...

Grant,

I agree with the previous statement (RIGHT(RTRIM(InvoiceNumber),12) is a performance issue)... the VIEW_InvoiceData table was never intended to be queried against. Unfortunately, the original architect (2007) did not do...

Ok... included are the scrubbed query plans (removing as much confidential information as possible). The query in the actual execution plans is a bit more involved than the example given...

I use to have to calculate ROI(s) for a lot of IT projects (and previous to that, Engineering projects).... it is not an easy task.

As stated before, what is...

Just to make sure I understood the Intersect/Except operators, I tried a variation of the examples from BOL. I put debug(s) around it all just to run various tests without...

I found a bug listing on Microsoft Connect (ID 515132) similar to the issue I was experiencing. I put my comments in the bug and voted on it. Anyone experiencing...

No updates. When the problem first occurred there were no postings on the subject related to SQL Server 2008... I am beginning to see some now, but no answers on...

This is an older post (I was researching a similar issue). Check the following URL:

http://www.sqlservercentral.com/blogs/sql_performance/archive/2010/2/5/microsoft-sql-server-2005-cpu-scheduler-id-is-not-synchronized-with-other-cpus.aspx

Ok... found a temporary solution to the problem, but still not understanding why it is happening.... played with firewall settings (Windows Server 2008 has multiple firewalls).

Used the ipaddress,port (for...

Just to see what would happen, I did try and use a remote desktop connection to the server and it worked fine! Dealing with a few other issues now too......

I am just completing a migration from SQL 2005/Win2003 to SQL 2008/Win2008. Here are some links to review:

1) Review this forum entry: http://www.sqlservercentral.com/Forums/Topic843135-1550-1.aspx

2) Here is a good article on...

Charles,

Thanks for the update. I was just getting ready to post this myself... I just figured that technique out this week when I had some 250-row csv files I...

Unfortunately no, never found a solution for this. I did have to manually add each column name (and datatype) to the flat file connector.

One word of caution (just found...

Here is a bit more of an update....

First, you can get errors in SSIS that would not fail in SQL Server (in this case, when Ignore_dups is set on)........

Not that I am trying to take over someone's elses post, but here was the example query I was using:

SELECT CONVERT(varchar,Invoicedate,101) as PostedDate ----- Group by date as there...