Why do you want to use extra views?

Why not use the MainDB.Owner.TableName from like that:

select EMP.emp_name,

SAL.amount

from OneOwner.sales as SAL join MainDB.SecondOwner.Employees...

The SQLServer is using only 1 index on one table at time.

The optimizer will choose one of the index dependig on the statistics.

After either there will be a bookmark lookup...

Sorry Tim,

in the third solution (the pivot) you don't have to put the group by clause.

It has been a typo (copy/past) error.

Bye

Gabor

You could have several possibilities

1:)

SELECT MM.MonthNum AS [Month],

Count(DatePkgSent) AS AmountSent

FROM PotentialClients P right join

...

There is no exact rule.

Tell us how your production environment is (database size, number of concurrent users, number of transactions per minute, type of application (OLTP, OLAP), average size of...

The problem is easy when you want to convert the CURRENT time from UTC to local time or vice versa.

The difficulty is, as I've already run into, to say what...

If you want to define the number of returned rows as a parameter the only possibility is ROWCOUNT like this example:

create proc S_Sample @col1 int, @numrows int

as

set rowcount @numrows

select *...

I personnaly like Delphi for database development.

It's making a fast executable (standalone exe) with a fast development time.

You can find plenty of free and payable components where you can do...

if you are entereing DBCC SHOWCONTIG without any parameter the you will generate the showcontig for ALL tables.

If you are entering DBCC SHOWCONTIG WITH TABLERESULTS then you will get a...

A WEB based app is by design an OLTP app.

You can never know how many users ar ehitting your DB.

Therefore you have to design your DB performance in view.

Your question...

Martin,

What I'm doing when I'm reindexing my SAP database is the following:

• Make a full backup
• Truncate the log
• Put the recovery mode on bulk logged
• generate a script for the reindexing
• Regulary truncate...

And just summarising all what have been said I would say that for SQL Server performance what you need (in this order) Processor speed, memory and then disk.

Normally if you...

Do you have in your path your sqlserver bin folder?:

C:\Program Files\Microsoft SQL Server\MSSQL\Binn

Bye

Gabor

Or you can use EM to alter your table and insert your new column where you want if you want to keep the timestamp column at the end.

Bye

Gabor

Dave,

For that particular query I would define an index like this:

create clustered index I1 on AR(Transaction_Type, NAME, DUE DESC)

or

create clustered index I1 on AR(Transaction_Type, NAME, DUE DESC, Transaction_UID)

and at least...