The read_only property of the model database has no effect on newly created databases, however created. Whatever the model value is, the value for database created by restore is...

stephen.long 56048 (2/20/2014)

---

On multiple choice questions like this, it would be best if they did not say "(Select 2)", because four of the options will "use up" those two options:...

My feeling about software patents is that they are a total disaster and will continue to be a total disaster until the world's patent offices all take to rejecting patents...

An alternative way to using group by is simply to put the selection into a subquery:

select name, TABLE_SCHEMA, TABLE_NAME,

ROW_NUMBER() over (order by TABLE_SCHEMA,TABLE_NAME) as RN

FROM...

Nice question.

I sat there for five minutes staring at it looking for the catch, before deciding that there wasn't one.

Luis Cazares (2/18/2014)

---

Steve Jones - SSC Editor (2/18/2014)

---

Ed Wagner (2/17/2014)

---

EL Jerry (2/17/2014)

---

G'Day Everyone!!

Have you noticed the community has grown over 1.7M members?

Congratulations to Steve et al who founded...

Unless there's a large number of NULLs (many times more entries in the column are NULL...

rodjkidd (2/18/2014)

---

I've been at my current gig now for nearly 11 months, and I finally was in a meeting where

a) I knew what was going on

b) Adding value to the...

Yes.

The discussion is a bit less interesting this time, though.

Arrival Theorem (Poisson arrivals see time averages)

The snag is that it only works if you are lucky. Neither "it'll go faster but it may...

not clustered isn't a sensible option - a view has to have a clustered unique index before it...

Ugh! :sick:

Couldn't you point to something that doesn't reference that abominable language VB? Can't RasterEdge Image SDK...

Koen Verbeeck (2/18/2014)

---

Hany Helmy (2/18/2014)

---

Just a simple & basic info to share: "if you changed the model database to Read-Only mode; then any newly created database will be in Read-Only...

ashu.sajwan (2/17/2014)

---

...

col1 varchar(Max) NULL,

...

CREATE UNIQUE CLUSTERED INDEX cuq

ON dbo.ExampleUnique (col1);

It shows error: Column 'col1' in table 'dbo.ExampleUnique' is of a type that is...