Viewing 15 posts - 2,701 through 2,715 (of 7,484 total)
Jeff Moden (2/21/2014)
SQLRNNR (2/21/2014)
jcrawf02 (2/21/2014)
February 21, 2014 at 12:18 pm
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...
February 21, 2014 at 12:10 pm
stephen.long 56048 (2/20/2014)
February 20, 2014 at 12:01 pm
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...
February 20, 2014 at 10:46 am
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...
February 19, 2014 at 6:26 am
Nice question.
I sat there for five minutes staring at it looking for the catch, before deciding that there wasn't one.
February 19, 2014 at 5:58 am
Luis Cazares (2/18/2014)
Steve Jones - SSC Editor (2/18/2014)
Ed Wagner (2/17/2014)
EL Jerry (2/17/2014)
Have you noticed the community has grown over 1.7M members?
Congratulations to Steve et al who founded...
February 18, 2014 at 7:11 pm
ashu.sajwan (2/18/2014)
Then what's good approach to do resolve this issue in sql server 2005?suggestion pls.
Unless there's a large number of NULLs (many times more entries in the column are NULL...
February 18, 2014 at 11:29 am
rodjkidd (2/18/2014)
a) I knew what was going on
b) Adding value to the...
February 18, 2014 at 6:54 am
Thomas Abraham (2/18/2014)
Isn't this a repeat of the question Steve posted 02/22/2012?? (Or at least the first part of Steve's question.)
Yes.
The discussion is a bit less interesting this time, though.
February 18, 2014 at 6:45 am
Ed Wagner (2/18/2014)
BWFC (2/18/2014)
SQLRNNR (2/17/2014)
Ed Wagner (2/17/2014)
Revenant (2/17/2014)
TomThomson (2/17/2014)
SQLRNNR (2/17/2014)
hairdog
dachshund
Sausage
schnitzel
Noodles
Pasta
Arrival Theorem (Poisson arrivals see time averages)
February 18, 2014 at 6:07 am
GilaMonster (2/18/2014)
Yup, that's it. Should be less overhead than an indexed view.
The snag is that it only works if you are lucky. Neither "it'll go faster but it may...
February 18, 2014 at 5:54 am
GilaMonster (2/18/2014)
Why clustered? This isn't typically where you would put the clustered index.
not clustered isn't a sensible option - a view has to have a clustered unique index before it...
February 18, 2014 at 5:30 am
Jeff Moden (2/17/2014)
Here's the plain link for the "file path reference approach".http://www.rasteredge.com/how-to/vb-net-imaging/open-save-file/
Ugh! :sick:
Couldn't you point to something that doesn't reference that abominable language VB? Can't RasterEdge Image SDK...
February 18, 2014 at 4:00 am
Koen Verbeeck (2/18/2014)
Hany Helmy (2/18/2014)
February 18, 2014 at 3:36 am
Viewing 15 posts - 2,701 through 2,715 (of 7,484 total)