Patricia Johnson (6/8/2010)

---

So Does anyone have any experience with SQL 2008 to know the differences between SQL 2008 and SQL 2008 R2?

Thank you for your time and willingness to...

What's bad about that? What's your problem with the situation?

Assuming you are running short of space, you can always buy a cheap 1+ TB drive and keep pilling up...

Still can't work. Exec basically open a new connection with new spid based on the current context. Once that exec is over the use is.. well useless.

The whole...

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: