For free books and videos

=============

http://www.4shared.com

For free Videos and CBT

============

http://www.torrentz.com

Do you have a script or query of any one of them export and import ?

I am forced to ask the same questions again of you, Syed:

What in this query makes you believe that removing parallelism will enhance this query?

What query hinting do you believe...

@"Mr. Alphabet Soup":

It starts to get annoying to see replies with the "answer" being a lot shorter than the alphabet soup under your name. Sometimes you're leaving the impression that...

Table partitioning is a good new feature in sql server,when you go to partition a table then you have some type of policy like next year data must be in...

SELECT ST.TEXT,SP.SPID,WAITTIME,LASTWAITTYPE,CPU,PHYSICAL_IO,STATUS,HOSTNAME,PROGRAM_NAME,CMD,LOGINAME FROM SYS.SYSPROCESSES SP

CROSS APPLY SYS.DM_EXEC_SQL_TEXT(SP.SQL_HANDLE) ST

WHERE STATUS !='SLEEPING'

ORDER BY CPU DESC

Use this query for CPU and IOs

any Network activity perform ?

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

check this link and apply in your scenerio

your application built on ? which one using this database

For the backup file curruption then you will use Verify the Backup on finished option and checksum option for the media test

you can't ignore the cost of the Tape and...

you should execute the code on query analyzer for the error , if you cant do this then use TRY and CATCH the error and insert in a table

Begin Try...

1-Take Full Backup daily at night and then take file system backup on tape

2-Take Differential Backup at every 5 hours and then take file system backup on tape

3-Take Log backup...

OS or Network Level rights depends on the SQL Server Service Account ,so you must have an access rights on the particular folder or drive on the service account

PhilipC you should leave 4GB RAM for OS operations , now you have 60GB Total RAM on each machine and note it you are defining MAX Memory parameter not Minimum...

that might be a problem of Time synchronization with domain controller,schedule the time synchronize with Domain controller command on OS level on the machine who creating this problem

Non-Clustered Indexes

==============

If you have a book of 1000 pages without table contents and index(appendix or glossary) and you want to read a specific Topic then you will have to read...