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...

almost identical, only some fucntion names are different:

--SUBSTR(TARGET_ID,6,INSTR(SUBSTR(TARGET_ID,6,LENGTH(TARGET_ID)),'.',(-1))-1

SELECT SUBSTRING(TARGET_ID,6,CHARINDEX(SUBSTRING(TARGET_ID,6,LEN(TARGET_ID)),'.',(-1))-1)

look in the scripts section; there's lots of examples where somone has wrapped sp_spacedused in a cursor,

For an example of using sys.dm_db_partition_stats that gail mentioned, if you pick...

sp_spacedused 'Tablename' is pretty good for at a glance info.

sp_spaceused 'MyTable'

/*

name rows reserved data index_size ...

itvfs are applied once to the set, and not against each row.

an inline TVF will always out perform a multi line TVF;

ITVF's are really just a special JOIN type in...