Viewing 15 posts - 421 through 435 (of 2,838 total)
Ha, wrote and submitted an article, but for the wrong duplicates problem. I'll work on this one now.
Sorry!
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
September 24, 2013 at 8:33 am
Greg Edwards-268690 (9/24/2013)
Jeff Moden (9/23/2013)
dwain.c (9/23/2013)
Grant Fritchey (9/23/2013)
Careful there! NSA monitoring in progress.
Raccoons knocked it off the shelf in the garage in the dead of winter and the PVC...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
September 24, 2013 at 7:41 am
Jeff Moden (9/20/2013)
Are you good folks saying that any form of SELECT/INTO is bad? If so, why?
I don't know how the resulting columns are typed. I did a cursory...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
September 20, 2013 at 7:12 am
Greg Edwards-268690 (9/19/2013)
Stefan Krzywicki (9/19/2013)
Greg Edwards-268690 (9/19/2013)
venoym (9/19/2013)
andrew gothard (9/19/2013)
Stefan Krzywicki (9/18/2013)
GilaMonster (9/18/2013)
L' Eomot Inversé (9/18/2013)
Don't need to is surely an understatement: you are not allowed to, I think?
If you...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
September 19, 2013 at 11:34 am
Greg Edwards-268690 (9/19/2013)
venoym (9/19/2013)
andrew gothard (9/19/2013)
Stefan Krzywicki (9/18/2013)
GilaMonster (9/18/2013)
L' Eomot Inversé (9/18/2013)
Don't need to is surely an understatement: you are not allowed to, I think?
If you mean the SELECT *...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
September 19, 2013 at 7:18 am
Jack Corbett (9/18/2013)
Stefan Krzywicki (9/18/2013)
Koen Verbeeck (9/18/2013)
Stefan Krzywicki (9/18/2013)
SELECT * INTO #A1 FROM Table
SELECT * INTO #B1 FROM #A1
in production...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
September 18, 2013 at 6:20 pm
GilaMonster (9/18/2013)
L' Eomot Inversé (9/18/2013)
Don't need to is surely an understatement: you are not allowed to, I think?
If you mean the SELECT * INTO, unfortunately that's allowed. I've cleaned so...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
September 18, 2013 at 6:19 pm
Koen Verbeeck (9/18/2013)
Stefan Krzywicki (9/18/2013)
SELECT * INTO #A1 FROM Table
SELECT * INTO #B1 FROM #A1
in production code? #A1 & #B1 are also...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
September 18, 2013 at 1:43 pm
Am I wrong in saying we shouldn't be using
SELECT * INTO #A1 FROM Table
SELECT * INTO #B1 FROM #A1
in production code? #A1 & #B1 are also never defined explicitly.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
September 18, 2013 at 11:53 am
bitbucket-25253 (9/10/2013)
Ed Wagner (9/10/2013)
SQLRNNR (9/10/2013)
Brandie Tarvin (9/10/2013)
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
September 10, 2013 at 9:21 am
paul.knibbs (9/10/2013)
SQLRNNR (9/10/2013)
What are 3 of the required parameters for DBCC Timewarp?
What are 7 of the optional parameters?
This is a trick question, right? Everyone knows that DBCC TIMEWARP doesn't take...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
September 10, 2013 at 9:00 am
SQLRNNR (9/5/2013)
Stefan Krzywicki (9/5/2013)
Steve Jones - SSC Editor (9/5/2013)
http://www.liveleak.com/view?i=424_1378224156Let's stick Jeff in this interview 😉
Item not found?
There was an extra br in Steve's url
Yeah, I'd either have gotten the job...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
September 5, 2013 at 3:04 pm
Steve Jones - SSC Editor (9/5/2013)
http://www.liveleak.com/view?i=424_1378224156Let's stick Jeff in this interview 😉
Item not found?
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
September 5, 2013 at 1:16 pm
Steve Jones - SSC Editor (9/4/2013)
Please reply to one at a time. It's easy to overcommit, but hard to actually write. Believe...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
September 4, 2013 at 11:50 am
I can do this one.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
September 4, 2013 at 11:17 am
Viewing 15 posts - 421 through 435 (of 2,838 total)