Viewing 15 posts - 1 through 15 (of 21 total)
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...
December 21, 2011 at 10:15 pm
It helped a lot for me... yehey!!!!!!!!:-D
August 24, 2011 at 2:40 am
Yes. Tha't true, it might be SQL patches. 🙂
July 21, 2011 at 2:14 am
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...
March 11, 2011 at 3:48 am
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...
November 20, 2010 at 3:49 pm
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...
October 4, 2010 at 5:58 pm
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. 😛
October 4, 2010 at 12:45 am
Where's the script? Hehehe... I think you forgot to add the script... 🙂
October 3, 2010 at 9:34 pm
In most cases, I always use MB rather than % and monitor the growth of the database and log.:-)
November 26, 2009 at 12:08 am
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. 🙂
November 9, 2009 at 3:56 pm
I still have SQL 2000. Mostly our SQL server are SQL 2005. I have also three or five SQl 2008.
October 27, 2009 at 3:32 pm
Just re-create it. It will surely solve your problem. 🙂
October 27, 2009 at 2:53 pm
This is a great script. 🙂
October 27, 2009 at 10:30 am
Please check if it has rights on the folder that you have specified. Or else, just use SSIS to do it.
October 27, 2009 at 10:21 am