Not unless you're using one of the snapshot isolation levels or have complex select/from portions to those insert/updates that does hash joins or needs work tables or have triggers on...

Under the server folder you see logins and the only permissions they have are server-wide permissions (sysadmin, security operator, backup operator, etc)

Under the database folder you see database users and...

Can you post the execution plan please?

Why would you run them on an undamaged database to 'test'? Seeing as the command is intended repair damage, running on an undamaged database is not going to test anything.

Want...

Theoretical maximum, not sure if there is one. Actual maximum that you get, you'll have to monitor over a period of...

Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.

What about them are useful? What problems can you solve now that you couldn't solve before?

I asked this question...

Why did you run that on the database WFilter when it's MSDB that's damaged?

Errr... what don't you understand?

http://serverfault.com/questions/169957/backing-up-a-sql-server-vm-by-doing-a-complete-vm-backup-as-opposed-to-individua

http://support.microsoft.com/kb/956893/en-us

Virtualization Snapshots for Hyper-V or for any virtualization vendor are not supported to use with SQL Server in a virtual machine. It is possible that you may not encounter any...

greg.senne (2/4/2013)

GilaMonster (2/4/2013)

---

The output keyword will output as many rows as the operation affected. Insert 4 rows, the output will output 4 rows. Delete 300 rows, the output will output...

The output keyword will output as many rows as the operation affected....

I could live without the GUI, the enhanced windowing functions...

Output into a table variable, then work from there

Have you investigated the new features? What are your...