Hope that the naming convention when creating stored procedure must not be sp_ it should usp_ or whatsoever, but not sp_. What is the implications? It might have a performance...

It helped a lot for me... yehey!!!!!!!!:-D

Yes. Tha't true, it might be SQL patches. 🙂

In our company, we're using 4 node with 4x8 cores CPUs and 128GB RAM as of now, since we used the G7 blade servers that is upgradable to 1TB of...

I have some few questions to the author with regards to the windows powershell scripts:

1) Can we integrate the powershell scripts to the Policy Management or shall I say can...

Though, I did not test it yet on my environment right now but I'm very thankful and very grateful to Shaun for having this kind of article... Thanks a lot...

Same here with me. That's why I have to find the scripts, but to no avail. Anyway, maybe he'll be answering this problem within the day. 😛

Where's the script? Hehehe... I think you forgot to add the script... 🙂

In most cases, I always use MB rather than % and monitor the growth of the database and log.:-)

In most cases, I always MB rather than % and monitor the growth of the database and log.:-)

I've been realizing that creating a non-clustered index on the foreign key is quite a very good idea. Nice article, very informative and interesting. 🙂

I still have SQL 2000. Mostly our SQL server are SQL 2005. I have also three or five SQl 2008.

Just re-create it. It will surely solve your problem. 🙂

Hi William,

This is a great script. 🙂

Please check if it has rights on the folder that you have specified. Or else, just use SSIS to do it.