Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,981 through 4,995 (of 59,101 total)

Reply To: Index fragmentation on all databases

Heh... I make mistakes of that nature prior to having at least 2 full 12 oz mugs of coffee. That means it's been happening a whole lot to me lately...
--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 12, 2021 at 4:29 pm

#3907058
Reply To: Index fragmentation on all databases

Rune Bivrin wrote:
You know, I kind of prefer the kinds of questions where there is a way to answer the question 😀
This wasn't someone posting a question. This site allows folks...
--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 12, 2021 at 2:42 pm

#3907021
Reply To: text column in date format in excel to datetime column in sql server via SSIS

Jeffrey Williams wrote:
Since SSIS is not SQL - it isn't the same - and the code is not processed as SQL code. Since the data is in the file - 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 11, 2021 at 10:04 pm

#3906762
Reply To: Cursor replacement suggestions

Go back to your first post... see that cursor definition you posted? Yeah... we need to know what you're trying to do with the data that cursor gathers. We don't...
--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 11, 2021 at 9:57 pm

#3906761
Reply To: Split String into columns
Jeffrey Williams wrote:
Here is a little different take on the solution:
```
 Select [Code]        = ltrim(substring(v.Item, 1, p01.pos - 2))
  ...
```
--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 11, 2021 at 9:04 pm

#3906752
Reply To: Split String into columns
Steve Collins wrote:
Similar to the accepted solution but without the common table expression. It appears Jeff began to code it one way and then switched
```
select max(case when sp2.ItemNumber=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)
July 11, 2021 at 7:28 pm

#3906742
Reply To: Do We Need to Learn Linux?

Heh... "Do We Need to Learn Linux?"
I guess the obvious joke here would be "GOOD SIR!!! CONTAIN YOURSELF!!!"

--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 10, 2021 at 11:21 pm

#3906577
Reply To: Permissions needed to run query on master db

My take on it all this is not only "No" but "Hell No".
First of all, it would be a security violation to have a bunch of "unknowns" running a bunch...
--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 10, 2021 at 9:25 pm

#3906541
Reply To: Rows to Column
Thank you for the readily consumable test data. Details for one solution are in the comments in the code below...
```
--===== One solution.
     --...
```
--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 10, 2021 at 8:25 pm

#3906528
Reply To: text column in date format in excel to datetime column in sql server via SSIS
I don't know much about SSIS but there MUST be some easy way to do the following in SSIS just like it's easy in 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)
July 10, 2021 at 7:38 pm

#3906511
Reply To: Split String into columns
```
--===== Test string 
DECLARE @String VARCHAR(8000) = 
' ;T41,Vending,9000011;T42,Laundry,9000012;T43,Car Wash,9000013;T44,Amusement,9000014;T45,Promotion,9000015;T46,Transit,9000016;T47,Other,9000017;T73,?,9000011'
;
--===== Solution
   WITH cteSplit1 AS
(--==== Split the groups out based on the ";" delimiter, not returning...
```
--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 9, 2021 at 5:18 pm

#3906151
Reply To: Clustered vs Nonclustered Columnstore Update Performance

MadOwl wrote:
Add to that that we have ~4000 tables to maintain...
Are they mostly ColumnStore or RowStore?

--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 9, 2021 at 4:45 pm

#3906144
Reply To: when the data of sys.dm_exec_query_stats will be reset/removed

Even Grant will tell you that's just scratching the surface on such things. Before you use one of them, you really need to study the 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 8, 2021 at 9:51 pm

#3905898
Reply To: Clustered vs Nonclustered Columnstore Update Performance

I've not had to work with ColumnStore yet but that sounds perfect, Eric.
--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 8, 2021 at 9:46 pm

#3905895
Reply To: when the data of sys.dm_exec_query_stats will be reset/removed

892717952 wrote:
Jeff Moden wrote:
892717952 wrote:
I notice that even if we don't restart SQL Service, the data of sys.dm_exec_query_stats( sys.dm_exec_sql_text() and sys.dm_exec_query_plan() ) will be reset or removed/refreshed. when the data 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)

July 8, 2021 at 2:37 pm

#3905754

Viewing 15 posts - 4,981 through 4,995 (of 59,101 total)