Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,061 through 12,075 (of 59,099 total)

RE: Logging options while running stored procedure

sgmunson - Wednesday, June 20, 2018 9:22 AM
george_at_sql - Tuesday, June 19, 2018 9:15 PM
--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)

June 20, 2018 at 10:02 am

#1994675
RE: Logging options while running stored procedure

Heh... holy moly... I think I just wrote a bloody article on the subject. Guess I'll convert it and submit it. 😀
--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)

June 20, 2018 at 10:01 am

#1994674
RE: Logging options while running stored procedure

george_at_sql - Tuesday, June 19, 2018 9:15 PM
Jeff Moden - Tuesday, June 19, 2018 3:03 PM
--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)

June 20, 2018 at 9:48 am

#1994671
RE: Bureaucracy madness

Heh... been there and done that. I absolutely feel for you. It's amazing how company mergers can destroy a culture.
Have you spoken with your boss about your...
--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)

June 20, 2018 at 7:29 am

#1994634
RE: Are the posted questions getting worse?

TomThomson - Friday, June 1, 2018 12:31 PM
Brandie Tarvin - Friday, May 25, 2018 7:41 AM
--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)

June 20, 2018 at 6:01 am

#1994600
RE: SELECT or GROUP BY LIKE

While ranitb's solution will work, you're going to run into problems doing the similarity check based only on the leading word or even a couple of words. There will also...
--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)

June 20, 2018 at 5:45 am

#1994595
RE: Looking for some thoughts on design for db table renaming.

dudekula.kareemulla - Wednesday, June 20, 2018 4:36 AM
Basically, we have a 2 tables. One is being used by the app for querying...
--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)

June 20, 2018 at 5:39 am

#1994594
RE: Jobs You Wouldn't Expect To Be Threatened By Tech But Are

KGERBR - Tuesday, June 19, 2018 2:52 PM
This just in ... the bots can "debate" with you now:
https://www.ctvnews.ca/sci-tech/ibm-computer-proves-formidable-against-2-human-debaters-1.3979418
I was truly amazed...
--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)

June 19, 2018 at 8:16 pm

#1994562
RE: Bureaucracy madness

Do you spend any time outside of work, on your own, learning new features?
--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)

June 19, 2018 at 7:37 pm

#1994560
RE: Taking backup with option "Disk = nul"

Why not just change the Dev database to the SIMPLE recovery model?
--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)

June 19, 2018 at 3:19 pm

#1994556
RE: Logging options while running stored procedure

Heh.... "Updated_By". One of the most commonly overlooked reasons for massive fragmentation both physical and logical.
--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)

June 19, 2018 at 3:03 pm

#1994550
RE: Bureaucracy madness

How many hours per day do you work?
--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)

June 19, 2018 at 2:48 pm

#1994547
RE: Jobs You Wouldn't Expect To Be Threatened By Tech But Are

Eric M Russell - Tuesday, June 19, 2018 1:26 PM
jay-h - Tuesday, June 19, 2018 8:52 AM
--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)

June 19, 2018 at 2:32 pm

#1994544
RE: Joining a large table to itself....better ideas?

So far, we've all speculated. What we need is to hear from the OP as to a wee bit more detail about the DDL for the table, number of rows,...
--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)

June 19, 2018 at 1:57 pm

#1994538
RE: Joining a large table to itself....better ideas?

xsevensinzx - Monday, June 18, 2018 7:41 PM
Jeff Moden - Monday, June 18, 2018 2:32 PM
--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)

June 19, 2018 at 1:06 am

#1994388

Viewing 15 posts - 12,061 through 12,075 (of 59,099 total)