Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,731 through 20,745 (of 59,098 total)

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
RE: Here are some SQL Server Interview Questions

TomThomson (5/15/2015)
David Webb-CDS (5/15/2015)
Your customer comes to you and says the query he has run daily for the last two years is suddenly taking hours instead of seconds. 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 5:59 pm

#1798380
RE: Here are some SQL Server Interview Questions

Stephanie Giovannini (5/15/2015)
Real interview question that I asked during a tech screen for an entry-level programmer position:
Q: Where do you see yourself in 5 years?
My answer to the interviewer: ...
--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 12:50 pm

#1798306
RE: Here are some SQL Server Interview Questions

pietlinden (5/14/2015)
Best milkshakes ever. I don't like that boss very much.
That and a grilled cheese sandwich. I want to see his lips swell up to match the size...
--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 14, 2015 at 8:22 pm

#1798062
RE: Here are some SQL Server Interview Questions

This one is actually true.
Me, the interviewer: As the Lead Developer on this project, we're very interested in someone that understands and can easily do conversions between various numbering...
--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 14, 2015 at 8:09 pm

#1798061

Viewing 15 posts - 20,731 through 20,745 (of 59,098 total)