Viewing 15 posts - 151 through 165 (of 491 total)
For free books and videos
=============
For free Videos and CBT
============
May 30, 2011 at 4:44 am
Do you have a script or query of any one of them export and import ?
May 30, 2011 at 4:42 am
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...
May 30, 2011 at 3:54 am
@"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...
May 30, 2011 at 3:39 am
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...
May 30, 2011 at 3:30 am
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
May 30, 2011 at 3:14 am
any Network activity perform ?
May 30, 2011 at 3:11 am
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
May 30, 2011 at 3:10 am
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...
May 30, 2011 at 2:32 am
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...
May 30, 2011 at 2:24 am
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...
May 30, 2011 at 2:18 am
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
May 30, 2011 at 2:14 am
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...
May 30, 2011 at 2:09 am
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
May 30, 2011 at 12:02 am
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...
May 29, 2011 at 11:49 pm
Viewing 15 posts - 151 through 165 (of 491 total)