Don't shrink. Even with the notruncate, you will badly fragment your indexes. There's little gain in moving the free space to the end of the file.

There will be no change...

Parameter sniffing?

Did you run the proc from management studio, or did you run the contents?

Can you post the proc?

Anything in the event log? Anything in the error log?

Right. Now we can talk about this.

Consider moving the subqueries into the from clause of the update. I can't rewrite the entire things now, I'm in a presentation.

So, the general...

Can you post the exec plan please?

There are places where this does happen and isn't a problem. The estimated rows is the estimated rows affected per execution of the operator...

Well, you can't create an index that contains columns from different tables, so that's not an option.

Try something like this:

t1 (col1)

t2 (col1, col2)

t3 (col2, col3)

t4 (col3)

Include columns would vary depending...

That's not a complete statement.

Is that part of a SELECT? Part of a SET? Part of an UPDATE?

With assertion failures and stack dumps, you should probably be calling CSS (customer support) as they are likely the only ones who will be able to help you.

Can you run...

Depends what you're trying to achieve with encryption. Remember that SQL's encryption cannot protect the data against the DBA.

As for what to encrypt, you need to identify what's sensitive data....

😀

All you do by backing up to 4 files is stripe the backup over 4 devices. It speeds up backups, nothing more.

As Alzdba said

You cannot alter db file separation using...

Nandy (11/20/2008)

---

I have done some analysis on the issue and found that if there is a one row in the table,then it will insert double the rows in the table...

Please don't cross post. It just wastes people's time and fragments replies.

No more replies here please. Replies to:

http://www.sqlservercentral.com/Forums/Topic605967-146-1.aspx

The error's coming from the line after the exec, because there's a variable with no assignment that's sitting there. That said, there are some other more minor issues with the...

What error?