I am not sure I can get the actual SQL, since I do not have access to SQL Profiler, but I am trying to work with IT to get that. ...

I have heard of passing to an internal parameter, but this is not using a stored procedure.  It is just straight SQL from RS dataset.  And I have changed the...

I guess that is a solution, but not as elegant as I was hoping.  But I had not thought of that.

Is there some code that I can add,...

As mentioned here there are indexes shown in the results. Would it make sense if I were to group by the "Name" and do a SUM(reserved_page_count * 8) as...

Fiddlesticks! I have confirmed that the join elimination does in fact work with a view, using the AdventureWorksDW2008 database. Unfortunately, the foreign key constraints look exactly the same...

When I check the objectproperty(object_id,'CnstIsNotTrusted'), I get a value of zero, which I presume means the constraint is trusted. I even ran the "CHECK check" alter statement and saw...

Thanks for the prompt reply. However, I am not sure that is the problem. When I look at the properties of the constraint, it says it is trusted....

The gauntlet was thrown and now you own it. 🙂 Very impressive answer. I had only heard about recursive calls to the same report, but this is...

The SQL mentioned in this post many years ago refers to a way to compare the DATA in two different tables. It would tell you that Field7 has changed...

I am not sure I understand. Can you give simple example of what tables you have and what you want?

Thanks. It is a few more clicks and not as simple, but the workaround does give the ability to enlarge the font.

I tried the DataSet Designer options, but none...

There are about 20 settings to choose from and I cannot find one that changes the text in the query design pane. I have changed the options I think...

and then where? I am hopeful there is an option in there, but I do not see it.

I have not attacked a listing of all the database fields used, but my theory on that is that I could get the CommandText, as you outline above, and then...

Here is the SQL I use to get the Table details, along with the corresponding header. This uses a table of numbers, called Tally, to look at specific positions...