Jeff Moden

Forum Replies Created

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

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
Reply To: Query to Kill sessions running a particular query text

caz100 wrote:
I just need to include where the sql text like "%select blah blah blah%
I'm curious... WHY?
--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 1, 2021 at 11:56 pm

#3864612
Reply To: DATEDIFF() for times over a day long

Sergiy wrote:
Just remembered a thing about insufficiently specified requirements.
A wife sends her husband to a grocery shop:
- Buy a loaf of bread and if there will be eggs buy a...
--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 1, 2021 at 9:25 pm

#3864574
Reply To: SQL Agent Job is stuck
John Esraelo-498130 wrote:
Hello,
Here is the situation.
- SQL 2019 enterprise on datacenter server
- agent is running
- test job has 1 line; select getdate() or running a SPROC with the same line
- 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)
April 1, 2021 at 8:48 pm

#3864571
Reply To: Are the posted questions getting worse?

Michael L John wrote:
By the way, today is Steve Jones birthday!!
Happy Birthday!!!
Are you old enough to know better yet??
If that's true, Happy Birthday, 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)

April 1, 2021 at 8:44 pm

#3864570
Reply To: Are the posted questions getting worse?

ChrisM@Work wrote:
Hi folks
I can't find anywhere else to ask this, so here it is. SQL Server 2017 Standard Edition is restricted to 24 cores. Does this mean that the licencing...
--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 1, 2021 at 8:43 pm

#3864569
Reply To: Are the posted questions getting worse?

jasona.work wrote:
Ed Wagner wrote:
jasona.work wrote:
Sergiy wrote:
I guess what you’re asking for is the amount of space actually used by data pages within the space allocated to db files of your databases.
To...
--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 1, 2021 at 8:40 pm

#3864568
Reply To: How to move an empty partition on a partitioned table.

ScottPletcher wrote:
Sorry, I just have to ask: why would logical file name(s_ need to be preserved? Are they hard-coded in some existing statements? That seems dangerous, what if files are...
--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 1, 2021 at 5:43 pm

#3864509
Reply To: How to move an empty partition on a partitioned table.

Saints be praised. I'm allowed up to a 15 minute outage at 9 tonight. I couldn't use Scott's suggestion 100% because I can't have two files with the same logical...
--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)

March 31, 2021 at 11:35 pm

#3864185
Reply To: How to move an empty partition on a partitioned table.

Thanks to both of you. I'll take a look. I really appreciate 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)

March 31, 2021 at 8:07 pm

#3864143

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