Category: Database
Thursday, 24 November 2011 18:59
As I’m learning how to do the EC2 Amazon cloud services, I am compelled to post the how-to when setting up and connecting to an AWS EC2 SQL Server box. This will answer many questions for others so they can get around the few issues that will creep up when Launching a new EC2 SQL [...]
Tuesday, 7 July 2009 07:44
We are interested in your security and performance! To improve performance and enhance security of the Joomla platform be sure to provide a new prefix for Joomla database tables. This can not only provide improvements as indicated about security and performance, but it can provide a unique instance of the tables so more tables and [...]
Tuesday, 21 April 2009 14:54
There are many situations when you have a variable in a stored procedure and you want to add to it. Well, there is definately a slick way to build on variables within a single select statement. It’s necessary to reveal how this works in detail because it’s difficult to explain. So, the answer is in [...]
Tuesday, 21 April 2009 14:19
Alright, they’re necessary at times, but for the most part you need to really avoid them. It’s not about the coding and simplicity of using them, it’s about the impacts they have in the backend and on performance.
Thursday, 13 November 2008 17:17
Here are some articles that describes the need to reference the owner (schema) of SQL Server stored procedure when called by applications. Also, making sure that the calls are sensitive to the case of the schema.ProcName. Reducing blocking by compile locks Reducing Stored Procedure recompiles Algorithm for Auto-Update stats and recompile determination) Following these suggestion [...]