Is the semi-colon ";" optional when creating a CTE?

For example, a CTE could start with ";WITH" or "WITH" right?

Have you tried looking at this DMV (dynamic management view)?

sys.dm_io_virtual_file_stats

This may help:

http://blogs.technet.com/b/josebda/archive/2009/03/31/sql-server-2008-i-o-performance.aspx

If you have the storage capacity and can deal with the performance hit of Change Data Capture, you could turn it on. Then you'd have a solid history of...

If you use Symantec Backup Exec, I recommend you do test restorations.

You can redirect the destination of a restored file with Symantec Backup Exec. If you have multiple people...

The answer included this statement:

"The query optimizer in lower editions will only consider the indexed view if you use the NOEXPAND table hint."

In SQL Server 2008 Standard with no SP,...

Dice.com says that the average I.T. worker gets paid $80,000 per year. Some parts of the U.S. are expensive. Some of the jobs pay proportionately more. But...

LSNs aren't integers?

Say a row with three columns gets all three of its values changed. How many LSNs would be generated if this happened with a single INSERT INTO...

So a huge insert into would be given a single LSN?

If the database was in a simple recovery mode but the log file couldn't grow, would the transaction fail?

If a...

"Can a compressed backup and sn uncompressed backup of a particular database co-exist in a single media set? "

What is an "sn uncompressed backup"?

I understand system functions are often specified with an @@ at the beginning of them. What percentage of system functions have the @@ symbol at the beginning of them?

From...

I can't find evidence that full text searching was ever used. This concerns me because I think I'm not aware of why these components are installed. Therefore I...