Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,671 through 2,685 (of 59,098 total)

Reply To: How to run a query multiple times with different values in date

sailormonkey wrote:
I'm very new to the sql and am wondering what is the easiest way to run the same query multiple times with different dates (ideally is the last day...
--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 5, 2022 at 5:41 pm

#4095919
Reply To: SQL Server Windows NT - 64 bit" in Task Manager: CPU high

I've found that the "sweet spot" for the 32 core machine at one of the companies I do work for is a MAXDOP of 4. Their biggest problem is 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)

October 5, 2022 at 5:29 pm

#4095916
Reply To: Azure SQL backup policy strategies and best practices?

Awesome link and explanation, Grant. Thank 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)

October 5, 2022 at 5:07 pm

#4095914
Reply To: Shrink database issue

Jeff Moden wrote:
Let's ask the question... how often do the "temp tables" appear? Let's also ask, why do you have "temp tables" of such a size to begin with?
The reason I'm...
--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 5, 2022 at 4:50 pm

#4095896
Reply To: Add more columns to output

Bruin wrote:
Any help on this request... I tried to goggle but didn't see examples...
Thanks.
I think the problem is that people doubt your claim. Case in point...
https://www.google.com/search?q=Get+backup+status+for+multiple+sql+servers+using+powershell

--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 8:22 pm

#4095518
Reply To: Shrink database issue

Let's ask the question... how often do the "temp tables" appear? Let's also ask, why do you have "temp tables" of such a size to begin with?
--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 8:11 pm

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

Viewing 15 posts - 2,671 through 2,685 (of 59,098 total)