Though server and database can have different collations, the best setting is to make them the same. This is because tempdb and other system dbs will take server collations by...

exec

msdb.dbo.sp_help_job

exec

msdb.dbo.sp_help_schedule

exec

msdb.dbo.sp_help_jobschedule @job_name='YourJobname'

I have several databases that have more than 2.8 billions of records in some of the tables in sql 2000. It works well. For these tables, index design is very...

try this:

SELECT identity(int,1,1) as rownum, c1,c2,c3 into #temp from tab a

SELECT * FROM #temp

Whenever you COMMIT or ROLLBACK a tran, you need to test @@TRANCOUNT. If  @@TRANCOUNT>0 do it, otherwise don't do it. This will avoid the erro "that the code has an extra "commit...

If more than servers are involved in a tran, sql server will automatically escalate the tran to a distributed tarn. So BEGIN DISTRIBUTED TRAN is the same as BEGIN TRAN...

These are all sql server predefined schemas. I don't think you can drop them becuase they own objects, e.g. sys schema owns all system objects.

If you need to tight the...

Yes.  "column" deos not apply to insert and delete as well. E.g. you cannot insert/delete certain columns for a record. Column level only applies to select and update.

Yes.

If the protected object is a stored procedure or user defined function, the 'column' is not applicable and showed as '.' or null

Based on my experience, datareader is definitely faster. FOR XML adds loads in database side to build it and loads on app side to parse it (or deserialize it) to...

Based on my understanding, only service and database master keys can be backed up. Other keys are protected by master keys. Check BOL for Encryption Hierarchy