I have tested this a lot of times. And i saw that for a stored proc with 10 paremeters there is NEVER a good plan.

Using the EXEC SP_EXECUTESQL variant always...

I have some experience with this too and i found out that when you are using several paremeters it is better to build te string Dynamically and use SP_Executesql.....

Some Advantages...

I know it is hard to believe..... But this is the real QUERY...

declare @Bdate datetime

set @Bdate = convert(datetime,'2000-01-01')

select count(*) from XXX where BtDate = '2000-01-01 00:00:00.000'

select count(*) from XXX where...

No memory table is not a Temp table. It is really a table in the server's memory. Nothing is on disk... There is no I/O. That is why the memtable...

Well Antares689,

Never seen a difference, well find a table with 5 million rows (and not ONLY one column).

And run a query on a datetime field. One with a datetime...

Yes in my example this datefield is the last field of a

nonclustered index.

The index consist of 4 fields........

This in reply to your first post.....

Edited by - well0549 on 12/05/2002...

If you only want to get rid of the cursor you could use a memory table.

But if the cursor would be HUGE it wouldn't be an option. But if the...

Tested it myself....

And was STUNNED !!!!!!!!!!!!

a query on a datetime field was 20 seconds faster when it was like this

select xxx from yyywhere birthday = '2002-12-04'

the other variant i tried...

Just create a Job that performs the desired task. Use xp_startjob to execute it. It is the easiest way of doing things......

Only what will happen with two subsequent Jobs ?...

Well a bit awkward ???? why and how ????

Just Schedule a Full backup Every night with the SQL Server Agent.

Add a step to copy the file to your machine.. XP_CMDSHELL...

Well You are probably using named pipes as the protocol. So if you want this to work,

Create a drive mapping from the client to the server. That way you know...

Well because to KNOW is better than to THINK, I tested this situation.

And Guess what......

As long as the Drives/directories on both servers are the same everything works fine. No problem...

Some comments on Clustered indexes :

When selecting a column to base your clustered index on, try to avoid columns that are frequently updated. Every time that a column used for...

Well if you update the clustered index it will be slow but also a bad design !

A clustered index shouldn't change like that !

Well i dont know if there is a AMI converter in word. But i think you have to look for specific tools.

Or you could do the following write an VB...