(1) Yes.

(2) If you're asking why index size isn't zero when there is no non-clustered index, I don't know. I imagine there's some small overhead for the possibility that...

Bhuvnesh

A clustered index isn't the same as other indexes - it forms the actual rows of the table and therefore doesn't contribute to the "index" size. When you create...

Nevarda

Have your text response system only accept whole numbers between 0 and 10. If customers want to provide comments and feedback as well, put that in a separate field....

Two good reasons to apply service packs, even if you don't think you need them:

(1) They contain patches for security vulnerabilities

(2) When the product goes into extended support, Microsoft will...

If you change the collation of an existing database, that doesn't change the collation of all the columns in it. It only sets the default for newly created objects....

Yes, it is, using IDENTITY_INSERT, but why would you want to? The values in the ID column don't (or shouldn't) have any intrinsic meaning, so it doesn't matter if...

That'll be the SQL Server VSS Writer service. You should switch it off if you have a complete database backup regime in place (which, of course, you should).

John

Yes, or maybe another full backup was taking between the two backups you're working from? Again, check in msdb.dbo.backupset.

By the way, you don't need the MOVE clauses when you're...

If you're doing the failover as part of a real-life test, then Anthony is right - leave the applications running. If you're failing over for some other reason, for...

jjturner (8/5/2014)

---

Is it possible to RESTORE WITH MOVE and subsequently RESTORE the remaining backup chain (DIFF's and LOG's) to the new location?

I'm getting this error when I try to RESTORE...

Also, read about SET XACT_ABORT ON/OFF to learn more about different ways SQL Server can handle errors.

John

Rebecca

Here's one way: select distinct columns from the table, use row_number() on that, then join back to the table.

John

I'm not sure what your question is, but a date column is often a great candidate for an index - even a clustered index. You'll want to weigh the...

(1) In the absence of any flow control logic (GOTO commands etc), the second command will start when the first has finished, and so on.

(2) A deadlock will cause one...

That syntax you use in your UPDATE doesn't look right. I've certainly never seen it done like that before. Here's how I'd have done it:

UPDATE i

SET Name =...