the model database, or any database for that matter, does not contain within itself it's own storage location...that is kept in master....the model database is used for the default schema...

just a follow up; i got the estimated execution plans for a join against two of my big tables using the commands below, and they had both identical estimated execution...

*= got deprecated in sql2005, so i'd suggest switching over to the standard format; it's more readable, and is also ANSI compliant, so you can use the same SQl statement...

i think in this case, you would want to raise an error if the value being tested('xxx') was not really numeric; there was another thread on this same subject, and...

here's another way, note that this does not order the triggers in dependancy order, it just lists them.

select parent_objects.name,

       trigger_sysobjects.name,

syscomments.Text

 from sysobjects trigger_sysobjects

inner join sysobjects parent_objects on parent_objects.id=  trigger_sysobjects.parent_obj

inner join syscomments...

this sounds like an error returned from a program, not a SQL server error. you'll need to review the source code of the application raising the error.

you might want to...

emabarrassing...my home server crashed, and I can't seem to locate a copy of this that I created. If anyone still has it, could you forward me a copy so I...

it's the index seek you would worry about when it comes to sorting.

If a SQl statement says WHERE PK='2002', the sorting is used in the PK's index to quickly lookup...

situations like this is where I switch from doing everything in TSQL, to grabbing the data in .NET or vb6, where the String variable type does not have this limitation;

I'll...

if the fields are indexed, then technically the CHAR fields would take up more space, which would mean less data per page of memory; more data per page is better,...

sorry about the confusion.

in my sample, these two tables are the same: #TESTDATA = gdb_01_4_test

i didn't have the data, so i had to create it to confirm that my sample...

there was a post today referencing "Death By SQL", where the user slowly kills himself by separating date and time, when they can be stored in the same field....I think...

SELECT DISTINCT PolicyNumber

from GE_Transaction

WHERE Status='A' AND MonthReported < DATEADD(year,10,EffectiveDate)

i reversed the argument;

i don't know that MonthReported is a valid date, you'll have to evaluate with data to see if...

SELECT DISTINCT POLICYNUMBER WHERE STATUS='A' AND MonthReported < DATEADD(year,EffectiveDate,10)

based on your example data, I assumed that Flight 38 for example might have more records added at any time; because of that, if I created another table with the...