Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,121 through 9,135 (of 59,091 total)

Reply To: Notification of zero records in a table

I've not tried RCSI yet but, from what I've read, it seems like a really expensive solution especially where imports are concerned.
--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, 2019 at 7:42 pm

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

It's amazing how common such posts are becoming.
--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, 2019 at 7:38 pm

#3655447
Reply To: Are these good and appropriate data types?

ScottPletcher wrote:
You can also use a computed column for as_of_month, there's no need to physically store it again. as_of_date date NOT NULL, as_of_month AS CONVERT(varchar(6), as_of_date, 112), That column 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)

June 19, 2019 at 7:14 pm

#3655443
Reply To: Notification of zero records in a table

Steve Jones - SSC Editor wrote:
I like the synonyms, maybe with an Agent job that does the work to check/repoint. I'd think the Java app wouldn't need to know, just load the empty table....
--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, 2019 at 7:10 pm

#3655436
Reply To: The Worst Comments

Steve Jones - SSC Editor wrote:
mike.sortino wrote:
I think it is a ridiculous waste of time when someone comments on the obvious, like: counter++; // increment counter Really??
I blame professors are unis for this....
--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, 2019 at 7:05 pm

#3655433
Reply To: Query help

Your original post clearly defined what you wanted to do. It also acts as pseudo-code for what needs to be written. When you run into something like this, at least...
--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, 2019 at 1:31 pm

#3655273
Reply To: Slower is Faster

And, David, thank you for the Ron Jeffries link... in particular, I really like his post on technical dept (included below).
https://ronjeffries.com/articles/019-01ff/tech-debt/
Again, there is no button that could give 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 19, 2019 at 12:37 pm

#3655250
Reply To: Slower is Faster

David.Poole wrote:
Where I work the dashboards and performance metrics for production applications and infrastructure is available to all in all environments. Being told something is one thing. Being shown 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)

June 19, 2019 at 12:24 pm

#3655201
Reply To: What causes a query to suddenly start performing poorly

A couple of things there...
First, there's that Cost Threshold of Parallelism thing. 5 is way too low. I have a mixed OLTP and Batch Processing system and I've found 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)

June 19, 2019 at 12:15 pm

#3655198
Reply To: Notification of zero records in a table

Budd wrote:
Sounds like a great idea, thanks Jeff. I've never used synonyms, this should be fun 🙂
The NAME of the synonym would be whatever the original table was before you...
--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 18, 2019 at 3:28 pm

#3654800
Reply To: Slower is Faster

BWAAA-HAAA! I've actually not heard that one before, David. I'm going to remember that one!
Shifting gears a bit and on the subject of people saying "There is no "I" 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)

June 18, 2019 at 2:17 pm

#3654769
Reply To: Slower is Faster

Too funny.
On a similar note, I'm not one to use Hungarian Notation (Phil Factor calls it "tbl-ing") for object names but I ran into a bit of a dilemma quite...
--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 18, 2019 at 1:57 pm

#3654757
Reply To: Slower is Faster

Phil Parkin wrote:
MVDBA (Mike Vessey) wrote:
Jeff Moden wrote:
MVDBA (Mike Vessey) wrote:
while it's slightly off topic, I worked with a team that mixed the V model (kinda like waterfall) and agile.. it had an unfortunate nickname of...
--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 18, 2019 at 1:43 pm

#3654751
Reply To: Slower is Faster

Heh... I was in the military a long time ago. I got used to strange names that had weird abbreviations. Even my Dad had to put up with some of...
--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 18, 2019 at 11:34 am

#3654704
Reply To: 15466 error when executing xp_cmdshell with non sysadmin user

rVadim wrote:
Thank you, Jeff, very useful info.
Thanks for the feedback, rVadim.
--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 18, 2019 at 11:20 am

#3654689

Viewing 15 posts - 9,121 through 9,135 (of 59,091 total)