You seem to be talking about a different 'it'. I am referring to the many places in...

Could you post the CREATE TABLE definition please?

A few rows of sample data would probably help us give you the best answers too.

Paul

It all sounds very much like a lack of buffer pool memory.

Can you answer the following questions please?

a) Is AWE enabled?

b) Does the account that SQL Server runs...

The other question that stands out is: what type of replication is it exactly, and are any of the 'hot' tables replicated?

There are many ways to implement this, each with its strengths and weaknesses.

It's probably best to have an understanding of the issues you may face further down the track before...

Timothy Patihk (9/13/2009)

---

I have a database with an abnormally large transaction log file - 60GB. It was in Simple Recovery Model. I changed it to Full Recovery Model...

Steve is absolutely right (despite the terrible shirt :-)) - and PAGE-level restore is only available in 2005 and later versions.

Paul

Matt Whitfield (9/13/2009)

---

I'm not sure that 'in the description of a system stored procedure which 97% of sql server users have never heard of'...

The problem was simply that the full-text catalog needed re-populating.

Amodi specified CHANGE_TRACKING MANUAL and so must have added the data after the initial full crawl completed. A full crawl...

Jeff Moden (9/13/2009)

---

Fine... if you don't want to tell me what the CLR does so maybe I can come up with an alternate solution, then enjoy your memory problems. ...

That is so lame!

Hey look, we all make mistakes - some of us don't mind admitting it though.

*shrug*

Ok Daniel. Just remember that the 20GB is physical RAM, and the 32-bit virtual address space available to SQL...

I imagine it needs to be ./AdminDetails not .AdminDetails (note the forward slash)

Have you done much XQuery?

edit: Lutz's rewrite also works of course!

Hey Lutz, so I'm a Chrome 3 person 🙂

File attached. :sigh:

This all seems very hard work :laugh:

Thanks Lutz. Let's try that again, with the xml formatter (see below).

If that fails, I'll attach it as a file!

DECLARE @xml XML;

SET @xml =

N'

...