The only time you can use a snapshot like that is if you have database mirroring. Providing the mirror DB is synchronised (note, synchronised, not running in synchronous mode), then...

What's the purpose behind this? Redesigning a database that's in use is not something that I see done often. It can require a lot of time and money and, unless...

LaTeX - it's a document markup language that's used extensively in academic fields. Based on TeX

http://www.latex-project.org/

Timothy: Personally I'd just use a verbatim block, then you can format it any way...

You can take backups of the log of a database that's used for replication as long as the DB is in full recovery mode. No problems there

The log shipping requires...

You can. Whether it will be useful or not is another matter.

I'll be blunt, as usual.

Dumps are cheating. Get your hands on one of the training kits for the exam and work your way through it. People cheating their way through...

Sorry, I didn't understand that. Could you please explain a bit more what you're trying to do?

Could you be a little more specific on what you want please?

Next time, please post in the appropriate forum, not an article discussion forum.

Turn autoshrink off!

Autoshrink doesn't just shrink the log file, it shrinks the data file as well. Shrinking data files causes index fragmentation. The next time data gets added, the data...

Personally, I've always preferred using perfmon for checking SQL's memory. I just don't trust task manager.

I just tested out on my desktop (Vista 64 running SQL 64 bit) Task manager...

Which is what the test with the read uncommitted shows.

If the isolation level is read committed or higher, and SQL has to scan the index it will scan in index...

For proof of what read-uncommitted does to ordering...

(borrowed and slightly modified from WesleyB's old blog

CREATE TABLE tblClustered

(ID int,

MyDate smalldatetime,

TestField char(2000))

GO

CREATE CLUSTERED INDEX ixID ON tblClustered (ID, MyDate)

GO

DECLARE @i int

SET @i...

However, even if the index hint is specified, there are ways to mess up the pseudo-ordering.

Parallelism (parallel scans and the subsequent repartition/merge streams return the data in no particular order)

Read...

I'm going. Second summit in Seattle.

There's a very good Thai restaurant in a shopping center a couple blocks from the conference venue. I don't recall the name, it's the same...

What information are you looking for?