Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,446 through 5,460 (of 59,098 total)

Reply To: Using REVERSE

@sqldummy79 ,
No matter what we use, the test table is incomplete. Each row needs to have something that uniquely identifies each row as it appears in the original source table. ...
--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)

April 7, 2021 at 3:46 pm

#3866420
Reply To: Using REVERSE

Mr. Brian Gale wrote:
Since you are using SQL Server 2019, would "string_split()" function suit your needs?
https://docs.microsoft.com/en-us/sql/t-sql/functions/string-split-transact-sql?view=sql-server-ver15
The trouble with STRING_SPLIT() is that it does not return the ordinal position of the elements 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)

April 7, 2021 at 3:15 pm

#3866403
Reply To: What to expect on first day of PL SQL at new firm?

ns550 wrote:
Hi All,
Looking for answer on what do I expect to happen on very first day for PL SQL job role, given 5 years of experience in resume. Because it...
--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)

April 7, 2021 at 3:10 pm

#3866401
Reply To: Odd performance issues

What version of SQL Server were you using on the old server and what are you using on the new server? This is really important because a new "Cardinality Estimator"...
--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)

April 6, 2021 at 4:19 pm

#3866023
Reply To: Query optimisation/execution plan

No. Using (*) as a part of a COUNT is NOT discouraged. It will allow SQL Server to pick the best index to use to accomplish the count. The use...
--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)

April 6, 2021 at 4:14 pm

#3866021
Reply To: Big difference between Estimated and Actual Actual rows in execution Plan.

It's because <insert drumroll here>, it's an "Estimate". 😀
It's like asking someone how many wheels there are on their truck. Because of "statistics" on the subject and you've identified it...
--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)

April 6, 2021 at 2:16 pm

#3865966
Reply To: admin account and pwd

Johan Bijnens wrote:
SSMS-Setup-ENU.18.8.exe /Passive DoNotInstallAzureDataStudio=1 /install /quiet /norestart /log SSMS_install.log
ref: last line of this paragraph
Awesome. Thanks, Johan.
--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)

April 6, 2021 at 2:10 pm

#3865965
Reply To: SQL Agent Job is stuck

Sergiy wrote:
I created [_sandbox] database for this purpose, deployed the script and scheduled it to run every minute.
It's been 15 or 20 executions since then - no issues.
I'm telling 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)

April 6, 2021 at 2:09 pm

#3865964
Reply To: SQL Agent Job is stuck

Once I fixed all the < and > entitizations and changed the database name to one of the one I have, it ran first time with no issues. I wonder...
--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)

April 6, 2021 at 3:50 am

#3865797
Reply To: If Statement in Computed Column

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

April 4, 2021 at 4:09 am

#3865192
Reply To: insert column data from one table, parse and insert into other table

jim0211 wrote:
I have a csv file that is input into a varchar(max) column in an Azure SQL Database table. When the file is inserted into this table column I 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)

April 4, 2021 at 3:40 am

#3865188
Reply To: If Statement in Computed Column

Use CASE instead.
--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)

April 4, 2021 at 3:25 am

#3865181
Reply To: Using NOLOCK in UPDATE or DELETE

frederico_fonseca wrote:
my take on this is " if you need to ask if NOLOCK should/can be used on a particular case then you do not know about it's issues and...
--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)

April 3, 2021 at 10:03 pm

#3865144
Reply To: admin account and pwd

carolynperry wrote:
An admin account has privileges to manage services for other people in your organization. The Admin console is only available when you're signed in to an admin account. 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)

April 3, 2021 at 9:45 pm

#3865139
Reply To: admin account and pwd

Jeffrey Williams wrote:
Download and install SSMS (includes Azure Data Studio now)
Bit of a sidebar question on my part because I've not installed nor even downloaded SSMS since they made that change...
Do...
--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)

April 3, 2021 at 9:38 pm

#3865138

Viewing 15 posts - 5,446 through 5,460 (of 59,098 total)