Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,196 through 3,210 (of 59,098 total)

Reply To: Which Work Is Suited for In-Person?

From the Aritcle:
What work is suited for live, in-person interaction? Which aspects of your job benefit from seeing others face-to-face?
BWAAA-HAAA-HAAA!!! I can think of no thing that would prove...
--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 15, 2022 at 3:23 pm

#4063847
Reply To: Parsing a lange XML data-column from one server to another

Jonathan AC Roberts wrote:
Can you just create a linked server in SSMS, then just do an "insert into select * from" command in SSMS?
If you cannot create a linked server then, if...
--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 15, 2022 at 3:14 pm

#4063846
Reply To: Left Join with reference data.

My question would be, why are you using two tables to do one thing? It looks to me like it should be a single table because there appears to be...
--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 15, 2022 at 3:02 pm

#4063845
Reply To: Parsing a lange XML data-column from one server to another

kaj wrote:
Even though the MS documentation states that literals longer than 4000 characters are cast as NVARCHAR(MAX) this doesn't seem to be the case.
Constants (Transact-SQL) - SQL 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 15, 2022 at 4:08 am

#4063620
Reply To: Cost of Transactional Replication at the Publisher

I've searched for a more recent document that mentions performance in terms of overhead percentages but found none. I wouldn't expect to see such a thing from future MS documentation...
--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 14, 2022 at 5:08 pm

#4063428
Reply To: Parsing a lange XML data-column from one server to another

gkramer 23701 wrote:
Write-output from the PS script:
INSERT INTO XML_REPORT_ALL ( logdate, Report, runnum, servername ) VALUES ( '07/11/2022 11:43:12','<LOG><ALG><ROW><CUSTOMER>... many more info here..... TYPE><','5','COURSE-SQLSERVER' )
I guess I'll never understand why people...
--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 14, 2022 at 4:58 pm

#4063398
Reply To: Does the order of where clauses matter?

To add to what ratbak and Grant have stated, the other thing that paying attention to the order of the criteria in the WHERE helps with troubleshooting. Yeah... I know...
--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 14, 2022 at 4:31 pm

#4063388
Reply To: how to call a scalar function without schema in sqlserver 2019

ratbak wrote:
No: "Scalar functions must be invoked by using at least the two-part name of the function (<schema>.<function>)"
Why are you even trying to work around this? You should preface...
--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 14, 2022 at 4:23 pm

#4063382
Reply To: How to Find the Start and End Dates for the Current Week (and more)

@thisisfutile
I'm truly humbled by your thoughtful comments and the references to a couple of articles. I really appreciate the feedback and... I'm glad I could make you laugh! 😀 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)

July 14, 2022 at 3:57 pm

#4063371
Reply To: While Loop Data Issue

mcfarlandparkway wrote:
How to loop the data based on start and end dates below?
Declare @StartDate Datetime Declare @EndDate Datetime
Select @StartDate = '20220611' SET @EndDate = GETDATE()
WHILE @StartDate < = @EndDate BEGIN...
--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 14, 2022 at 3:45 pm

#4063367
Reply To: Please help to get, Alphabet with underscore i.e special charecter

Thanks for the feedback 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)

July 14, 2022 at 3:23 pm

#4063334
Reply To: How to get last 5 weeks start and end dates

@mcfarlandparkway
Did that work for 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)

July 14, 2022 at 3:22 pm

#4063333
Reply To: Please help to get, Alphabet with underscore i.e special charecter

Steve Collins wrote:
Afaik this actually produces the desired output. Should work with SQL 2014. It uses the ordinal splitter DelimitedSplit8K_Lead. The query: splits the input string on '_' underscore, finds 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)

July 14, 2022 at 2:00 pm

#4063292
Reply To: Please help to get, Alphabet with underscore i.e special charecter

ScottPletcher wrote:
A couple of potential issues: if there's an additional period (.) in the file name and/or an underscore in the extension.
At least it produces the correct output when using...
--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 14, 2022 at 12:59 pm

#4063272
Reply To: How to get last 5 weeks start and end dates

mcfarlandparkway wrote:
Example - When i run the query today 7/13/2022
I am looking for start and end dates to be June 11, 2022 that is saturday to July 9, 2022 saturday....
--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 14, 2022 at 2:49 am

#4063051

Viewing 15 posts - 3,196 through 3,210 (of 59,098 total)