Search Results | SQL Server Performance Forums

Thread by: BDRichardson, Oct 2, 2007, 9 replies, in forum: T-SQL Performance Tuning for Developers

Is there any way in which it is possible to retrieve data, such as a variable, within a Trigger from an executed Stored Procedure? For example, I...

Thread by: BDRichardson, May 16, 2007, 3 replies, in forum: SQL Server DTS-Related Questions

Hi, I have several Stored Procedures, which effectively do the same process, but on different linked servers. The linked servers are at remote...

Thread by: BDRichardson, Apr 19, 2007, 3 replies, in forum: T-SQL Performance Tuning for Developers

Hi, I have created a stored procedure which truncates a table, and then populates it from a text file using by bulk insert. It all works perfectly...

Thread by: BDRichardson, Feb 21, 2007, 0 replies, in forum: SQL Server 2005 Reporting Services

Is is possible to reference the DisplayName property of a Local Report from within the report itself, i.e. use it in an Expression like the...

Thread by: BDRichardson, Jul 11, 2006, 8 replies, in forum: T-SQL Performance Tuning for Developers

Hi, I suspect that I can only achieve the desired outcome of my problem by creating a Trigger on the table. However, I wonder if I can achieve the...

Thread by: BDRichardson, Jun 22, 2006, 5 replies, in forum: T-SQL Performance Tuning for Developers

Hi, I'm sure the answer to question I'm about to is NO, but I'd appreciate it if anyone would kindly confirm so. Well, is it possible to declare a...

Thread by: BDRichardson, Mar 17, 2006, 38 replies, in forum: T-SQL Performance Tuning for Developers

Please would someone kindly clarify for me which is the most efficient way to determine whether a string (VARCHAR) value has a zero length. I am...