Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,701 through 20,715 (of 59,072 total)

RE: Need Ammunition for Developers Doing Select *'s

There's absolutely no sense in arguing with people that obviously know it all. The "developer" that retorted "Prove it" is absolutely spot on whether I agree with his use...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 15, 2015 at 8:53 pm

#1798402
RE: Not Only a Meeting of Minds, but of Open Minds.

Thanks for the encouragement, Phil, but I'd rather stick to the technical articles and let the code do the talking. It's also much more fun to follow your very...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 15, 2015 at 8:18 pm

#1798400
RE: Rounding is Inconsistent

I don't have an example at hand but I've seen the same sorts of problems with DECIMAL, as well.
As for FLOAT being inaccurate, try dividing 1 by 3 using decimal...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 15, 2015 at 8:02 pm

#1798399
RE: unusual syntax - is this deprecated

Oddly enough, I've seen the "query builder" generate such code a whole lot in my early days and it worked just fine. There are places where it doesn't work....
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 15, 2015 at 7:59 pm

#1798398
RE: unusual syntax - is this deprecated

TomThomson (5/15/2015)
Grant Fritchey (5/15/2015)
GilaMonster (5/14/2015)
dwain.c (5/14/2015)
I gotta wonder what the ANSI standards say about this one!
Perfectly legal afaik.
It's legal. I've seen this before. List all the tables and then all...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 15, 2015 at 7:56 pm

#1798396
RE: Want to create all procedures located in a folder one by one and creating/saving output file in a folder.

Just use the old DOS "FOR" command to cycle through your files and call SQLCMD for each file. Look for it on the Internet.
You wouldn't like the way that...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 15, 2015 at 7:52 pm

#1798395
RE: You know you're having a slow day when...

yb751 (5/15/2015)
Brandie Tarvin (5/11/2015)
You should turn that into an article, if you haven't already. Lots of people would be interested in your journey.
I hadn't thought of that. It's a...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 15, 2015 at 7:46 pm

#1798394
RE: BCP from one table to another

Gregg Dave (5/15/2015)
have done inserting into files using BCP ,but is it really possible to bcp data from one table to another?
No... not directly. You would have to BCP...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 15, 2015 at 6:14 pm

#1798389
RE: BCP from one table to another

Gregg Dave (5/15/2015)
Eirikur Eiriksson (5/15/2015)
Gregg Dave (5/15/2015)
have done inserting into files using BCP ,but is it really possible to bcp data from one table to another?
Quick question, why would you...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 15, 2015 at 6:12 pm

#1798388
RE: Restoring Diff

matthew.hudsonbryan (5/15/2015)
Hi,
I was going through some MeasureUp questions and one of the answers stumped me.
The sequence to restore for the answer to a question was.
Perform tail-log backup.
Restore Sunday 2:00 A.M....
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 15, 2015 at 6:09 pm

#1798386
RE: Restoring Diff

matthew.hudsonbryan (5/15/2015)
Thank you. I thought I was going mad 🙂
Heh... that's probably still true but not because of this. 😀
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 15, 2015 at 6:08 pm

#1798385
RE: Cursors for SQl server

bpsavi123 (5/15/2015)
Hi,
i have task where i need to update the 2 columns from 2 different tables.I need to get one column from one table and update to the other table.If...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 15, 2015 at 6:06 pm

#1798384
RE: Here are some SQL Server Interview Questions

Lynn Pettis (5/15/2015)
Jeff Moden (5/14/2015)
Luis Cazares (5/14/2015)
You receive a late call during the night to inform you that the server is down and must be working correctly before everyone arrives...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 15, 2015 at 6:04 pm

#1798383
RE: Here are some SQL Server Interview Questions

Michael L John (5/15/2015)
Interviewer: If your database was a country, what country would it be?
My answer: North Korea, because it will be run by a dictator!
It wouldn't be a country......
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 15, 2015 at 6:01 pm

#1798382
RE: Here are some SQL Server Interview Questions

Jason A. Long (5/15/2015)
Next question:
How would you describe the differences between being "Loyal" to a company and "Dedicated" to a company? Heh... The answer will be provided either at...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 15, 2015 at 6:00 pm

#1798381

Viewing 15 posts - 20,701 through 20,715 (of 59,072 total)