For SQL Server 2005, you can use the following query:

SELECT t.name AS table_name, i.name AS index_name, SUM(ps.row_count)

FROM sys.tables t

INNER JOIN sys.indexes i ON t.object_id...

Honestly, from my experience, a 100 row table won't be a major factor in performance. If it's never expected to grow to more than 100 rows, it should be...

I have to agree with AndyD that most of the spam I get is boring stuff, like hot stock tips or Canadian pharmacy drugs. Of course I have a...

The thing I'm struggling with on this one is that in my mind both CHAR and NCHAR are fixed width datatypes, so it seems to me that both should have...

Why did they have to make the answer really be a response to 2 separate questions? UNION ALL is not a workarround for a column defined as TEXT datatype....

Actually, even better, use the SCOPE_IDENTITY() function, it will only reference the last identity value created within your stored procedure in the current session.

@@Identity is current session but any scope

IDENT_CURRENT()...

Actually ALZDBA has the more correct answer, since the original post wanted the client side version, not the server side version. If your laptop has Management Studio, an easy...

is it possible for you to use SQL Profiler? It can capture the actual values of the parameters that are getting passed to your stored procedure in an EXEC...

do you do any math on the AnnualizedReturn value after it is calculated here? If not you can just CAST this entire CASE expression as VARCHAR. If you...

yes, if I'm understanding you right. To be more specific:

select

from (select top 1 column1, column2, column3, column4

...

I haven't done any trials on this scenario, but my initial thoughts would be that TOP1 in this case would have ever so slightly negative or no effect on performance,...

If you need to join the results of this query to something else, it may be easiest to set it up as a derived table (a subquery in your...

Wayne (10/27/2008)

---

There are also views and udf's that need to access data in the QAI database. These all reside on the DEV database.

We need to implement this solution without any...

could you take a different approach and do something like this:

select TOP 1 column list

from tablename

order by datecolumn DESC, timecolumn DESC

I suppose it depends on how this query is being...

richard (10/30/2008)

---

There is then the option to order the Query in Access....I've not done that.

I have however added an order on the form which displays the results of the query...