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...

Jagadeesh

Does this help?

John

When you run a package in Visual Studio, it runs under the account you're logged in as.  When you run it on the server, assuming you're running it as a...