Viewing 15 posts - 541 through 555 (of 19,564 total)
Lynn Pettis (4/6/2016)
Ed Wagner (4/6/2016)
Phil Parkin (4/6/2016)
Lynn Pettis (4/5/2016)
And now the attitude arrives.Check out the most recent 'I am proficient ...' comment. I nearly regurgitated my breakfast cereal.
Yeah, that was...
April 6, 2016 at 2:26 pm
Mighty (4/6/2016)
According to this article a temporary table can be partitioned:http://jasonbrimhall.info/2014/05/23/can-you-partition-a-temporary-table/.
So "Temporary tables cannot be partitioned" is not a limitation.
Thanks Mighty, morlindk and Steve for the call-outs to the...
April 6, 2016 at 1:53 pm
Luis Cazares (4/6/2016)
Koen Verbeeck (4/6/2016)
Boooo, temp tables can be partitioned.
So I guess BOL should be corrected?
You can create local and global temporary tables. Local temporary tables are visible only...
April 6, 2016 at 1:40 pm
haha - SQL Prompt helps give this one away far too easily.
April 5, 2016 at 3:23 pm
Welsh Corgi (4/5/2016)
April 5, 2016 at 12:18 pm
Grant Fritchey (4/5/2016)
SQLRNNR (4/5/2016)
Grant Fritchey (4/5/2016)
Phil Parkin (4/5/2016)
Gail and I are gamely persevering with this one. I think my pressure limit has been reached now, though.
Oh god...
"The delete works sometimes"
......
April 5, 2016 at 11:31 am
Ed Wagner (4/5/2016)
Grant Fritchey (4/5/2016)
SQLRNNR (4/5/2016)
Grant Fritchey (4/5/2016)
Phil Parkin (4/5/2016)
Gail and I are gamely persevering with this one. I think my pressure limit has been reached now, though.
Oh god...
"The delete...
April 5, 2016 at 11:23 am
Grant Fritchey (4/5/2016)
Phil Parkin (4/5/2016)
Gail and I are gamely persevering with this one. I think my pressure limit has been reached now, though.
Oh god...
"The delete works sometimes"
... Surely, please, tell...
April 5, 2016 at 11:05 am
Welsh Corgi (4/5/2016)
ok, I dropped the constraint but sometimes the error message does not include the table name.
Can you recreate the scenario where the error message does not include the...
April 5, 2016 at 10:59 am
Chad Crawford (4/4/2016)
SQLRNNR (4/4/2016)
Brandie Tarvin (4/4/2016)
jasona.work (4/4/2016)
Brandie Tarvin (4/4/2016)
April 4, 2016 at 3:57 pm
Brandie Tarvin (4/4/2016)
jasona.work (4/4/2016)
Brandie Tarvin (4/4/2016)
April 4, 2016 at 1:37 pm
crookj (4/1/2016)
DonlSimpson (4/1/2016)
TomThomson (4/1/2016)
Ed Wagner (4/1/2016)
SQLRNNR (4/1/2016)
conversationListen
hear
Fear
Dread
Locks
You know those things that mean contention on resources and a winner is chosen while the other becomes a victim?
April 1, 2016 at 9:36 pm
Ed Wagner (4/1/2016)
TomThomson (4/1/2016)
SQLRNNR (4/1/2016)
Why isn't the correct answer Hekaton?
It was when I picked it, has it changed since?
Since then some people have picked the mountain, so all the wrong...
April 1, 2016 at 9:26 pm
Steve Jones - SSC Editor (4/1/2016)
Use the Oh-En-Oh-Eff-Eff switch.
Its not the
Eff-En-Eff-En-Oh-En
switch?
April 1, 2016 at 11:00 am
Viewing 15 posts - 541 through 555 (of 19,564 total)