Hmm. Never used plan guides, so I'm guessing.

How about the template option? That's for use by parameterised queries, so maybe...

I believe that lock pages is required if you're using AWE. If you don't have more than 4GB memory on the server, you do not need awe or /PAE

As it...

Why are you trying to send me the excel spreadsheet?

I was talking about sending the exported file to your consultants.

How are you trying to mail the files? I can't offer much help unless I know what you're doing...

With SQL 2005, Database Mail's probably the easiest to set up if...

Change CONVERT(VARCHAR(20)... to CONVERT(VARCHAR(25)... Some of the converted date is getting cut off.

Hmm. If you look at the printed out dynamic string, what does that last part (with the dates) look like?

Regardng attaching excel, it depends how you're doing the mailing what...

Might be possible, but you would have to express it as a logical expression

(Col1 between 0 and 5 and Col2 between 0 and 5 and Col3 between ...)

Rather don't use...

DBCC ShrinkDatabase or DBCC ShrinkFile

You can find all the details for both in Books online.

Be aware that a DB does need some empty space to function properly, so maybe shrink...

Does this help? I can't test it, since you haven't given the table schemas or any sample data.

Select Usr_ID

from User_roles

inner join ACCESS_RIGHTS ON

((Access_Rights.MEMBERSHIP_OBJECT_ID = User_Roles.Rol_ID AND MEMBERSHIP_OBJECT_TYPE =...

Try a planguide for adhoc code

@type = 'SQL', @module_or_batch = NULL

sp_executesql's just executing a string passed to it. The @type=object is for a query that's within a stored procedure.

Sure.

CREATE TABLE TestingDates (

ID INT IDENTITY PRIMARY KEY,

Starts DATETIME,

Ends DATETIME

)

ALTER TABLE TestingDates ADD CONSTRAINT ck_DateCheck CHECK (Starts <= Ends)

INSERT INTO TestingDates (Starts, Ends)

VALUES (GETDATE(), GETDATE()+1) -- succeeds

INSERT INTO TestingDates...

In sysobjects, the uid column will be different. You can join to sysusers to get the name of the table owner

I wouldn't think so. As far as index selectivity's concerned, 1 million nulls or 1 million 0s selects much the same.

I'm not sure about nulls, but I think that a...

Restore your transaction log backups, starting with the one you took right after the full backup on the 25th. Restore them in order, with the NoRecovery option and with the...

A full database backup contains the contents of the DB at the point in time...