Don't name the constraint, as constraint names have to be unique.

ALTER TABLE dbo.test

ADD PRIMARY KEY CLUSTERED

( ReportRunTime, VisitID, SourceID, BaseID, OccurrenceSeqID, [DateTime], SeqID, QueryID, Response );

SELECT MONTH(Anniversaire) AS MM, DAY(Anniversaire) AS DD, Anniversaire, Prenom, Nom

FROM Tbl_RH_Pharmacie

WHERE (Anniversaire IS NOT NULL AND Anniversaire <> '') AND

1 = CASE WHEN...

You can't back up a log in simple recovery model (because the log would...

I believe SQL will compile all statements when the proc is loaded, so there's overhead there.

If you do this, though, at least make it as efficient as possible by using...

Since the default db is master, often things get built there by accident. You can create a DDL trigger to prevent that from happening again, if you want.

You can...

Make sure the log file has enough unused space to handle the bulk-insert logging before the insert starts. Dynamically growing the log file is an extremely slow process. ...

sum(case when (coalesce(a.status,ae.status) = 'A')

and (ae.excuse is null or ae.excuse = 'U')

...

The MSsubscriptions table has a column:

subscription_type

that identifies which it is.

SELECT *, DATEADD(HOUR, HourPlanned, DATEADD(DAY, DATEDIFF(DAY, 0, lnDateDone), 0))

FROM (

SELECT lnDateDone = '2014-04-09 13:22:31.544', HourPlanned = 14

) AS test_data

Edit: Corrected calcs and added test data.

I think (hopefully) all the conditions except a NULL (incoming) @Gender can be handled by:

(@Seeking IS NULL OR p.Gender = @Seeking) AND p.Seeking = @Gender

What "matches" do you want to...

Don't add an id as a PK, just use MsgDate and MsgTime as the (nonunique) clustering keys. That's how you'll lookup and process this data anyway.

I can't imagine how...

I'd consider clustering by only customer_id, unless the selects themselves order by both customer_id and thing_id.

I'd also use a lower fillfactor for these indexes, maybe starting somewhere between 80% and...

Do you really search this table by NoteType without specifying a CreateDate range? Could you specify CreateDate range?

This table should be clustered on CreateDate, not on identity; this is...

CELKO (4/24/2015)

Of course there is, since you can cast the number to a string any time you want, although you'd never need to compute a check digit that's already...

You could also do searches for similar jobs and see what their job descriptions look like. After all, one of the greatest documents in history, the "Declaration of Independence",...