Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,656 through 2,670 (of 59,086 total)

Reply To: What's the CEIP?

If you had the answer of "Big Brother is watching", more people might have gotten a correct answer. 😀
--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 7, 2022 at 7:26 pm

#4096737
Reply To: I must be loosing my mind. Odd data issue
Keep it simple...
```
--===== Find all items in Prod1 that are not in Prod2
 SELECT * FROM prod1.xxx.dbo.guest
 EXCEPT
 SELECT * FROM prod2.xxx.dbo.guest 
;
--===== Find all items 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 6, 2022 at 9:58 pm

#4096410
Reply To: How to insert data from same set of tables selecting different id from the same

You have 1 common StudentAccKey with 1 common StudentKey and 1 common StartDate.
And yet there are two StudentID's and six different StudentName's.
The code that you're using to get the data...
--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 6, 2022 at 9:53 pm

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

Viewing 15 posts - 2,656 through 2,670 (of 59,086 total)