Jeff Moden

Forum Replies Created

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

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
Reply To: Delete is very slow

Guras wrote:
Yes, the indexing on the FOREIGN KEY on the referencing tables did it. Thank you !
Awesome. Thanks for the feedback.
--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 3:44 pm

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

Michael L John wrote:
While we are on the subject of 4 part names and consistency across environments, it reminds me of a DBA who I had the pleasure(!) of following three separate...
--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 3:42 pm

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

Brandie Tarvin wrote:
That's why we don't use server names as linked server names. We use names (like Reports) that can remain consistent regardless of the environments. EDIT: The linked server...
--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 3:37 pm

#3641551

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