Viewing 15 posts - 1 through 15 (of 310 total)
There's only the one instance running.
SELECT * FROM MyTable with an isolation level of READ UNCOMMITTED showed that the insert had worked while the update was hanging. Taking the...
May 6, 2011 at 2:17 pm
Thanks for the fast response.
The cause turned out to be a primary key violation on the table that wasn't populating. The insert was was using a SELECT statement that...
July 19, 2010 at 4:23 am
Wrong metric ! It matters not how long you work but how much you produce - and of what quality. Tired people make mistakes. Increase your costs...
November 14, 2008 at 1:54 am
Particularly in a waterfall methoodology, developer time is not that significant; the big chunks are the business and systems analysis, testing and configuration ... and, if you already have a...
September 19, 2008 at 6:18 am
You say that the amount is being updated which implies that it is being passed from the application. Can you confirm that it is this sored procedure that is...
September 15, 2008 at 2:14 am
Developers, DBAs, architects, to say nothing of systems analysts, business analysts, testers (even users !) : We're all a team and we all need to work together. Silo's are...
August 1, 2008 at 9:03 am
In OO world, encapsulation is a fundamental rule
The only fundamental rule is to write robust, performant, maintainable systems. The OO paradigm is one means to this end - it...
July 30, 2008 at 7:27 am
CREATE PROCEDURE dbo.Do_Update @TableName VarChar(128),
@Action TinyInt,
@key VarChar(255),
@Data VarChar(2056),
@Validator Integer,
@UpdatedBy nVarChar(128),
@Result VarChar(255) OUTPUT
AS
SET NOCOUNT ON
DECLARE @StartTranCount AS...
July 30, 2008 at 3:19 am
For trivial inserts and deletes, there can be an argument for avoiding stored procedures but, for anything more complex, there are clear performance gains. The biggest bottleneck is likely...
July 30, 2008 at 2:12 am
In a previous career, I undertook a lot of market research in the paper industry. The advent of the electronic office was going to really hit the demand for paper....
July 28, 2008 at 1:52 am
For the OS SP, go to Windows Update. That should detect and supply anything missing.
May 13, 2008 at 8:42 am
Anything + Null = Null so I suggest that you tace all the @rtf + instances and find which one is null. Just hack the code to write each...
January 25, 2008 at 2:13 am
Thanks Jeff, it had scrolled off the side of my monitor!
High level tools (like the data adapter) are great for productivity but its easy to end up with hidden issues....
January 9, 2008 at 7:22 am
Viewing 15 posts - 1 through 15 (of 310 total)