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...
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...
We had a set of 2 databases on different servers. Say Database x and y on server A Database x and y on server B Now both the databases are being...
I can see and use the smilies when i post a new topic but when i go for replying I dont the smileys. I have seen smileys in other members replies....
I have a sql agent job which is set up to send Emails on failure. For last 3 days it has been sending failure emails but when I check the job status...
A butcher watching over his shop is really surprised when he sees a dog coming inside the shop. He shoos him away. But later, the dog is back...
The MCSE Training kit for this exam Microsoft SQl Server 2000 System Administration has come up with the second edition.I just wanted an opinion...
Hi Everyone In my team there are 4 more people apart from me.All of them have more than 6yrs of experience.I am the only one with experience of...
Which system table can help me to identify a long running transaction? cheers Parik****
How can I extract DDL for users or other objects using Enterprise Manager or Query Analyser? cheers Parik****
At times there is a long running procedure doing insert or updates . If we have to kill the stored procedure it will take long to rollback. Is there...
At times the tempdb syslogs fill up and you cant even log into the Server.The only solution that remains is to reboot the instance.As a solution to...
Separate names with a comma.
