Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,871 through 6,885 (of 59,072 total)

Reply To: How to do User Defined Function take input as text and output text and numbers ?

If the data is that consistent (some decimal value followed by character values with no spaces), no loops required, UDF scalars, or other forms of RBAR required. Just go for...
--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)

June 18, 2020 at 3:19 am

#3764074
Reply To: All info about all Extended Events on the server - how can i get it via a query?

I think that one of the best answers (other than, of course, "It Depends) comes in the form of a suite of tools by Mr. Brent Ozar. I just refer...
--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)

June 18, 2020 at 2:08 am

#3764067
Reply To: Two Strings compare using t-sql

schleep wrote:
Wow. So simple now.
Still labouring in 2008, our next version is supposed to be 2016, with no set date for that.
I figure I'll be able to start using STRING_AGG...
--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)

June 17, 2020 at 8:03 pm

#3763989
Reply To: Script specific stored procedures

Either that or look into sys.SQL_Modules, which is a system object that comes with SQL Server and can be interrogated using T-SQL.
--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)

June 17, 2020 at 6:03 pm

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

jasona.work wrote:
Eirikur Eiriksson wrote:
jasona.work wrote:
And now, how to put the brakes on a migration project...
Break your wrist on a bicycle ride so you only have one hand to type with 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)

June 17, 2020 at 5:50 pm

#3763956
Reply To: Project EVERYTHING is assigned to me. Can I measure Everything via T-SQL? How?

VoldemarG wrote:
Quick question: Why/for what benefit(S) should I do this?
2. After building the stored procedure, you need to run the following code to convert it into a "system" stored
procedure 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)

June 17, 2020 at 5:47 pm

#3763954
Reply To: SQL Server Fragmentation- Defragment

Mr. Brian Gale wrote:
That being said, I run SQL 2016 standard so have not had the chance to play with partitions, so someone with more experience in partitions can probably help 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)

June 17, 2020 at 7:24 am

#3763785
Reply To: I Read Quite a Bit

Grant Fritchey wrote:
Jeff Moden wrote:
From the Article...
Yet, all the responses were either blatantly wrong, or answering different questions.
Heh... this happens during meetings, as well. Someone goes off on a tangent or 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)

June 16, 2020 at 3:17 pm

#3763501
Reply To: adding a Select statement to an existing table

atulyan.aries wrote:
no tools
Ok then... let's reword the question... how are you producing the scripts that you cite in your original 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)

June 15, 2020 at 10:37 pm

#3763312
Reply To: ISNULL clause with a condition

Erland Sommarskog wrote:
Jeff Moden wrote:
If this is being used in the SELECT list of a query,
Jeff, if that is part of a SELECT list, what SQL dialect would that 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)

June 15, 2020 at 10:34 pm

#3763311
Reply To: Sum days for fiscalyear

Jeff Moden wrote:
cbrammer1219 wrote:
I've attached a screen shot of the table definitions.
Ya know... If you were to post an actual CREATE TABLE bit of code for the pertinent columns for this...
--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)

June 15, 2020 at 10:21 pm

#3763308
Reply To: Sum days for fiscalyear

Understood and agreed but, like was said in an article this morning, "There's nothing more permanent than a temporary fix". It's truly unfortunate that that made the same mistake 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)

June 15, 2020 at 10:19 pm

#3763307
Reply To: ISNULL clause with a condition

"It Depends". If this is being used in the SELECT list of a query, you can do pretty much as you please and you'll have no problems. If it's 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)

June 15, 2020 at 3:59 pm

#3763200
Reply To: I Read Quite a Bit

From the Article...
Yet, all the responses were either blatantly wrong, or answering different questions.
Heh... this happens during meetings, as well. Someone goes off on a tangent or with some really...
--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)

June 15, 2020 at 3:30 pm

#3763188
Reply To: adding a Select statement to an existing table

Phil Parkin wrote:
Jeff, to which article are you referring?
Sorry... post removed. Apparently I replied on the wrong thread.

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

June 15, 2020 at 3:25 pm

#3763184

Viewing 15 posts - 6,871 through 6,885 (of 59,072 total)