Viewing 15 posts - 91 through 105 (of 491 total)
Processors and RAM in this server ?
Use Raid 1 for Tempdb
Use Raid 5 drive D: for Log Files
Use Raid 5 drive E: for mdf.ndf Files
total space is dependent on the...
June 14, 2011 at 3:54 am
Partition the table first then Indexes,performance will be increase if table have heavy DML operation and huge data in the table but dont forget to define the Lock Escalation to...
June 14, 2011 at 3:42 am
you can do shrink the database in only 1 special circumstance when only 1 door is open ,you are completely lost with space and there is no any other option...
June 14, 2011 at 3:40 am
Give other users Readonly rights and then try to take the full backup and then restore it with different name after restore is complete then drop the previous one and...
June 14, 2011 at 3:36 am
Osql is depreciated in SQL Server 2008 ,you can use SQLCMD but SQL server is not running how he can pass statement against the instance.you should check or input the...
June 14, 2011 at 3:30 am
There are 2 types of Compression in SQL Server
1-Row Compression
2-Page Compression(Row Compression + Prefix Compression + Dictionary Compression)
Performance will be decrease because when you retrieve the compressed data...
June 14, 2011 at 3:26 am
When a Core is busy on a file of a filegroup then a second core can access the second file of a filegroup , that is not related only the...
June 14, 2011 at 2:55 am
Go to First Node and then ping the second node with the NIC connect directly for the heart beat and then do the same for second Node to the first...
June 13, 2011 at 11:04 pm
Check the LSN number of Transaction Log Backup File,you can check also this LSN information from backupset in the msdb database
then verify this back_set_id in the msdb restoreFilehistory table on...
June 13, 2011 at 10:57 pm
If you are going to install a second instance of SQL Server you should have enough hardware capability to manage this second instance like Processors Core,RAM and Separate Disk for...
June 13, 2011 at 10:51 pm
he want to take backup of Master database of Mirror server ,doesnt want to mirror the master database
June 13, 2011 at 6:34 am
First check the Execution Plan of the particular SP ,where is the cost
June 13, 2011 at 4:35 am
this account is powerfull and highest level of privileges on the local system,if you have revoked the Built-In\Administrator sysadmin rights then you have to give these rights to this account,by...
June 13, 2011 at 4:09 am
I didnt say Active\Active is not possible but as requirement of @anthony-2 is distribute the load of 1 instance on multple nodes that is not possible in SQL...
June 13, 2011 at 3:35 am
for DR side I recommend database Mirroring ,how much data loss you can bare
June 13, 2011 at 3:31 am
Viewing 15 posts - 91 through 105 (of 491 total)