Are your statistics up to date? You can check using sys.stats and STATS_DATE:

SELECT

T.[name] AS table_name,

I.[object_id],

I.[name] AS index_name,

I.index_id,

I.type_desc,

I.fill_factor,

S.[name] AS stats_name,

S.stats_id,

S.auto_created,

S.user_created,

S.no_recompute,

STATS_DATE(S.[object_id], stats_id) AS STATS_DATE

FROM

...

Hey Steve, check out this guys posts (http://www.sqlservercentral.com/Forums/Search1-0-2.aspx?SessionID=euwat2555c1qqdnch3bhfpq1&SortBy=2&SortOrder=1) both have turorials as Word docs attached. I didn't read the docs, but did suggest they submit them as articles....

Forget about RPG on the iSeries (new name for AS400), someone wrote an RPG.NET at least back for .NET 1.1.

I never had the "joy" of programming in RPG although one...

Why not submit this to SSC as an article? The forums are usually used for questions.

Why not submit this to SSC as an article? The forums are usually used for questions.

That's a pretty common dilemma when you have several applications sharing data. I've always like separate DB's per application. Storage is fairly cheap so I have synced common...

Check out this blog post[/url] by Gail Shaw (GilaMonster here on SSC).

Can you post your script component code?

I'd recommend using a Data Conversion transformation to change your string data to DT_TEXT or DT_NTEXT.

It depends. Are you talking about for a source or for an Execute SQL Task within the package? It also depends on the work you are trying to...

First you need to have SQL Mail set up or, I prefer, xp_smtpsendmail (open the link in IE, it doesn't like Firefox or Chrome).

Second, is this only when a new...

I don't know if you can change it in Excel or Access, but you need to be careful with APP_NAME() as you can change it in your connection string.

Data Source=SqlServer;Initial...

No reorganizing/rebuilding a clustered index does not reorganize or rebuild the non-clustered.

http://technet.microsoft.com/en-us/library/ms189858(SQL.90).aspx

http://www.ford-it.com/sqlagentman/?p=206

Yes if it is a non-numeric field in at a group level that is not included in the grouping. If you put a numeric field there then SSRS uses...

Guess everyone knew Gail was gone. Not many posts in the corruption forums.

Note, the last sentence of my last post:

If the datatype of the bit column is bool you may have to do a conversion to string first in order to compare...