Posts Tagged ‘SQL Server’
Monday, 12 April 2010 12:37
There is nothing better than knowing exactly what needs to be done to get the best results from your technology. Especially from a database server. Why wouldn’t someone read the manual on how to care for a car to know how it works? Because everyone wants to have the satisfaction that they got in the [...]
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 [...]
Saturday, 8 November 2008 11:53
The following error is appearing while running Visual Studio 2005 and developing an application with SMO capabilities. It appears when trying perform a foreach( on ActiveDB.StoredProcedures). Could not load file or assembly ‘Microsoft.SqlServer.BatchParser, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91′ or one of its dependencies. An attempt was made to load a program with an incorrect format. I found [...]