Yes. As is snapshot isolation.

I see their are a few articles about the possible overheads associated with this but is this something you...

I don't know what your developers are smoking, but a SELECT most certainly can block an UPDATE or INSERT. Selects take shared locks. If it's doing a table scan, that's...

ALTER DATABASE with the MOVE option will likely be easier. That changes the name in the system catalog, then you just take the DB offline, change the extensions in Windows...

Just go over it a couple times, make sure you are getting minimal logging. I ran that particular test a number of times, as did a friend and, while we...

Scaling out a SQL instance is not trivial. It's not a matter of adding a cluster and being done (and clustering's for HA, not performance). Multiple active SQL instances cannot...

Without all your code, I can't say. Maybe the operations weren't minimally logged (existing table, full recovery or any of the other reasons for not minimally logging)

The solution he gave there is the absolute last resort for when there's no backup and checkDB can't repair the error. Furthermore, you should never detach...

Ideally, restore from a clean backup, but only once you know the severity of the problem.

Take a...

jitendra.padhiyar (1/14/2013)

---

Can torn page issue occurs due to lack of disk space ? I know torn page is the page that is not correctly written to disk. But can lack...

There's a bug with missing index DMV where it recommends an index that already exists.

Don't use Task Manager to check SQL Server's memory usage. In many cases it will report a value far, far, far lower than what SQL is actually using. Use Perfmon...

If you mean to restore to a point in time earlier than any full...

That would work better than the order you originally had, yes.

How do you expect to restore to a point before that of the full backup that you're using?

It can occur. It's not an automatic thing that...