Look into UNPIVOT in BOL.

DROP

TABLE #tblA

CREATE

table #tblA

(

ItemNumber INT,

I would disagree with the point that this design is OK. 

As for all other points I agree.  And a UNIQUE index on Login is suggested at the least on...

Unless you want it to.  There is a way in visio to refresh model, and you can either push the changes to the server, or revert back to the old...

pretty easy to with Server Management Studio.  Right click on DB. ->Tasks->Export Data... Follow prompts

Two area's I might agree with you.  Exception Handling and Cursor handling. 

Cursors better be superior because they didn't support temp tables. (I know they do now to some degree)

I...

Actually when I was using it, it was part of a delete statement, but here is where I got that:

ms-help://MS.VSCC.v80/MS.MSDN.v80/MS.SQL.v2005.en/udb9/html/50705caa-4d0a-490f-92a4-75ece96e0a54.htm

Although the effect of SET ROWCOUNT on SELECT statements remains unchanged,...

I have now worked with SQL Server for about 6 months.   I worked with Sybase for about a year (developer, not DBA) but I was a very knowledgeable DBA with...

SQL - NO.

DMO/SMO yes, but you are going to have to write some code.  Even VBScript.

Are both Development and Production 2005?  I have seen in large tables a big difference between the following and how they perform.

It seems like

set ROWCOUNT=8 is best solution for...

Hmm... I am assuming you want to put the DDL in a database, but not initially create the index to be "rebuilt" at a later date. 

There is no way to...

Ok then yes, backup exec actually creates virtual tapes.  Constructs SQL backup statements and runs the backups through SQL Server.  So the history is tracked, however you still have to...

Coming from a similar background.  I am questioning the NEED to restore the system databases.  I expect that you really don't need to.  Can you detail why you think that...

Actually you sort of can.  If the table is clustered the index has to be hit.  If not, this will only show index access.  FYI, because this is a dynamic...

I see you used DENSE_RANK() vs. ROW_NUMBER().

So if I understand how this works.  ROW_NUMBER() would be used if you want the top N rows by customer.

and DENSE_RANK() will return all...

Mike.... It looks like the OP tried that.  Is "allow data loss an options?"