Yes, that could be an advantage of having GUID columns as primary and foreign keys on a database.

Never thought of that.

One other advantage of GUIDs could be when you need...

Thanks for all your inputs.

I agree with the numeric clustered index, it would be my choice if it was me who created this table.

But this table is in another database...

Thanks for your opinion.

I also think that a second table is better than using the same table keeping sevral rows with NULL values.

Grant Fritchey (11/13/2014)

It depends. One thing that the optimizer takes into account is foreign key constraints. Since you can't have those...

Good point, the one that you mentioned. Thanks!

Even between two different databases in the same instance?

Thanks for sharing your experience!

I think I will use another database with some similar tables to where I will move some data.

If required I will allow to query these archived...

Do you usually use:

1 - table partitioning? (just suitable for Enterprise version)

2 - move old data to another table in the same database on another filegroup with different schema?

3 -...

Thanks!

The site you refer has codes in xml format files which I can import to Sql Server tables.

Regards!

GilaMonster, thanks for your tip.

Regards

No one?

Sorry, but I didn't understand what you mean. The table is...

Thanks for yours answers.

I thought the search by int column was faster, so meanwhile I also performed some tests on a table with a million records.

The values of columnString were...

Your query should work, but I don't think you can use timestamp as a datetime column http://msdn.microsoft.com/en-us/library/ms182776%28v=sql.105%29.aspx

As far as I know, timestamp is to store rowversion, not datetime...

I think you can use boolean logic as the following:

WHERE

( @PARAMETER = 'GT30' AND [ColumnDate] <= DATEADD(DAY,-30,GETDATE()) )

OR

( @PARAMETER = 'LT30' AND [ColumnDate] BETWEEN DATEADD(DAY,-30,GETDATE()) AND GETDATE() )

OR

( @PARAMETER =...