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

DROP TABLE #Results
CREATE TABLE #Results (
     SchemaName sysname NOT NULL
,    DBName sysname NOT NULL
,    TableName sysname NOT NULL
,    IndexName sysname NULL
,    Frag decimal NOT NULL

Yes, you probably do need something a bit more sophisticated than just a calendar table.  The snippet below will convert your Dates table into a table that just shows the...

Create a calendar table in your database, with weekends and other non-working days marked off.  You then only need to add another predicate to your WHERE clause:
WHERE...

I would just restore the databases from where the backups are.  You may need to tweak some NTFS permissions, and maybe change some drive letters to UNCs, but it'll cut...