Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,286 through 9,300 (of 59,091 total)

Reply To: Converting Substring to DateTime - extra eyes please

Are you the one responsible for the backups or is that someone else? And I'm not sure that max retention (I'm actually thinking about backup expiration dates here and could...
--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 16, 2019 at 10:14 pm

#3644386
Reply To: Need advice using Identity Running Number as Primary Key

@Below86,
As Grant stated, it's a huge subject, so I'll just limit (at least for now) most of this to a "User" table similar to what the OP asked about.
First, 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)

May 16, 2019 at 10:01 pm

#3644383
Reply To: Are the posted questions getting worse?

Brandie Tarvin wrote:
Jeff Moden wrote:
Totally freakin' awesome, Brandi. Congratulations! I share Grant's enthusiasm here... you'll knock'em dead! Just curious... are you going to cover the flip side of the "Imposter Syndrome"...
--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 16, 2019 at 7:42 pm

#3644337
Reply To: Capture SQL jobs running longer than x minutes

Feivel wrote:
Sue_H wrote:
You can try playing with something like the following to grab jobs that were successful and just look at the duration of the job (instead of each job...
--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 16, 2019 at 7:01 pm

#3644327
Reply To: Are the posted questions getting worse?

Brandie Tarvin wrote:
So it's official. I've been accepted to Grace Hopper 2019 in Orlando to talk about "Imposter Syndrome: Are You Ready To Mentor". WHEEE... Now I have to overcome my...
--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 16, 2019 at 1:50 pm

#3644206
Reply To: Are the posted questions getting worse?

Brandie Tarvin wrote:
RE: Synonyms and 3 / 4 part naming conventions, is this just a preference or are you noticing performance issues? And in the end, why does it matter? 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 16, 2019 at 1:41 pm

#3644203
Reply To: Need advice using Identity Running Number as Primary Key

As a bit of a sidebar, there's no way that I'd keep history/versioning in the same table as the current data. Nor would I use CDC for this table. Temporal...
--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 16, 2019 at 12:33 pm

#3644167
Reply To: Need advice using Identity Running Number as Primary Key

Grant Fritchey wrote:
Oooh, this is a HUGE topic. Posting into comments in a thread is not going to cover everything. You need to look at a completely different database design. Here's...
--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 16, 2019 at 12:17 pm

#3644165
Reply To: Need advice using Identity Running Number as Primary Key

Grant Fritchey wrote:
Here's the bad news. You need both. If logically the UserName value is the business defined identifying value, you should have a unique constraint on it. This is what...
--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 16, 2019 at 1:39 am

#3644080
Reply To: Are the posted questions getting worse?

Thom A wrote:
Jeff Moden wrote:
I can't find any documentation on it because the official 2019 deprecated features hasn't been made public yet but does anyone know if sys.sysindexes is still available in...
--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 16, 2019 at 1:24 am

#3644079
Reply To: Are the posted questions getting worse?

I can't find any documentation on it because the official 2019 deprecated features hasn't been made public yet but does anyone know if sys.sysindexes is still available in 2019?
--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, 2019 at 4:10 am

#3641751
Reply To: Are the posted questions getting worse?

Sorry... double posted. Removed the dupe.

--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, 2019 at 4:05 am

#3641750
Reply To: Are the posted questions getting worse?

Michael L John wrote:
Pittsburgh SQL Saturday is now official https://www.sqlsaturday.com/907/EventHome.aspx
Cool. I got the email on it. How much lead time do you recommend for a precon announcement?

--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, 2019 at 4:03 am

#3641745
Reply To: Are the posted questions getting worse?

Sean Lange wrote:
Ed Wagner wrote:
Sean Lange wrote:
No kidding. It makes for some interesting things from time to time to say the least.
Sorry, Sean, but knowing a bit about the baan-like environment you're...
--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 13, 2019 at 6:39 pm

#3641642
Reply To: Process suddenly failing with permissions error [SOLVED]

Cool. Thanks for posting what you found.
--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 13, 2019 at 6:36 pm

#3641641

Viewing 15 posts - 9,286 through 9,300 (of 59,091 total)