Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,641 through 2,655 (of 59,067 total)

Reply To: 2 almost identical queries (with a TVF) produce wildly different performance!

Oh lordy... I should have known. Good luck there, Don. And thanks for posting the original problem... this has been and continues to be a really interesting problem and, once...
--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)

October 4, 2022 at 5:19 pm

#4095465
Reply To: How to get record based on nearest date in SQL

pelusch wrote:
OK, I will try to make this clear. The dates in my tables have timestamps including milliseconds which makes it almost impossible that one date in Table A would...
--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)

October 4, 2022 at 3:26 pm

#4095398
Reply To: how to use Space or Tab :b Matches either space or tab characters.

rajemessage 14195 wrote:
like [ \t] is used for spaces and tabs, is there anything for finding carriage return in TSQL
ex
where Result =
'Uwon'
For T-SQL, Yes... search for CHAR(10) for the newline character...
--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)

October 4, 2022 at 3:12 pm

#4095397
Reply To: 2 almost identical queries (with a TVF) produce wildly different performance!

Amazing. I wonder if this is a "feature gone awry".
The biggest difference in the execution plans is that the one with the comments contains "ContainsInterleavedExecutionCandidates = True" and the 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)

October 3, 2022 at 10:03 pm

#4095069
Reply To: How to get record based on nearest date in SQL

I'm still interested in the question the Kaj asked above. Basically, what do you want to do if the there's a tie of dates at one end or the other...
--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)

October 3, 2022 at 9:25 pm

#4095056
Reply To: undocumented syntax?

jcelko212 32090 wrote:
This was called a singleton SELECT in Standard SQL and it loaded one row into local storage. Microsoft generalized it.
You need to be a bit specific about what 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)

October 3, 2022 at 3:28 pm

#4094902
Reply To: How to calculate orders historically, during month

Zond Sita wrote:
Hello Zeff Afternoon,

BWAAA-HAAA-HAAA!!! Four letters in my name and you won't even take the time to get that right. 🙁 Sorry... moving 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)

October 2, 2022 at 8:23 pm

#4094610
Reply To: How Important is Software?

Michael Taubman wrote:
I bought a Corsair mechanical keyboard for the same reasons. Never again. The keyboard is fine, the software is nigh unusable. This is not hyperbole. It is, hands down,...
--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)

October 2, 2022 at 8:21 pm

#4094609
Reply To: undocumented syntax?

Actually, SELECT INTO is very explicitly documented and incredibly useful (especially for building Temp Tables without having to use CREATE TABLE). See the following link...
https://learn.microsoft.com/en-us/sql/t-sql/queries/select-into-clause-transact-sql
To quote from the 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)

October 2, 2022 at 8:08 pm

#4094608
Reply To: How to calculate orders historically, during month
It would be nice if the example data script actually worked. 😉 Here are the results then I try to load the data for the Customer_Orders.
```
Msg 2627,...
```
--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)
October 1, 2022 at 10:27 pm

#4094438
Reply To: How and where did you learn SQL from?

VladBar wrote:
Could you give me advice on where I should learn SQL and Python to become high-skill engineer?
Most tutorials and courses seem here to focus on the querying part 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)

October 1, 2022 at 10:07 pm

#4094436
Reply To: Clearing the pending transaction from the Replication logs before taking the bkp

SQL_Hunt wrote:
Hello,
Before migrating the databases to the new servers, if I need to make sure that all the pending transactions from the Replication queue logs are cleared, so that 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)

October 1, 2022 at 4:38 pm

#4094386
Reply To: Clearing the pending transaction from the Replication logs before taking the bkp

wrote:
This works really well for us, thank you!
Smells like a preamble to SPAM.
--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)

October 1, 2022 at 4:37 pm

#4094385
Reply To: Query plans

sqlguru wrote:
There is more than 1 plan for a particular query. I suspect it could be auto stats is sampling too low so enabling the persistent sampling. Any thoughts?
It could...
--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)

October 1, 2022 at 4:33 pm

#4094384
Reply To: Query plans

wrote:
A commitment of appreciation is all together for the method, it turned out just immeasurable for me moreover!
Yeah... I'm thinking pre-amble to SPAM here.
--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)

October 1, 2022 at 4:30 pm

#4094383

Viewing 15 posts - 2,641 through 2,655 (of 59,067 total)