I don't think the data is the issue.

And I dont like the idea of flushing the data out. It "might" solve this issue, but it doesn't help in identifying the...

Hello vinuraj,

these are system tables.

If you enable logging of DTS packages to SQL Server,

the logs will be stored in these two tables.

The table does grow, but this specific data set...

Hi Peter,

Could you please elaborate a little more on what you are trying to show me?

I cannot use a collation for the datetime column that I want to sort.

I have...

If I understand this issue correctly, I strongly suggest you simply create views.

With a view on the table you can translate the column names AND translate the codes in one...

I just do not understand how this should result in one row.

Table A

Row1: ColA = 1

Row2: ColA = 2

Table B

Row1: ColB = 1

Row2: ColB = 2

Row3: ColB = 3

SELECT...

Can someone please explain this question to me?

Are we talking about tables with each one having only 1 row?

Hi Andy,

thanks for this nice article.

Just as additional information, a link to BOL which explains when views are updatable and when not.

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/aecc2f73-2ab5-4db9-b1e6-2f9e3c601fb9.htm

The correct answer is RANK.

Read the explanation carefully;-)

Or use a CTE as described here:

http://www.sqlservercentral.com/Forums/Topic412364-145-1.aspx#bm412471

If you are crossing DBs just within the server, you might also want to think about using different schemas instead of different DBs. You can then split the data accross...

I think Manoj wants a constant. Not a parameter.

Is this something for you?

CREATE VIEW dbo.MyView AS

WITH MyCTE AS (

SELECT CAST('20070101' AS datetime) DateConstant

...

Btw: OPTION (FORCE ORDER) would give you a plan that evaluates the CTE first, but that also affects the plan for the query inside the CTE I assume. So this...

Actually I think it is clear for me now.

As mentioned before it is the task of the query optimizer to play around with the order of execution based on...