SQL Server queries are not "deterministic" in terms of their execution plans.

First thing I'd do is rewrite that query a bit, then I'd worry about different execution plans AFTER I'd...

For accurate counts of weekdays, I HIGHLY recommend a calendar table. That way, you can include holidays, etc.

create table Calendar (

Date datetime primary key,

constraint CK_Date_NoTime

check (Date...

Not precisely. Are you querying the view, or connecting the client directly to the view?

If querying the view, yes, the Order By (or lack thereof) of the calling query...

Welllllllll .... the post is certainly appropos of the title ....

As always, I'm going to recommend not doing pivoting in the database. Let a front-end application do it for you. They're better at it. SQL Server Reporting...

I'd go with bigint rather than numeric for an ID column. If you somehow find you need more rows than bigint can deal with, you're probably better off with...

Order By works in views in SQL 2005. Are you using column aliases in the Select clause? Do you have two columns in the view with the same...

Try these:

;with MaxRain (DT, MID, Rainfall) as -- Max Rainfall per Day

(select date_taken, main_id, max(daily_rainfall)

from dbo.SEL

group by date_taken, main_id)

select Date_Taken, Main_ID, Time, Rainfall

from dbo.SEL

inner join MaxRain

on date_taken = dt

and main_id...

This is a duplicate thread. Thread of same name and question in Administering forum. Please don't double-post.

I don't understand your request. Are you asking about a trigger for when you attach a database?

The key to Michael's answer is "scope_identity()". Look at that one in Books Online. Very useful tool.

To attach a database, check out Create Database in Books Online. There's a "for attach" argument you can use.

Easily-managed row-level security would be nice. I've generally ended up using hierarchies of accounts for that kind of thing.

I haven't dug into service broker at all. It's not...

margo (6/9/2008)

---

A nice summary, always useful to check what we're doing with what others are saying.

One thing I would add to the downside of "passive" audits... the cost of keeping...

CPU time is how much time was spent by the CPU (or CPUs). Total time is how long it took from start to finish.

For example, if it takes 1...