It's dead easy if you've got it in Excel.  Add a new column with a sequence number in, then a second new column with a formula something like...

Why is it important to alter the logins in a particular order?  If you really need to, you could try something like this:

SELECT 'ALTER LOGIN '...

I don't know - I've never used that.  But it should be fairly easy for you to test out.

John

Probably the best reason not to grant the permission is that you want to keep your database design confidential.

John

Well, yes - if the users don't need the permission, don't grant it.  Follow the principle of least privilege.

John

Like Luis said, what have you tried?  I'm not here to do your job for you.  Hint: use the DATEPART function.

John

Andrew

If, for example, the users will be troubleshooting performance problems, then they'll need to know the definitions of stored procedures, data types of columns and so on.  That's...

As I understand it (and things may have changed since I last looked at it), you can license only one of your cluster nodes if you intend to run all...

WITH StartandEnd AS (
    SELECT
         Rid
    ,    MIN(Start) AS Early
    ,    MAX(End) AS Late
    FROM MyTable
    GROUP BY Rid
    )
SELECT
     Rid
,    DATEDIFF(second,Early,Late) AS...

Good question. Let's investigate.

USE tempdb;

SELECT
    -1 AS Col1
,    0 AS Col2
,    1 AS Col3
,    65 AS Col4
,    32768 AS Col5

Well, it's the same answer, just rendered differently.  Actually, it's different data types.  Run this, and all will become clear.

SELECT
     4.0 AS Col1
,    CAST(4.0...

What you told SQL Server is that 24GB is the most memory it may use.  If you don't have enough data to fill the buffers, or if you don't use enough...

No, you only need it in the Sales Order table, otherwise you introduce redundancy and hence risk the integrity of your data.  Don't denormalise to simplify your queries unless this...

Absolutely. Indeed, if the relationship between those two tables is one-to-one, why have separate tables at all?  You could put everything in one table.

John