Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,851 through 8,865 (of 59,091 total)

Reply To: Questions on Degree programs

p.s. The essential key for me was learning how to make a shedload of test data in virtually any form I needed it. When it come to performance, you need...
--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)

August 13, 2019 at 2:15 pm

#3671031
Reply To: Questions on Degree programs

Totally agree with Grant. I don't care for the certification alphabet soup a lot of people have after their names because too many of them have gamed the system 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)

August 13, 2019 at 2:03 pm

#3671024
Reply To: Give Up on Natural Primary Keys

That's all good but you made it sound like you were suggesting that keys (in general) were allowed to be mutable. There are some rare cases where AKs (Alternate Keys)...
--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)

August 13, 2019 at 6:47 am

#3670927
Reply To: Get an Output from a Stored Procedure

Ok... my previous post with the code and some example code on how to use it are done. Read the comments in the demo code near the end.

--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)

August 13, 2019 at 6:26 am

#3670925
Reply To: Get an Output from a Stored Procedure

Oscar_Boots wrote:
Thanks Jeff,
I'll have a read & give it a try.
Thanks again
I hit submit by accident. ~~I left a message at the top of the previous post. Please have 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)

August 13, 2019 at 6:08 am

#3670922
Reply To: Get an Output from a Stored Procedure

Ok, first you need to follow the link to the "fnTally" function in my signature lines below this post. It's a high performance iTVF (inline Table Valued Fuction) that we...
--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)

August 13, 2019 at 5:52 am

#3670920
Reply To: Get an Output from a Stored Procedure

First of all, using a loop in a stored procedure is one of the slowest things you can do. Only an rCTE (recursive CTE) would make it slower.
My suggestion is...
--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)

August 13, 2019 at 5:36 am

#3670916
Reply To: How does SQL determine which column a table level check constraint is applied to

Remember that it's a script and not an article. It's not designed to teach either how it works or potential usage. It's simply a script in a repository for people...
--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)

August 13, 2019 at 3:18 am

#3670909
Reply To: Questions on Degree programs

A Microsoft certification may be worth more if that's what you want to cut your teeth on. Combine that with an internship to get some "experience" documented on your resume...
--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)

August 13, 2019 at 3:15 am

#3670908
Reply To: Moving a Table

I've never had to do such a thing before and so I have to admit that I had to look this one up. Learned something new. Thanks for the great...
--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)

August 13, 2019 at 1:33 am

#3670897
Reply To: Basics to loading data

Phil Parkin wrote:
below86 wrote:
IMHO, you are on the right path. I'm currently doing exactly what you described. Importing flat, delimited files to a 'staging' table where all fields are defined as...
--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)

August 12, 2019 at 10:49 pm

#3670854
Reply To: Give Up on Natural Primary Keys

No. No duplicate login names or account numbers and, in many cases, no reuse of such things either because that would actually entail a dupe even if all but one...
--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)

August 12, 2019 at 10:43 pm

#3670852
Reply To: How does SQL determine which column a table level check constraint is applied to

Thanks for the feedback, Michael.
My fnTally script was published. I have a link for it in my signature line below.
--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)

August 12, 2019 at 10:38 pm

#3670851
Reply To: Modern Datatime Addition

Heh... technically, the question answer is still incorrect because you CAN add dates and times... if the answer was that you cannot add DATETIME2s, then the answer would have been...
--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)

August 12, 2019 at 6:33 pm

#3670808
Reply To: Give Up on Natural Primary Keys

nova wrote:
Jeff Moden wrote:
The login name can change. It's not an immutable item. And, I disagree... a "Business Key" is not the same as a "Natural Key".
Agreed that login name isn't...
--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)

August 12, 2019 at 6:29 pm

#3670802

Viewing 15 posts - 8,851 through 8,865 (of 59,091 total)