It might not be the answer you'd like to hear, but you should not do this on the database side. Do it in the app side instead.

If you insist doing...

Does this do the trick?

DECLARE @tb TABLE (

col1 int

)

INSERT INTO @tb SELECT 1

INSERT INTO @tb SELECT 2

INSERT INTO @tb SELECT 3

INSERT INTO @tb SELECT 4

INSERT INTO @tb SELECT 5

INSERT INTO...

Can the two DTC connect to each other?

Have you checked that with DTCPing?

Change the query like this:

SELECT *

FROM @test-2 AS A

CROSS APPLY (

SELECT COUNT(*) AS matched_patterns

FROM...

Glad you liked it. 😉

This is the script I'm using:

CREATE PROCEDURE [maint].[dba_runCHECKDB]

@dbName sysname = NULL,

@PHYSICAL_ONLY bit = 0,

@allMessages bit = 0

AS

BEGIN

IF OBJECT_ID('tempdb..#DBCC_OUTPUT') IS NOT NULL

DROP TABLE #DBCC_OUTPUT

CREATE TABLE #DBCC_OUTPUT(

Error int NOT NULL,

[Level]...

Chris Morris-439714 (10/22/2010)

---

BTW while you are writing a reply, scroll down to the bar which reads "last 10 posts..." and click on the plus-sign on the RHS - which will...

hallidayd (10/22/2010)

---

rootfixxxer (10/22/2010)

---

@hallidayd

I need this, because it's necessary...

<snip>i can set the name of the columns in the application that will use it, but if i set everything in the sp...

There you go:

-- Create temporary table

IF OBJECT_ID('Tempdb..#PontoRegistos') IS NOT NULL

DROP TABLE #PontoRegistos

CREATE TABLE #PontoRegistos (

UtilizadorNome varchar(50),

Horas int,

DataRegisto datetime

)

-- Insert some sample data

INSERT INTO #PontoRegistos VALUES ('rootfixxxer', 2, '20101018')

INSERT INTO...

rootfixxxer (10/22/2010)

---

@Gianluca Sartori

That doens't i have this error:

Msg 170, Level 15, State 1, Line 33

Line 33: Incorrect syntax near 'XML'.

I never used the XML Path so i don't know how...

-- Create temporary table

IF OBJECT_ID('Tempdb..#PontoRegistos') IS NOT NULL

DROP TABLE #PontoRegistos

CREATE TABLE #PontoRegistos (

UtilizadorNome varchar(50),

Horas int,

DataRegisto datetime

)

-- Insert some sample data

INSERT INTO #PontoRegistos VALUES ('rootfixxxer', 2, '20101018')

INSERT INTO #PontoRegistos VALUES...

If you have LOTS of time to spend answering awfully off-topic questions, you can open an SR on support.oracle.com. 😛

If you provide table scripts and some sample data we can try to help.

Take a look at the article linked in my signature line, you will find how to post...

Once you found the top queries, you can analyze their exec plans and find if they're pushing CPU to the roof.

Here's a good method to statement-level CPU estimations:

http://sqlserverpedia.com/blog/sql-server-bloggers/sql-server-find-the-most-expensive-operations-in-execution-plans/

Don't use percent growth. 10% of 150 GB is 15 GB.

While the database grows by 15 GB, performance degrades awfully.

Use fixed size instead.

I usually set data file growth...