Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,721 through 6,735 (of 59,091 total)

Reply To: SQL View Question

TheProof wrote:
Thank for the many replies....the idea is show the first row of others. The point is that I need to "call" same columns just to apply a filter into...
--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)

July 27, 2020 at 4:59 pm

#3775054
Reply To: SQL View Question

WHICH ONE RECORD would be the right one to show? Should it be based on one of the dates in columns for those tables? If so, which column?
--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)

July 27, 2020 at 1:30 pm

#3774971
Reply To: SQL Server Hardware Recommendation

With the trainwreck of junk that can't be deleted that Windows Updates leaves behind, I'd allocate 300GB for the OS drive and make bloody sure that SQL Server was installed...
--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)

July 27, 2020 at 1:25 pm

#3774967
Reply To: Transfer data (views) between databases in offline scenario
werner.huysmans wrote:
Hi Jeff,
yes, I can use xp_CmdShell. We do that already for some other stuff.
1. Set up a stored procedure to produce the output that you want to send to...
--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)
July 27, 2020 at 12:54 pm

#3774938
Reply To: Transfer data (views) between databases in offline scenario

werner.huysmans wrote:
🙂
Well, thanks, Jeff, that sounds promising, and I definitely want to hear about it now...
Can you point me in the right direction just a little bit further?
Are you allowed...
--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)

July 27, 2020 at 5:30 am

#3774872
Reply To: Transfer data (views) between databases in offline scenario

Erland Sommarskog wrote:
And if you use BCP or SQLCMD to write the files, you may be in for a battle until you get it write.
I don't know why people think 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)

July 27, 2020 at 5:28 am

#3774871
Reply To: Transfer data (views) between databases in offline scenario

Erland Sommarskog wrote:
Why jump out from SQL Server to call them, when you much easier can call them from the outside directly without going through SQL Server?
Because it's easy... easy to...
--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)

July 27, 2020 at 5:27 am

#3774870
Reply To: Transfer data (views) between databases in offline scenario

werner.huysmans wrote:
Yes, the files are transferred, that's not my main concern.
It seems so crazy to me that I can generate all the info I need in just a single, very...
--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)

July 26, 2020 at 8:39 pm

#3774840
Reply To: Trying to Make combinations within a bracket in SSMS column

Steve, I wasn't talking about the expansive output. I was talking about the test code generator.
Shifting gears, the OP provided no example of a left string having more than 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)

July 26, 2020 at 8:35 pm

#3774839
Reply To: slow query on a partitioned table

ghostman wrote:
I have a huge table with 3B of rows containing around 6 months of data running on Microsoft SQL server 2017 (RTM), which is partitioned day by day on...
--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)

July 26, 2020 at 2:20 am

#3774788
Reply To: Trying to Make combinations within a bracket in SSMS column

Steve Collins wrote:
Jason A. Long the "s3 string" characters which appear after the brackets do not appear in any of the OP's example rows. Imo that's a made up requirement which...
--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)

July 25, 2020 at 9:07 pm

#3774761
Reply To: Trying to Make combinations within a bracket in SSMS column

carsten.saastamoinen wrote:
I will stop now as it is obviously important for you to prove that tally is the only solution. Your tests are based on the fact that the function...
--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)

July 25, 2020 at 3:41 pm

#3774739
Reply To: Trying to Make combinations within a bracket in SSMS column

Yep. Understood. And, I agree... more core and ram isn't going to change the problem with compile times. But, so far, no one has played with more than about 6...
--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)

July 24, 2020 at 10:04 pm

#3774582
Reply To: SSIS 4 Minute Job Takes Over 19 *Hours* on New Server

JJ B wrote:
I had been told by people in my agency that my new server was at least good as the old one. However, when the consultant compared the old 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)

July 24, 2020 at 9:23 pm

#3774566
Reply To: Trying to Make combinations within a bracket in SSMS column

carsten.saastamoinen wrote:
In Azure, we also have limited resources!
Hey there, Carsten. I really appreciate that you have limited resources in Azure. It's taking me a while (had to write some code...
--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)

July 23, 2020 at 9:18 pm

#3774272

Viewing 15 posts - 6,721 through 6,735 (of 59,091 total)