aviad.co1 (6/7/2010)

---

yes, thank's.

I create this stored procedure below, but I get this error when I try to update the properties :

property cant be add. property 'Domain' already exists for 'object...

dbo.t1 inner join dbo.t2 on... is definitly the proper way to do it. The optimiser won't pick a better plan either way but the dev could accidentally make a...

Difference between what and what? You only show us one of the 2 options. As far as I can tell, that code is the standard in the industry....

Both methods work fine. Usually the select into + rescript everything works well if you keep only a small % of the data like 25%... maybe a little more.

However...

Looks like this may do the trick... I found it on google but I didn't test it.

http://sqlblog.com/blogs/aaron_bertrand/archive/2009/07/30/when-will-my-backup-restore-index-reorganize-finish.aspx

I've never had that error, but I'd ask how big the restored file is because you're limited to 4Gb after the restore is complete.

After comming up dry with google search...

How about using sql express 2008 [advanced] on a local machine? If you really have only a few users, that'd be plenty strong enough and you wouldn't have to...

what have you tried and what is wrong with that you've tried?

:w00t: You...

Then chances are you are getting recompiles for "no good reasons". Or for reasons that could be avoided. That being said are you having performance issues on the...

Only if not necessary. That's where the whole question resides.

Can you post the code of the sp(s) that are recompiling?

Of course... but while they work on it... :w00t:

In case it can help you, maybe you can read straight from the ssc site here : http://www.sqlservercentral.com/NewsletterArchive

If this is a SP, then you can definitly try this.

DECLARE @LocalWeek INT

SET @LocalWeek = @ParamValue

The use @LocalWeek in the query that will help the optimiser.

Also add the with recompile...

Have you tried something along those lines?

Select identity(int,1,1) as DeleteID, WeekNo, Id into #tmp FROM DeletingTbl where WeekNo <= @Whatever

set rowcount 50000

set @Loop = 0

while @@Rowcount <> 0

begin

SET @Loop =...