so you want to send 100 individualized emails, each with the same (or different?) attachment?(hint: cursor)

or do you want to send a single email, with 100 To:/CC:/BCC:/ and the same...

try using a CASE statement to filter out the rows that have a zero denominator

something like this is my first guess:

CASE

WHEN DATEDIFF(SECOND,dr.startTime,dr.endTime) = 0

THEN 0

...

Alex, you posted the estimated execution plan, which shows a nice expected clustered index scan; i think we need the actual execution plan, where it's being returned slowly via SSMS...

in that case, baring slow network issues, i'd think the first thing is to look at the execution plan, and the real query;

anything from parameter sniffing, out of date statistics,...

marlon i looked at this page, and osql @ the cmd prompt, and this is what i think:

i tried to put comments in, i hope the comment start chars are...

I think SQLHeap has got the core issue. linked servers have performance issues you need to be aware of.

try these two things on the server witht eh linked server on...

raotor (12/10/2012)

---

Hello,

I'm sure this is an easy one for all you knowledgeable people out there.

How can I find the modification date of a database or table?

BTW, by modification date, I...

great job providing sample data!

edit because another post by a different user posted the Identical xml, I've removed my post because it looks like homework

http://www.sqlservercentral.com/Forums/Topic1394445-392-1.aspx

And Another Edit:

oops ok since...

rama.mathanmohan (12/10/2012)

---

Is the rollover option will limit the size of the files used in total with out stopping the trace from collecting data ? Please note, Since this is...

sure ; setting up database mail is very straightforward.

a query that uses an EXISTS clause can decide whether to send or not.

from there, you need to decide if it's...

since it comes from EF, i assume you cannot fix the query, but must instead fix the tables and indexes to improve the query?

it's a big job, you need clustered...

you will hear this about a million times, but the number one rule is to store datetimes as datatimes; not as strings or bigints or any other datatype;

when you don't...

what you posted is the syntax for Oracle, I believe.

SQl server is like this:

alter table TableName

add constraint df_ConstraintNAme

default 'SANDNES' for [ColumnName]

based on the first post, here's the table, but i think that's already been created by an existing select statement;

we need data like this to generate a working query to...

well if they are going to create views, then they need at least two more permissions don't they?

VIEW DEFINITION, so they can see other table structures,and db_datareader (which you...