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

jarid you could streamline the use even further if you put that in a stored procedure.

for example, I created a proc sp_GetDDL which returns the table structure of a table,...

if you've got the linked server up and running, that's 99% of it;

the rest is just syntax.

something like this is how you update from another table...and it doesn't matter if...