Taking you literally:

SET NOCOUNT ON;

GO

CREATE TABLE dbo.A (id INT IDENTITY PRIMARY KEY, silly_key AS 'ABCD' + CONVERT(VARCHAR(15), id))

GO

INSERT dbo.A DEFAULT VALUES;

GO 100

SELECT *

FROM dbo.A;

GO

DROP TABLE...

Just as a matter of technical interest:

If ROWNUM in Oracle returns rows ordered by the internal row identifier (RID) of the table, then SQL Server does have something similar, though...

On 32-bit editions, this is usually caused by a lack of available (contiguous) virtual address space.

Moving to 64-bit is a good solution - for any one of the many classes...

You are most likely running out of VAS (virtual address space). 32-bit SQL Server can only address 4GB of virtual addresses (not physical memory!)

By default only 2GB VAS is...

If you really must run this code sight-unseen, you can configure a larger multi-page allocator region using the -g start-up switch:

http://msdn.microsoft.com/en-us/library/ms190737.aspx

On the face of it, it seems a terrible idea...

Can you give some examples of searches you would like to perform, the data searched, and the expected matches please?

There is more than one way. Here's one:

SELECT N'Table with unique primary key for column ID: ' +

SCHEMA_NAME(T.[schema_id]) +...

SELECT name, log_reuse_wait_desc FROM sys.databases ORDER BY name;

That will show you what is keeping log records active.

Let us know what it says.

Just so we can be sure - how are you trying to do the restore exactly?

G² (9/8/2009)

---

I'm a big fan of using surrogate keys when designing databases, but they are not intended to enforce data integrity. They should be used to simplify joins and...

A LiteSpeed trial is an excellent suggestion. I keep banging on about FTP since using it nearly trebled our throughput on a 400Mbps up-country link.

Fair point Mr Fox 🙂

Slava Oks' old blog is a favourite of mine for all things memory too: http://blogs.msdn.com/slavao/archive/tags/SQL+Server+Memory+Management/default.aspx

'Correct' is a relative term with this question...but the discussion was fascinating in places.

A good question, from that point of view 🙂

I wouldn't worry about it too much - it's...

G²! That's quite funny!

Actually, I kinda gave him the benefit of the doubt. For all I know, he's writing a game where you allocate population to a country,...