Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,301 through 9,315 (of 59,102 total)

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
Reply To: Total Field On Monthly Grouped Matrix

I can't speak to using a matrix because I don't use SSRS. I do write stored procedures to provide info to SSRS and Excel, etc. If it were me, I'd...
--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 4:30 pm

#3641594
Reply To: Preventing a SELECT

Stewart "Arturius" Campbell wrote:
Nice, easy one to start the week on, thanks Steve
At the time of this post, I see that 18% (a whopping 42 out of 230) of the folks 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 13, 2019 at 4:22 pm

#3641591
Reply To: Preventing a SELECT

Bill wrote:
"other people will want access". Could you be a little more specific as to whether you intend to provide access to those people?
It doesn't actually matter. Whether that possibility...
--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 4:19 pm

#3641588
Reply To: Backup Job Performance

Let's stop an think about this... the backups didn't use to be a problem and moving to the new hardware is now causing a problem. It could be anything from...
--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 4:15 pm

#3641586

Viewing 15 posts - 9,301 through 9,315 (of 59,102 total)