(1) Make sure you set max server memory such that there is sufficient memory left for the operating system and any other applications or SQL Server components on the server

(1) Back up the transaction log
(2) Restore the Full from 05/11 with no recovery
(3) Restore the differential from 11/11 with no recovery
(4) Restore all transaction log backups...

Use sp_whoisactive to see what statement is currently running.

John

Or this - it has fewer moving parts and seems to run a little bit faster than Eirikur's.

SELECT
    DATEADD(second,-DATEPART(second,create_date)%15,DATEADD(ms,-DATEPART(ms,create_date),create_date))
FROM sys.all_objects

John

Sam

It's taking the maximum value of c1 over the current row and the next five, ordered by id.  So for row 1, it will show the maximum value...

I just typed the title of your topic into my favourite search engine, and it provided lots of results that I think would answer your question.  Try it yourself.

In a clustered or a non-clustered index, if there is not sufficient space on a page to insert a row, a page split occurs.

John

In a heap, new rows are inserted at the end.  Is that what you mean?

John

If the table has a clustered index, that index will have its own fill factor, so that will, in effect, be the fill factor for the table.  If the table...

SELECT
     DENSE_RANK() OVER (ORDER BY C1) AS Txnid
,    id
,    c1
,    c2
,    c3
FROM dbo.test
WHERE id < 7;

John

Well, something's not right, is it?  You may need to speak to your admins, whoever they are, and ask them to be a little more specific and tell you what rights...