Hi, Got stuck while installing an Active/Passive clustering for MSDTC. While allocating resource to MSDTC IP Address can not find the desired Disk...
Hi, First let me tell you the kind of Structure and the relationship among the Tables : Table1 : T1ID int, T1GUID GUID, T1Name Varchar, T1Desc...
Hi, I have got a Stored Procedure to resolve a strange problem. But I am not able to trace the root cause. The SP has been developed to delete the...
Hi, I am currently working in a 2 - Node Active/Passive Cluster where we have 8 instances. More surprisingly, both the nodes are having only 3.75 GB...
Hi All, Thanks for your feedback. In fact I was also under impression that the Patrol provides some meaningful data at the very begining. But when...
Hi, I have a test Server having the following configuration : Model Type : DL360 G3 Processor : 3.06GHz Speed Memory Size : 2GB Hard Drive :...
You can test to create the Table in ROLLBACK - Mode before implimenting the actual one. Regards, Arindam Ganguly
I think before restoring the Database on Standby Mode through QA/EM, you should stop the Logshipping job, make a slight change in the relevant Log...
To have a further addition, the DB with higher growth propensity should set the growth rate as 500 MB or 1000 MB rather than with % - growth value....
Hi Graeme, Can you please change the Code Pattern of the Product you use for accessing the data with COLLATE - Keyword followed by the actual...
Hi, Currently I am working in a Backup-Restoration Setup where the databases are getting backed up (Full Backup once in a week, Differential Backup...
Hi, I am finding a high degree of Index Fragmantation in one of the Databases that I work with. The DB has its size 79 GB and all of its Tables were...
Hi, I need a help. Can anybody pls provide me any idea about DTS Scripting. Is there any way out to get the script for a given DTS package....
Hi Satya, I have checked the maximum degree of parallelism set to 0 ? Should I change it. If it is then to what value ? Pls advise. Regards,...
Hi, I have written a Query that shows a stream of Broadcast Exchange operator Parallelism. I can't understand the basic reason behind it as I know...
Sorry Satya for late reply. I have Filtered the entire Tracer view to the Failed Login event of Security only. Also I have removed the...
Even I tried and checked it. But found Login failed for user 'sa' - Message only while the HostName remained Blank. Is it possible to get any Script...
Hi, While looking ahead on the Error Log of my Server I have recently found a list of failed Login Info. I would like to identify the Host name from...
Thanks Satya, I have got a confirmation regarding some changes in switches. I will try to analyze it from Network point of view. Regards. Arindam...
Do you want to export the Data to a Temporary Table of other form or in any #Temp Table. Will it not degrade the general performance of the...
Separate names with a comma.
