Jeff Moden

Forum Replies Created

Viewing 15 posts - 16,231 through 16,245 (of 59,101 total)

RE: Survival of Human being in this world

karthik M (11/29/2016)
I am wondering about director's prediction (2022) of the movie which you mentioned...
No Need to wait till 2022...People already started to do anything for Money..They want to enjoy...
--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)

November 29, 2016 at 8:32 am

#1914978
RE: Stairway to Power BI

karthik M (11/29/2016)
All,
I am looking for stairway to Power BI kind of articles. I have read few articles in simple-talk although it explains about some specific areas.
So look in the...
--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)

November 29, 2016 at 8:25 am

#1914971
RE: Recursion to iterate function

sgmunson (11/28/2016)
Jeff Moden (11/28/2016)
I hate double postings for this very reason. :crazy: Thanks for the heads up. I left my spare CRAY somewhere and forgot where I put...
--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)

November 28, 2016 at 6:02 pm

#1914848
RE: Using OpenRowset to Insert Data

Hopefully, that's not a real UID and PW that you used in your post.
--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)

November 28, 2016 at 5:27 pm

#1914847
RE: how to retrieve numbers from a string

sqlinterset (11/21/2016)
i dont have it in my sql library ..
You should add it. It comes in real handy. But, since you're using 2016, you should be able...
--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)

November 28, 2016 at 10:29 am

#1914788
RE: What is Normal?

RonKyle (11/28/2016)
You must have successfully identified business keys before.
So it must be easy for you to show couple of examples (from your experience) where natural keys were just right to...
--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)

November 28, 2016 at 10:05 am

#1914781
RE: Recursion to iterate function

I hate double postings for this very reason. :crazy: Thanks for the heads up. I left my spare CRAY somewhere and forgot where I put it so I...
--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)

November 28, 2016 at 10:02 am

#1914779
RE: Pivot Table Help

ranjith.sivanathan (11/28/2016)
Thanks You.
What about if I have Price1, Price2 and price3? Should use the cross tab query breakdown the price.
Use the CROSS TAB query Eirikur posted and add the extra...
--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)

November 28, 2016 at 6:55 am

#1914709
RE: Recursion to iterate function

urbanromio2 (11/26/2016)
Some one help me to convert the recursive method to iterative function.
To be honest, I just don't have the time to try to science out what your undocumented...
--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)

November 28, 2016 at 6:51 am

#1914705
RE: Free eBook from PacktPub: Getting Started with PowerShell - TODAY ONLY!!!

Awesome! Thanks for the heads-up on this one. It even has a section on calls to the incredible WMI functionality that's been available at the DOS level for...
--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)

November 28, 2016 at 6:30 am

#1914701
RE: User unable to execute OpenRowset without Error

JasonClark (11/27/2016)
When we are running SQL Server Agent job that is not owned by a system admin account, SQL Server Agent runs SETUSER as a owner of the job. And...
--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)

November 28, 2016 at 6:16 am

#1914696
RE: File system task - illegal characters in path

Jay@Work (11/27/2016)
[File System Task] Error: An error occurred with the following error message: "Illegal characters in path.".
Not sure what I'm doing wrong here.
Basically I call (my own) webservice and load...
--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)

November 28, 2016 at 6:10 am

#1914695
RE: moving system databases

A really good article was written by Greg Robidoux a while back. It's still mostly appropriate.
Move all SQL Server system databases at one time[/url]
--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)

November 28, 2016 at 6:04 am

#1914694
RE: Survival of Human being in this world

The only way to fix the problems you speak of is for people to stop breeding like the irresponsible rabbits the general population appears to be. It's a bit...
--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)

November 28, 2016 at 5:48 am

#1914689
RE: SQL Server 2016 Multinode Scale Out Polybase with hadoop (hive)

If you look under "Contacts" on the vertical menu at the left of this screen, you'll find the best way to contact the folks for article ideas is to send...
--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)

November 28, 2016 at 5:27 am

#1914686

Viewing 15 posts - 16,231 through 16,245 (of 59,101 total)