Jeff Moden

Forum Replies Created

Viewing 15 posts - 16,201 through 16,215 (of 59,067 total)

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
RE: What is Normal?

David.Poole (11/28/2016)
Jeff Moden (11/26/2016)
David.Poole (11/26/2016)
Storing guids in things like RedShift or Vertica is fun. Not only do you have to store them as CHAR(36) but by definition they are...
--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:21 am

#1914684
RE: Float vs Decimal?

Same here, Magoo. Absolutely agree. The problem is that most people won't be aware and will write the code in the "extraordinary proof" manner.
I'll also state that they...
--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 27, 2016 at 10:59 pm

#1914656
RE: OpenRowset for CSV File

joshua 15769 (11/27/2016)
If I could only know how to check the number of rows in this kind of CSV, that would be great!
It's easy. Don't set FIRSTROW 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 27, 2016 at 10:56 pm

#1914655
RE: What is Normal?

dalland (11/27/2016)
Phil Factor (11/22/2016)
There's nothing that says a table can't have more than one unique index on it.
it certainly can. It is no crime but it is 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)

November 27, 2016 at 2:01 pm

#1914640

Viewing 15 posts - 16,201 through 16,215 (of 59,067 total)