Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,521 through 2,535 (of 59,098 total)

Reply To: AlwaysOn Availability for Standard Edition and multiple databases

I'm no expert on the subject because we have an "Infrastructure Group" where I work but I wonder if a simple "Clustered Server" would do the trick here. They have...
--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)

November 13, 2022 at 12:21 am

#4112176
Reply To: CASE TRY_CONVERT causes error message

The reason why it produces an error is because the first thing to qualify in the CASE expression is an INTEGER and so the resulting column formed by the CASE...
--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)

November 13, 2022 at 12:02 am

#4112175
Reply To: Adding SQL Variant Data

Tom Uellner wrote:
What happened to the question?
They stored it in an SQL_Variant with the wrong base type. 😀
--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)

November 12, 2022 at 1:44 am

#4111875
Reply To: Using a trigger to create schemas

We have a reporting database. It has 2 schemas... Build1 and Build2. We don't mess around with triggers or the schemas. We created a 2 synonyms for each table... 1...
--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)

November 12, 2022 at 1:43 am

#4111874
Reply To: A varchar(MAX) STRING_SPLIT function for SQL 2012 and above

@jonathan-2,
I recently had reason to revisit this article and I found a bug in the code. It does not preserve leading spaces in the individual elements. If an element is...
--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)

November 11, 2022 at 10:30 pm

#4111835
Reply To: Disable Saving/Exporting Results of TSQL Query in SSMS

Not that I've ever heard of.
--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)

November 11, 2022 at 8:59 pm

#4111799
Reply To: Display values from ntext defined field

Bruin wrote:
could you send a sample of that code?
Thx.
How many characters are in the column that you want to split? I ask because, since your column started off as NTEXT,...
--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)

November 11, 2022 at 8:45 pm

#4111797
Reply To: Display values from ntext defined field

Duplicate post deleted...

--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)

November 11, 2022 at 8:43 pm

#4111796
Reply To: Display values from ntext defined field

Bruin wrote:
Sample data in field:
PartNbr|#@|Machine|#@| ttxx23|#@|plc1|#@| ttxx24|#@|plc2
So it looks like PartNbr|#@|Machine| -- these are the fields Then | ttxx23| -- when it sees a space data starts
partnbr Machine ttxx23 ...
--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)

November 11, 2022 at 6:17 pm

#4111756
Reply To: First wednesday of February & August Every year

Des Norton has the right idea but it can be simplified a bit. You can replace the GETDATE() with a variable in the following, in case you want to turn...
--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)

November 11, 2022 at 5:24 pm

#4111733
Reply To: Display values from ntext defined field

Bruin wrote:
select cast(replace(cast(body as nvarchar(max)),'???','?') as ntext) from lookuptable2 where description like '???%'
I used this template and can see that it did indeed did do the replace, but how 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)

November 11, 2022 at 4:23 pm

#4111697
Reply To: Display values from ntext defined field
frederico_fonseca wrote:
do not use the native string_split - slow and does not return the ordinal of the strings.
Funny thing there... I've never actually tested it for performance because I never...
- This reply was modified 3 years, 10 months ago by Jeff Moden. Reason: Added Wayne Sheffield's post
--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)
November 11, 2022 at 4:16 pm

#4111696
Reply To: Losing Skills Because of Automation

I've found that automation isn't the reason for decreased skills. Rather, I've found that automation is necessary because people simply don't have the skills and, apparently, have little interest 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)

November 11, 2022 at 4:01 pm

#4111692
Reply To: SSAS Tabular migration to GCP

squareoff wrote:
We are considering to replace SSAS Server/Tabular Cubes with a denormalized dataset (e.g. materialized view) in BigQuery.
Why? What "magic" do you folks expect to suddenly occur? Stop an think...
--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)

November 11, 2022 at 6:03 am

#4111264
Reply To: Losing Skills Because of Automation

I don't believe that automation is the cause of a lack of skills. I rather think it's the other way around... Automation has become necessary due to a lack of...
--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)

November 11, 2022 at 5:54 am

#4111256

Viewing 15 posts - 2,521 through 2,535 (of 59,098 total)