Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,091 through 9,105 (of 59,067 total)

Reply To: Best practice(s) for refreshing data in several tables

lbhlittleton wrote:
Hi, It might be worth looking at Partition Switching as a possible option as well: https://www.jamesserra.com/archive/2012/07/sql-server-table-partition-switching/
How will partition switching help you between databases?
--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, 2019 at 1:47 pm

#3655768
Reply To: What causes a query to suddenly start performing poorly
TangoVictor wrote:
Jeff, thank you for all the info and your time it's greatly appreciated!
1. plans attached as xml, sqlplan is not allowed
2. will start looking at that, that's a lot...
--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, 2019 at 5:07 am

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

Jason A. Long wrote:
Jeff Moden wrote:
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...
--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 9:07 pm

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

Luis Cazares wrote:
Be honest, was this one of you? https://www.newsweek.com/drunk-poland-soviet-tank-1444475
Not me... but I want one.
--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 9:03 pm

#3655494
Reply To: How to use Tally Table to allocate quantity?

I'm pretty sure that a Tally table solution for this wouldn't be the preferred solution. There is a set based solution. See the winning entry at the bottom of 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 7:56 pm

#3655453
Reply To: Status Update 19 Jun 2019

Thanks for the update, Steve.
--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:48 pm

#3655449
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

Viewing 15 posts - 9,091 through 9,105 (of 59,067 total)