As Lynn said, give us something to work with! My guess is that Grant is dead on, just in case, check free space on all relative volumes, auto growth limits/settings,...

This adds an incremental number to the output, by stating (SELECT NULL), one indicates that...

The code below demonstrates how to use output parameters in a stored procedure

😎

CREATE PROCEDURE dbo.WasInsertSuccessfulQuestionMark

(

@ValueToInsert INT

,@ThisTellsMeIfSuccessful INT OUTPUT

)

AS

/*

usage

...

Quick question, do you need assistance providing the necessary information.

😎

ScottPletcher (8/1/2014)

---

If the table may or may not exist, you'll have to make references to that table only in dynamic SQL. Otherwise, if the code runs and the table...

Just throwing in my 2 cents, my preferred way is to use SSIS to import the XML into a staging table and shred it with XQuery into the destination tables....

Out of curiosity, why 11g, that's quite an old horse? BTW, don't know of any automatic tools for the job, normally is scripting rebuilding, rewriting and transferring kind of a...

You can use a query in the case statement, simplifies thing

😎

SELECT

CASE

WHEN EXISTS (SELECT * FROM DB_1.sys.tables WHERE name = 'TBL_TRIP') THEN (SELECT TOP 1 name...

danielfountain (8/1/2014)

---

Hey all,

I am shortly embarking on a project to redesign an ETL process.

Currently issues can be cause by end users running reports (SSRS, EXCEL) while a table is updating....

Impossible to say without more information. Could you post the table structure, the update code, execution plans etc., the more the merrier.

😎

Since the case statement is doing incremental steps, it can be simplified using integer division, see the example.

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @SET_SIZE INT = 40000;

/* Test data 1 to @SET_SIZE...

You can count the rows before and after or use @@ROWCOUNT

😎

USE tempdb;

GO

DECLARE @PRECOUNT INT = 0;

DECLARE @RET_VAL INT =0;

DECLARE @TABLEX TABLE (IVAL INT NOT NULL);

SELECT @PRECOUNT = COUNT(*) FROM @TABLEX

INSERT...

GilaMonster (7/31/2014)

---

So according to your...

lee.hopkins (7/31/2014)

---

I have an vb6 (dont snicker) application that is used all over the world.

some users refuse to leave the regional setting to english and i am haveing an issue.

a...

Michael Valentine Jones (7/31/2014)

---

As a general rule, vendors have very little knowledge of DBA best practices, so they just toss out some misinterpreted stuff that some junior developer found on...