Thanx Frank.Now it seems to be a lot more clearer.Something new learned for the day :):)
We were brainstorming over some of the interview questions my friend was asked in his interview.This particular question really boggles me.Could you...
Hi All I am planning to take the BI Certifications for BI in SQL Server 2005. Could you please refer some good books and learning resources to help...
CONGRATULATIONS
I had come to the site after a few days and felt i have come to the wrong page.But the new look and feel is really impressive.Also it performs...
You can monitor the IO field in the out of sysprocesses table.You must first identify your process id and then monitor the IO count.
you can use the DBCC Showcontig command to study the fragmentation level of the tables.To understand the output you can use BOL.Than you can target...
Apart from all the technical aspects you need to get an estimate from the business teams also.Could be some new measures are planned which may lead...
Whenever a clustered index is recreated all the non clustered indexes are also recreated.Non Clustered indexes contain pointers to data.So when the...
Hi Danny You can also make use of the detach and attach database option. You need to detach the source Database.Then take a copy of all the data and...
Hi Shadow If this a production database server and you are also concerned about recovery then better take a backup of the transaction Log and then...
Congrats Hemant cheers Pali Everything happens for your own good.
The SQL SERVER Press Book is a really good option.That combined with hands on Training and Work Exp will help you in understanding the system....
Thanx for all the inputs John.They are surely a value addition. cheers Pali Everything happens for your own good.
I had started reading that article today .I had found the link in one other thread. It surely is a good compilation and I am enjoying it. cheers...
I will go ahead and check the information on these sites. Thanx Frank. cheers Pali Everything happens for your own good.
Thanx Satya. We do not have any jobs scheduled during business hours.Most of the maintenance is done after business hours. Also both environments had...
A man was sitting reading his paper when his wife hit him round the<br />head with<br />a frying pan.<br /><br /><br />"What was that for?" the man...
I want to read and understand more about RAID and how can we organize data and log files on RAID for optimal performance. Could you all help me with...
right click on the job name and select START JOB. Then it will show you a window with all steps. You can select the step from where you want the job...
Separate names with a comma.
