Look it up in Books Online. Far faster than waiting for someone to come along, see your question, look it up in books online and post the answer for you.

http://msdn.microsoft.com/en-us/library/ms188917(SQL.90).aspx

Is this a clustered SQL Server?

Are you creating the DB from management studio gui or from script? If script, paste it here please?

Charles Kincaid (11/11/2009)

---

Most every thing Gail said applies to 2000. I'm setting on a bunch of 2000 deployments and a load of 2005...

I keep on seeing this. Kinda an incomplete cleanup of the replication.

Create a new transactional replication publication.

run sp_repldone in that db. This will not affect the snapshot replication

Drop the publication.

Check...

Read Committed Snapshot Isolation Level.

Does the directory N:\Backups\Userdatabases\Database\ exist?

Do the SQL agent and SQL Server service accounts have permission to that directory?

Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Test the suggestions carefully first. If they help, create them, if they don't then don't create them

The audit login event. The textdata column will give the isolation level (as well as a...

Consider read-committed snapshot, just watch the impact on TempDB.

It's not just dirty reads that read uncommitted allows. It can result in rows missed in a scan or rows read twice...

SQL Noob (11/11/2009)

---

if i have a table with a clustered index and say 5 NC indexes

i run alter index <clustered_index> on <some_table> rebuild

will this also rebuild all the non-clustered indexes...

Esalter (11/11/2009)

---

If an identity column is used for the clustered index (CI) and NC indexes use the identity column (key) rather than a RID as the retrieval pointer then doesn't...

Esalter (11/11/2009)

---

one thing I've frequently come across that would be extremely useful is the ability to define Foreign keys that are a compound key (concatenated columns). Do you know if...

No and no. The default isolation level for SQL is read committed. It's not a database level setting that can be defined on creation of a DB. If you're connecting...

Those...