How to preserve global temporary table data

Question

How to preserve global temporary table data

Forum Etiquette: How to post Reporting Services problems

[/url]

Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
[/url]

How to Post Performance Problems - by Gail Shaw
[/url]

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

And, if you think about it, it comes down to how is the requirement is specified. The two following requirements are different:

The system must (or shall) retain the original information and error messages for 120 minutes.

The system may retain the original information and error messages for up to 120 minutes.

mister.magoo SSC-Forever Points: 47174 More actions · Answer 2

I wonder how much data we are talking about and whether a message queue is worth investigating?

MM

select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

Jeff Moden SSC Guru Points: 1004406 More actions · Answer 3

Lynn Pettis (4/4/2013)
Software doesn't "know" anything, it simply does what you tell it to do. It may follow algorithms to determine the best way to accomplish a task, but it still doesn't "know" things.

So far as SQL Server and most software that any of us will ever have the opportunity to work with goes, I agree. But I've seen some pretty nice software in other areas that learns by experience. It's actually pretty spooky. While the definition of being able to "think" or being "self aware" is a bit nebulous, some of the more robotic related software seems to make the bot sort of self aware enough to protect itself except in certain circumstances and is capable of learning what new threats are and can actually devise methods to deal with the new threats. Some of the self maintaining foraging bots the DOD is experimenting with are really getting spooky.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

SQLRNNR SSC Guru Points: 281334 More actions · Answer 4

mister.magoo (4/4/2013)
I wonder how much data we are talking about and whether a message queue is worth investigating?

I think that is good idea. I think service broker could probably be a very useful thing here.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events